CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: tests whether a value matches one of a set of specified values or subquery results?
A. Normalization
B. Hierarchical model
C. IN
D. Entity integrity
Correct Answer: C
IN tests whether a value matches one of a set of specified values or subquery results.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: removes duplicate result rows from a SELECT result?
A. CREATE
B. Normalization
C. DISTINCT
D. CHECK constraint
Correct Answer: C
DISTINCT removes duplicate result rows from a SELECT result.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: forms groups of rows sharing specified values?
A. GROUP BY
B. Nonrepeatable read
C. Update anomaly
D. Durability
Correct Answer: A
GROUP BY forms groups of rows sharing specified values.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: removes all rows from a table more directly than row-by-row DELETE in many DBMSs?
A. IN
B. Trigger
C. TRUNCATE
D. SAVEPOINT
Correct Answer: C
TRUNCATE removes all rows from a table more directly than row-by-row DELETE in many DBMSs.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: intentionally adds redundancy to improve certain read-performance or reporting workloads?
A. Data warehouse
B. LEFT OUTER JOIN
C. Denormalization
D. Data mart
Correct Answer: C
Denormalization intentionally adds redundancy to improve certain read-performance or reporting workloads.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: occurs when deleting one fact unintentionally removes another needed fact?
A. Deletion anomaly
B. ELT
C. View
D. RIGHT OUTER JOIN
Correct Answer: A
Deletion anomaly occurs when deleting one fact unintentionally removes another needed fact.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: occurs when redundant copies of the same fact can become inconsistent after an update?
A. OLAP
B. Update anomaly
C. Full backup
D. Superkey
Correct Answer: B
Update anomaly occurs when redundant copies of the same fact can become inconsistent after an update.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: occurs when a fact cannot be added without also adding unrelated or unavailable data?
A. Metadata
B. FULL OUTER JOIN
C. REVOKE
D. Insertion anomaly
Correct Answer: D
Insertion anomaly occurs when a fact cannot be added without also adding unrelated or unavailable data.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: requires every determinant to be a candidate key?
A. Third Normal Form
B. Composite key
C. BCNF
D. IN
Correct Answer: C
BCNF requires every determinant to be a candidate key.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: requires a column to contain a non-NULL value?
A. NOT NULL constraint
B. CREATE
C. Composite key
D. Third Normal Form
Correct Answer: A
NOT NULL constraint requires a column to contain a non-NULL value.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: supplies a value when an INSERT omits a value for a column?
A. ER diagram
B. DEFAULT constraint
C. ELT
D. ALTER
Correct Answer: B
DEFAULT constraint supplies a value when an INSERT omits a value for a column.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: requires inserted or updated values to satisfy a Boolean condition?
A. ER diagram
B. IS NULL
C. One-to-one relationship
D. CHECK constraint
Correct Answer: D
CHECK constraint requires inserted or updated values to satisfy a Boolean condition.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: prevents duplicate values in a constrained column or column set, subject to DBMS NULL rules?
A. UNIQUE constraint
B. Pessimistic concurrency control
C. Trigger
D. Incremental backup
Correct Answer: A
UNIQUE constraint prevents duplicate values in a constrained column or column set, subject to DBMS NULL rules.
CSS - PMS - CCE - PCS - Basic Computing
Database Basics
Which database term best fits this description: ensures column values conform to defined data types, ranges, or allowed values?
A. Domain integrity
B. Update anomaly
C. RIGHT OUTER JOIN
D. Relational model
Correct Answer: A
Domain integrity ensures column values conform to defined data types, ranges, or allowed values.
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.