Basic Computing
Database Basics
Which database term best fits this description: joins a table to another reference of itself?
A. Index
B. REVOKE
C. Self join
D. Deadlock
Correct Answer: C
Self join joins a table to another reference of itself.
Basic Computing
Database Basics
Which database term best fits this description: returns matched rows and unmatched rows from both sides?
A. Transaction log
B. Full backup
C. First Normal Form
D. FULL OUTER JOIN
Correct Answer: D
FULL OUTER JOIN returns matched rows and unmatched rows from both sides.
Basic Computing
Database Basics
Which database term best fits this description: returns all right-side rows plus matching left-side rows?
A. RIGHT OUTER JOIN
B. DEFAULT constraint
C. CREATE
D. Deadlock
Correct Answer: A
RIGHT OUTER JOIN returns all right-side rows plus matching left-side rows.
Basic Computing
Database Basics
Which database term best fits this description: returns all left-side rows plus matching right-side rows?
A. Read replica
B. NOT NULL constraint
C. LEFT OUTER JOIN
D. Stored procedure
Correct Answer: C
LEFT OUTER JOIN returns all left-side rows plus matching right-side rows.
Basic Computing
Database Basics
Which database term best fits this description: returns rows that satisfy the join condition on both sides?
A. Foreign key
B. GRANT
C. INNER JOIN
D. Self join
Correct Answer: C
INNER JOIN returns rows that satisfy the join condition on both sides.
Basic Computing
Database Basics
Which database term best fits this description: tests specifically for SQL NULL values?
A. BETWEEN
B. IS NULL
C. REVOKE
D. Cursor
Correct Answer: B
IS NULL tests specifically for SQL NULL values.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.