Question 1 of 15 Database Fundamentals
Which property must a primary key column always satisfy?
A Values are always numeric B Values are indexed descending C Values are unique and never null D Values match a column in another table
Question 2 of 15 Database Fundamentals
What is the purpose of a foreign key constraint?
A To speed up SELECT queries automatically B To encrypt the referenced column C To prevent any deletes on a table D To enforce referential integrity between related tables
Question 3 of 15 Database Fundamentals
Which SQL statement retrieves rows from a table?
A INSERT B UPDATE C SELECT D ALTER
Question 4 of 15 Database Fundamentals
Which scenario is the strongest fit for a document-oriented NoSQL database?
A Fixed-schema financial ledger entries requiring strict transactions B Product catalog records whose attributes vary widely between items C A single small lookup table D Nightly batch reporting on a star schema
Question 5 of 15 Database Deployment
Where should database schema changes be validated before they reach production?
A In a staging environment that mirrors production B Directly in production during business hours C Only on the developer laptop D In the backup archive
Question 6 of 15 Database Deployment
Which input matters most when planning storage capacity for a new database server?
A Projected data growth and transaction volume B The color scheme of the reporting tool C The number of developers on staff D The age of the previous server
Question 7 of 15 Database Management and Maintenance
What is the fundamental trade-off of adding an index to a table?
A Faster writes but slower reads B Less storage used overall C No trade-off; indexes are always free D Faster reads on indexed lookups but slower writes and more storage
Question 8 of 15 Database Management and Maintenance
Which routine maintenance activity keeps query plans efficient as data changes over time?
A Renaming tables quarterly B Rebuilding fragmented indexes and updating statistics C Deleting old backups first D Restarting the server nightly
Question 9 of 15 Database Management and Maintenance
In Microsoft SQL Server, which component schedules recurring jobs such as nightly maintenance?
A Query Store B Database Mail C The tempdb database D SQL Server Agent
Question 10 of 15 Database Management and Maintenance
Users report a nightly report has become slow. Which evidence source most directly identifies the offending queries?
A The web server access log B The office badge system log C Query execution statistics and wait information from the database engine D Antivirus scan history
Question 11 of 15 Data and Database Security
A reporting user only needs to read three tables. Granting exactly SELECT on those tables follows which principle?
A Defense in depth B Separation of duties C Least privilege D Implicit trust
Question 12 of 15 Data and Database Security
Which coding practice is the primary defense against SQL injection?
A Parameterized queries instead of string concatenation B Hiding error messages from users C Renaming tables with random prefixes D Limiting queries to business hours
Question 13 of 15 Data and Database Security
Which control protects database files if the underlying storage or backup media is stolen?
A Encryption at rest, such as transparent data encryption B A stronger application password C Row counts in a spreadsheet D Faster storage hardware
Question 14 of 15 Business Continuity
What does the recovery point objective (RPO) define?
A How long restoration may take B The maximum acceptable amount of data loss, measured in time C How many backup copies must exist D The order in which systems restart
Question 15 of 15 Business Continuity
Which backup type captures only the changes made since the most recent backup of any type?
A Full backup B Incremental backup C Differential backup D Snapshot clone
