#1
What is the purpose of a primary key in a database table?
To uniquely identify each record in the table
To perform calculations on data
To display data in a specific order
To join multiple tables together
#2
Which of the following data types is used to store date and time values in Microsoft Access?
Text
Number
Date/Time
Currency
#3
In Microsoft Access, what is the purpose of a query?
To create forms for data input
To run reports for data analysis
To retrieve and manipulate data from one or more tables
To design tables and relationships
#4
Which of the following is an example of a relational database management system?
Microsoft Excel
Microsoft Word
Microsoft Access
Microsoft PowerPoint
#5
What is the primary role of a foreign key in a relational database?
To ensure referential integrity between related tables
To perform calculations on data
To display data in a specific order
To join multiple tables together
#6
Which of the following is an advantage of using a database management system (DBMS)?
Increased data redundancy
Decreased data security
Improved data consistency
Limited data accessibility
#7
What does SQL stand for in the context of databases?
Structured Query Language
Standard Query Library
Sequential Query Language
System Query Library
#8
Which operation is used to retrieve data from a database table in SQL?
#9
What is normalization in the context of database management?
A process of organizing data to minimize redundancy and dependency
A process of encrypting data for security purposes
A process of sorting data in alphabetical order
A process of backing up data regularly
#10
What is the purpose of an index in a database table?
To sort data in ascending order
To link multiple tables together
To uniquely identify each record in the table
To optimize the retrieval of data
#11
Which SQL keyword is used to filter results based on specific criteria in a SELECT statement?
FILTER
WHERE
GROUP BY
ORDER BY
#12
In Microsoft Access, what is the purpose of a macro?
To define complex queries
To automate repetitive tasks
To design graphical user interfaces
To write custom code
#13
What does the SQL statement 'SELECT COUNT(*) FROM table_name;' do?
Returns the number of rows in the table
Counts the number of NULL values in the table
Counts the number of distinct values in the table
Counts the number of columns in the table
#14
What does the term 'ACID' stand for in the context of database transactions?
All Committed Information Database
Atomicity, Consistency, Isolation, Durability
Advanced Control of Information Data
Automatic Control for Information Databases
#15
What is the purpose of the CASCADE option in a foreign key constraint?
To prevent deletion of a parent record if child records exist
To automatically update the values of child records if the parent record is modified
To automatically delete child records if the parent record is deleted
To enforce uniqueness of values in the foreign key column
#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
A function that retrieves data from multiple tables
A query that retrieves data from a single table
A macro that automates data entry tasks