CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: horizontally partitions data across multiple servers or nodes?
A. Second Normal Form
B. First Normal Form
C. Sharding
D. Document database
Correct Answer: C
Sharding horizontally partitions data across multiple servers or nodes.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: maintains copies of data on multiple database servers or nodes?
A. Lock
B. Replication
C. Phantom read
D. GROUP BY
Correct Answer: B
Replication maintains copies of data on multiple database servers or nodes.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: restores a database to a chosen time using backups and logs?
A. Stored procedure
B. UPDATE
C. Clustered index
D. Point-in-time recovery
Correct Answer: D
Point-in-time recovery restores a database to a chosen time using backups and logs.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: records database changes so recovery and transactional durability can be supported?
A. UPDATE
B. NOT NULL constraint
C. Candidate key
D. Transaction log
Correct Answer: D
Transaction log records database changes so recovery and transactional durability can be supported.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: uses locks or similar mechanisms assuming conflicts may occur?
A. UNIQUE constraint
B. LEFT OUTER JOIN
C. Pessimistic concurrency control
D. Materialized view
Correct Answer: C
Pessimistic concurrency control uses locks or similar mechanisms assuming conflicts may occur.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: assumes conflicts are infrequent and checks for conflicts before commit?
A. DELETE
B. Optimistic concurrency control
C. Document database
D. Denormalization
Correct Answer: B
Optimistic concurrency control assumes conflicts are infrequent and checks for conflicts before commit.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: is a concurrency-control mechanism that restricts conflicting access to data?
A. Isolation
B. Superkey
C. Lock
D. Third Normal Form
Correct Answer: C
Lock is a concurrency-control mechanism that restricts conflicting access to data.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: occurs when transactions wait on one another's locked resources in a cycle?
A. Deadlock
B. Denormalization
C. UNIQUE constraint
D. View
Correct Answer: A
Deadlock occurs when transactions wait on one another's locked resources in a cycle.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: occurs when repeating a range query returns a different set of rows because another transaction inserted or deleted matching rows?
A. Composite key
B. Phantom read
C. One-to-many relationship
D. ALTER
Correct Answer: B
Phantom read occurs when repeating a range query returns a different set of rows because another transaction inserted or deleted matching rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: occurs when the same row is read twice and returns different committed values due to another transaction's update?
A. Superkey
B. Nonrepeatable read
C. HAVING
D. Full backup
Correct Answer: B
Nonrepeatable read occurs when the same row is read twice and returns different committed values due to another transaction's update.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: occurs when a transaction reads data written by another transaction that has not committed?
A. Dirty read
B. Replication
C. Hierarchical model
D. ER diagram
Correct Answer: A
Dirty read occurs when a transaction reads data written by another transaction that has not committed.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: provides row-by-row processing of a result set or query output?
A. UPDATE
B. Deletion anomaly
C. First Normal Form
D. Cursor
Correct Answer: D
Cursor provides row-by-row processing of a result set or query output.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: executes automatically in response to specified database events?
A. Surrogate key
B. Foreign key
C. Trigger
D. Cursor
Correct Answer: C
Trigger executes automatically in response to specified database events.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: is a named program unit stored in the database and executed on request?
A. Stored procedure
B. Nonclustered index
C. CHECK constraint
D. Optimistic concurrency control
Correct Answer: A
Stored procedure is a named program unit stored in the database and executed on request.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: stores the result of a query physically and refreshes it according to DBMS rules?
A. Materialized view
B. Atomicity
C. Deletion anomaly
D. Relational model
Correct Answer: A
Materialized view stores the result of a query physically and refreshes it according to DBMS rules.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: is a named query that presents a virtual table-like result?
A. Deletion anomaly
B. DEFAULT constraint
C. View
D. IS NULL
Correct Answer: C
View is a named query that presents a virtual table-like result.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: describes operations selected to execute a query?
A. Execution plan
B. RIGHT OUTER JOIN
C. Pessimistic concurrency control
D. DISTINCT
Correct Answer: A
Execution plan describes operations selected to execute a query.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: chooses an execution strategy for a SQL query?
A. GROUP BY
B. Query optimizer
C. Network model
D. Incremental backup
Correct Answer: B
Query optimizer chooses an execution strategy for a SQL query.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: stores index keys separately from table data with references to rows?
A. Nonclustered index
B. Self join
C. DELETE
D. CROSS JOIN
Correct Answer: A
Nonclustered index stores index keys separately from table data with references to rows.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: determines or closely influences physical row order in DBMSs that implement clustered storage?
A. Clustered index
B. Cursor
C. Isolation
D. REVOKE
Correct Answer: A
Clustered index determines or closely influences physical row order in DBMSs that implement clustered storage.