Database Administration Flashcards
7 cards from real CPA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Database Administration flashcards as text
What is a database view?
Answer: A virtual table defined by a stored SELECT query
A view is a named, stored SQL query that behaves like a virtual table; it does not store data itself unless it is a materialized view.
Which normal form eliminates transitive dependencies?
Answer: Third Normal Form (3NF)
3NF requires that every non-key attribute depend only on the primary key, eliminating transitive dependencies between non-key columns.
What does an INNER JOIN return?
Answer: Only rows where there is a match in both tables
INNER JOIN returns only the rows where the join condition is satisfied in both tables, excluding non-matching rows from either side.
Which constraint ensures that a column value in one table exists as a primary key in another table?
Answer: FOREIGN KEY constraint
A FOREIGN KEY constraint enforces referential integrity by requiring that the column value matches a primary key in the referenced table.
What is the purpose of the ROLLBACK statement in SQL?
Answer: Undo all changes made since the last COMMIT or SAVEPOINT
ROLLBACK undoes all data modifications made within the current transaction, restoring the database to its state before the transaction began.
Which aggregate function returns the number of non-NULL values in a column?
Answer: COUNT()
COUNT(column_name) returns the number of non-NULL values in the specified column, while COUNT(*) counts all rows including those with NULLs.
What is a stored procedure in a relational database?
Answer: A precompiled set of SQL statements stored in the database
A stored procedure is a named, precompiled collection of SQL statements saved in the database that can be executed by calling its name.