Database Systems Model Exam

1. What is a database in the context of computer systems?

a. A collection of files stored on a computer
b. A software application used for data processing
c. A structured collection of data stored electronically
d. A set of interconnected computers used for data storage
2. What is a DBMS?
a. Database Management System
b. Data Backup and Management Software
c. Database Modeling System
d. Data Business Management Software
3. Which of the following is NOT a common type of database model?
a. Relational database model
b. Hierarchical database model
c. Network database model
d. Logical database model
4. In a relational database, what is a table?
a. A representation of a relationship between entities
b. A collection of related attributes
c. A storage structure for data records
d. A graphical representation of database schema
5. What is a primary key in a relational database?
a. A unique identifier for each record in a table
b. A foreign key in a related table
c. A data type used to store numerical values
d. A field used for sorting and indexing data
6. What is the purpose of a foreign key in a relational database?
a. To establish a relationship between tables
b. To store encrypted data
c. To define the structure of a table
d. To perform complex calculations on data
7. Which of the following is an example of a SQL database?
a. MySQL
b. MongoDB
c. Apache Cassandra
d. Redis
8. What is the purpose of normalization in database design?
a. To eliminate duplicate data and reduce data redundancy
b. To optimize query performance
c. To define data types and constraints
d. To secure the database from unauthorized access
9. Which of the following is a key feature of NoSQL databases?
a. Strict schema enforcement
b. Support for complex transactions
c. Horizontal scalability
d. ACID compliance
10. What is the purpose of an index in a database?
a. To ensure data integrity and consistency
b. To encrypt sensitive data
c. To speed up data retrieval and query performance
d. To define relationships between tables
11. What is the role of a transaction in database management?
a. To perform complex data analysis
b. To enforce data integrity constraints
c. To maintain database security
d. To ensure atomicity and consistency of database operations
12. Which of the following is a disadvantage of distributed databases?
a. Improved data availability and fault tolerance
b. Increased complexity of data management
c. Reduced data security and privacy
d. Limited scalability and performance
13. What is the purpose of data normalization in database design?
a. To improve query performance
b. To optimize database storage space
c. To eliminate data redundancy and anomalies
d. To enforce data integrity constraints
14. Which of the following is NOT a SQL data manipulation command?
a. SELECT
b. INSERT
c. UPDATE
d. DEFINE
15. What is the purpose of a database transaction log?
a. To store backup copies of the database
b. To record changes made to the database for recovery purposes
c. To track user access and activities in the database
d. To maintain a history of database schema changes
16. Which of the following is an example of a NoSQL database?
a. Oracle Database
b. Microsoft SQL Server
c. Redis
d. PostgreSQL
17. What is the purpose of data integrity constraints in a database?
a. To ensure that data is stored securely
b. To enforce rules and validations on data to maintain consistency and accuracy
c. To speed up data retrieval and query performance
d. To define relationships between tables
18. Which of the following is a characteristic of a distributed database?
a. It is stored on a single computer.
b. It is managed by a centralized DBMS.
c. It is limited to a single location.
d. It is divided and stored on multiple computers or servers.
19. What is the purpose of a view in a database?
a. To define the structure and organization of the data
b. To provide a simplified and virtual representation of data from one or more tables
c. To store complex queries for future use
d. To enforce referential integrity constraints
20. Which of the following is a key characteristic of ACID properties in database transactions?
a. Atomicity, Consistency, Isolation, Durability
b. Accuracy, Completeness, Inheritance, Dependency
c. Association, Concurrency, Integrity, Distribution
d. Access, Control, Information, Data
21. What is the purpose of a database schema?
a. To define the physical layout and storage structure of the database
b. To store and manage data records in the database
c. To define the relationships and dependencies between database objects
d. To provide a graphical representation of the database structure
22. Which of the following is an example of a database index type?
a. Clustered index
b. Hash index
c. B-tree index
d. All of the above
23. What is a data warehouse?
a. A database that stores current and up-to-date data
b. A database optimized for transactional processing
c. A centralized repository of integrated and historical data
d. A database used for temporary storage and quick retrieval
24. What is the purpose of data replication in a distributed database system?
a. To improve data availability and fault tolerance
b. To enforce data integrity constraints
c. To optimize query performance
d. To reduce data redundancy
25. What is the role of the database administrator (DBA)?
a. To design and develop database systems
b. To manage and maintain the security and performance of the database
c. To write complex SQL queries and reports
d. To administer user access and permissions
26. What is the purpose of a database trigger?
a. To perform calculations and data transformations on the database
b. To enforce referential integrity constraints
c. To automate actions or procedures in response to specific database events
d. To secure the database from unauthorized access
27. Which of the following is an example of a database management system other than SQL-
based systems?
a. MongoDB
b. PostgreSQL
c. Oracle Database
d. MySQL
28. What is the purpose of data mining in database systems?
a. To extract meaningful patterns and knowledge from large datasets
b. To optimize database storage and indexing
c. To facilitate data backup and recovery processes
d. To enforce data integrity constraints
29. Which of the following is an example of a database query language?
a. SQL (Structured Query Language)
b. HTML (Hypertext Markup Language)
c. CSS (Cascading Style Sheets)
d. JavaScript
30. What is the purpose of a database transaction?
a. To ensure data consistency and integrity
b. To optimize query performance
c. To define the structure and organization of the data
d. To manage user access and permissions