#1
What is the purpose of a primary key in a database table?
To uniquely identify each record in the table
ExplanationUniquely identifies records
#2
Which of the following data types is used to store date and time values in Microsoft Access?
Date/Time
ExplanationStores date and time
#3
In Microsoft Access, what is the purpose of a query?
To retrieve and manipulate data from one or more tables
ExplanationRetrieves and manipulates data
#4
Which of the following is an example of a relational database management system?
Microsoft Access
ExplanationRelational DBMS example
#5
What is the primary role of a foreign key in a relational database?
To ensure referential integrity between related tables
ExplanationMaintains referential integrity
#6
Which of the following is an advantage of using a database management system (DBMS)?
Improved data consistency
ExplanationEnhances data consistency
#7
What does SQL stand for in the context of databases?
Structured Query Language
ExplanationQuery language
#8
Which operation is used to retrieve data from a database table in SQL?
SELECT
ExplanationRetrieves data
#9
What is normalization in the context of database management?
A process of organizing data to minimize redundancy and dependency
ExplanationMinimizes redundancy
#10
What is the purpose of an index in a database table?
To optimize the retrieval of data
ExplanationOptimizes data retrieval
#11
Which SQL keyword is used to filter results based on specific criteria in a SELECT statement?
WHERE
ExplanationFilters results
#12
In Microsoft Access, what is the purpose of a macro?
To automate repetitive tasks
ExplanationAutomates tasks
#13
What does the SQL statement 'SELECT COUNT(*) FROM table_name;' do?
Returns the number of rows in the table
#14
What does the term 'ACID' stand for in the context of database transactions?
Atomicity, Consistency, Isolation, Durability
ExplanationTransaction properties
#15
What is the purpose of the CASCADE option in a foreign key constraint?
To automatically delete child records if the parent record is deleted
ExplanationAutomatically deletes child records
#16
What is a stored procedure in the context of database management?
A set of SQL statements that perform a specific task and can be stored and executed on the database server
ExplanationExecutable SQL task set