Check
Created on 27th May 2025
Grade level: Higher Educationth grade
0 plays
20 Questions
No Description
Questions (20)
1. What is the primary purpose of a Database Management System (DBMS)?
To provide a systematic way to manage databases
4 choice options
2. Which of the following is a characteristic of relational databases?
Data is organized into tables with rows and columns
4 choice options
3. Which SQL clause is used to filter records?
WHERE
4 choice options
4. What does ACID stand for in the context of database transactions?
Atomicity, Consistency, Isolation, Durability
4 choice options
5. Which of the following keys uniquely identifies a record in a database table?
Primary Key
4 choice options
6. What kind of relationship exists when a record in Table A can be associated with multiple records in Table B and vice versa?
Many-to-Many
4 choice options
7. In which normal form is a relation if it has no transitive dependencies?
Third Normal Form (3NF)
4 choice options
8. What is the purpose of indexing in a database?
To speed up data retrieval operations
4 choice options
9. Which of the following is NOT a type of database model?
File System Model
4 choice options
10. What is the main benefit of using a NoSQL database?
High scalability and flexibility
4 choice options
11. What is the primary purpose of a Database Management System (DBMS)?
To provide a mechanism for data storage and retrieval
4 choice options
12. Which of the following is NOT a type of DBMS?
Object-Oriented Programming DBMS
4 choice options
13. In a relational database, what is a foreign key?
A key used to enforce referential integrity between two tables
4 choice options
14. What is normalization in the context of database design?
The process of organizing data to reduce redundancy
4 choice options
15. Which SQL statement is used to create a new table in a database?
CREATE TABLE
4 choice options
16. What does ACID stand for in database transactions?
Atomicity, Consistency, Isolation, Durability
4 choice options
17. Which of the following is a characteristic of NoSQL databases?
They are schema-less
4 choice options
18. What is the purpose of an index in a database?
To speed up data retrieval
4 choice options
19. In a star schema, what is the central table called?
Fact table
4 choice options
20. What is the function of the SQL command 'JOIN'?
To combine two or more tables based on a related column
4 choice options