CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: requires foreign-key references to correspond to valid referenced keys or permitted NULLs?
A. Referential integrity
B. DEFAULT constraint
C. COMMIT
D. Incremental backup
Correct Answer: A
Referential integrity requires foreign-key references to correspond to valid referenced keys or permitted NULLs.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: requires a relational table's primary key values to identify rows and not be NULL?
A. Domain integrity
B. Isolation
C. Entity integrity
D. Network model
Correct Answer: C
Entity integrity requires a relational table's primary key values to identify rows and not be NULL.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: is any attribute set that uniquely identifies a row, possibly with unnecessary attributes?
A. Transaction
B. Deletion anomaly
C. COMMIT
D. Superkey
Correct Answer: D
Superkey is any attribute set that uniquely identifies a row, possibly with unnecessary attributes.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: is a candidate key not selected as the primary key?
A. Alternate key
B. View
C. ER diagram
D. ROLLBACK
Correct Answer: A
Alternate key is a candidate key not selected as the primary key.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: is an artificial identifier created primarily for database use?
A. Atomicity
B. Lock
C. Entity integrity
D. Surrogate key
Correct Answer: D
Surrogate key is an artificial identifier created primarily for database use.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: uses a real-world meaningful attribute or attributes as a key?
A. Natural key
B. Data mart
C. Hierarchical model
D. Self join
Correct Answer: A
Natural key uses a real-world meaningful attribute or attributes as a key.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: uses two or more columns together to identify a row?
A. Replication
B. Schema
C. Composite key
D. Second Normal Form
Correct Answer: C
Composite key uses two or more columns together to identify a row.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: allows records to participate in multiple parent-child style links forming a graph-like structure?
A. LIKE
B. View
C. Network model
D. Full backup
Correct Answer: C
Network model allows records to participate in multiple parent-child style links forming a graph-like structure.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: organizes records in a tree-like parent-child structure?
A. Hierarchical model
B. Nonrepeatable read
C. CREATE
D. Trigger
Correct Answer: A
Hierarchical model organizes records in a tree-like parent-child structure.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: organizes data primarily into tables composed of rows and columns?
A. Relational model
B. LEFT OUTER JOIN
C. CREATE
D. Candidate key
Correct Answer: A
Relational model organizes data primarily into tables composed of rows and columns.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: stores metadata about database objects, columns, constraints, and related definitions?
A. INSERT
B. Data dictionary
C. Network model
D. Durability
Correct Answer: B
Data dictionary stores metadata about database objects, columns, constraints, and related definitions.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: is data that describes the structure, meaning, or properties of other data?
A. Metadata
B. Transaction
C. Graph database
D. Domain integrity
Correct Answer: A
Metadata is data that describes the structure, meaning, or properties of other data.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: refers to the data stored in a database at a particular moment?
A. Durability
B. Full backup
C. Instance
D. OLAP
Correct Answer: C
Instance refers to the data stored in a database at a particular moment.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: graphically represents entities, attributes, and relationships?
A. Nonclustered index
B. ER diagram
C. UPDATE
D. Data dictionary
Correct Answer: B
ER diagram graphically represents entities, attributes, and relationships.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: allows one parent row to relate to multiple child rows?
A. Entity integrity
B. Candidate key
C. WHERE
D. One-to-many relationship
Correct Answer: D
One-to-many relationship allows one parent row to relate to multiple child rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: allows at most one related row on each side for a given relationship?
A. One-to-one relationship
B. Query optimizer
C. Self join
D. Cardinality
Correct Answer: A
One-to-one relationship allows at most one related row on each side for a given relationship.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: describes how many instances of one entity can be associated with instances of another?
A. CROSS JOIN
B. Cardinality
C. Nonclustered index
D. Consistency
Correct Answer: B
Cardinality describes how many instances of one entity can be associated with instances of another.
CSS - PMS - CCE - PCS - Basic Computing
Cyber Security Basics
Which cybersecurity term best matches this description: automatically checks systems for known weaknesses or misconfigurations?
A. Smishing
B. Vulnerability scan
C. Data classification
D. Baiting
Correct Answer: B
Vulnerability scan automatically checks systems for known weaknesses or misconfigurations.
CSS - PMS - CCE - PCS - Basic Computing
Cyber Security Basics
Which cybersecurity term best matches this description: is an authorized simulated attack used to identify exploitable weaknesses?
A. Patch
B. EDR
C. Penetration test
D. Threat
Correct Answer: C
Penetration test is an authorized simulated attack used to identify exploitable weaknesses.
CSS - PMS - CCE - PCS - Basic Computing
Cyber Security Basics
Which cybersecurity term best matches this description: systematically examines controls, configurations, and evidence against requirements or good practice?
A. Penetration test
B. Authentication
C. Security audit
D. Host-based firewall
Correct Answer: C
Security audit systematically examines controls, configurations, and evidence against requirements or good practice.