Which of the following is the primary purpose of a Database Management System (DBMS)?
a) To manage hardware resources
b) To store, manage, and retrieve data efficiently
c) To generate reports for businesses
d) To design and develop software applications
What does DBMS stand for?
a) Database Management System
b) Data Bank Management System
c) Database Model System
d) Data Backup Management System
Which of the following is an example of a relational DBMS?
a) MongoDB
b) MySQL
c) Cassandra
d) Firebase
What is the main function of a DBMS?
a) To store files on disk
b) To manage and control data access
c) To make backups of data
d) To automate data analysis
Which of the following is not a type of DBMS?
a) Hierarchical
b) Relational
c) Document-based
d) Linear
Which language is primarily used to interact with a relational DBMS?
a) HTML
b) SQL
c) Python
d) C++
Which of the following is an example of a NoSQL DBMS?
a) SQL Server
b) MongoDB
c) Oracle
d) PostgreSQL
What is the purpose of the primary key in a relational database?
a) To enforce uniqueness of a record
b) To link two tables together
c) To store data in a structured format
d) To store large text data
Which of the following is not a feature of DBMS?
a) Data redundancy
b) Data integrity
c) Data security
d) Data consistency
What type of relationship is defined between two tables in a relational database?
a) Unidirectional
b) One-to-one
c) Many-to-many
d) Hierarchical
Which of the following is a characteristic of a DBMS?
a) Data is stored in flat files
b) It reduces the need for data redundancy
c) It supports only text data
d) It does not support concurrent access
What is the function of normalization in a DBMS?
a) To decrease data redundancy
b) To add more columns to the table
c) To improve system performance
d) To merge tables
Which of the following is the first stage of database design?
a) Normalization
b) Database modeling
c) Database implementation
d) Data entry
Which of the following is a feature of the hierarchical data model in DBMS?
a) Data is stored in a table format
b) Data is organized in a tree-like structure
c) Data is stored in key-value pairs
d) Data can be stored in multiple formats
What is the purpose of a foreign key in a relational database?
a) To define relationships between tables
b) To ensure the integrity of primary keys
c) To store large data values
d) To calculate aggregate values
Which of the following is an example of a non-relational database?
a) SQLite
b) MySQL
c) MongoDB
d) PostgreSQL
What is the role of a Data Definition Language (DDL) in DBMS?
a) To define, modify, and delete database structures
b) To store and retrieve data from the database
c) To enforce security policies
d) To handle user permissions
What is the purpose of a transaction in DBMS?
a) To store data in a structured format
b) To ensure data consistency and integrity
c) To create backups of data
d) To run queries on the database
Which of the following is the ACID property that ensures the correctness of a transaction?
a) Atomicity
b) Consistency
c) Isolation
d) Durability
Which type of DBMS supports both relational and non-relational data models?
a) Hybrid DBMS
b) Relational DBMS
c) NoSQL DBMS
d) Graph DBMS
Which of the following is the main advantage of using a DBMS?
a) Reduced hardware requirements
b) Improved data sharing and security
c) Increased data redundancy
d) Faster data access without backups
Which of the following is the main disadvantage of using a DBMS?
a) Data redundancy
b) Centralized control and management of data
c) Reduced performance due to centralized systems
d) Lack of data security
Which of the following is a common DBMS software?
a) Microsoft Excel
b) Oracle
c) Visual Studio
d) Adobe Photoshop
Which of the following is a key benefit of using a DBMS?
a) Increased complexity of the system
b) Better management of large datasets
c) Lack of data integrity
d) Reduced data access speed
What is the primary purpose of an Entity-Relationship (ER) diagram?
a) To define user roles and permissions
b) To show relationships between data entities
c) To store data in hierarchical format
d) To optimize database queries
Which of the following is an advantage of using a NoSQL database over a relational DBMS?
a) Easier to scale horizontally
b) Requires less data consistency
c) Supports SQL queries
d) Provides full ACID compliance
Which of the following is true about DBMS backups?
a) Backups are only needed during system failures
b) A DBMS automatically performs backups without user intervention
c) Backups help ensure data recovery in case of data loss
d) Backup data is always stored in the same format as live data
Which of the following is used to improve database performance by reducing data retrieval times?
a) Indexing
b) Normalization
c) Encryption
d) Query optimization
Which of the following is a benefit of normalization in a relational database?
a) Reduced data redundancy
b) Increased complexity of data queries
c) Better performance of queries
d) Decreased storage requirements
What does the “durability” property in the ACID transaction model refer to?
a) Ensuring that a transaction is completed successfully
b) Ensuring that data changes are permanent, even in case of a system failure
c) Ensuring that all database changes are isolated
d) Ensuring that all database operations are consistent
