1.
What is the purpose of a database system?
a) To store and organize data
b) To perform calculations
c) To create user interfaces
d) To analyze data
Answer: a) To store and organize data
2.
Which of the following is a component of a
Database Management System (DBMS)?
a) Data modeling
b) Data encryption
c) Data analysis
d) Data visualization
Answer: a) Data modeling
3.
Which of the following is an application of a
DBMS?
a) Web development
b) Word processing
c) Spreadsheet calculations
d) Customer relationship management
Answer: d) Customer relationship management
4.
What does the three-tier architecture in a DBMS
refer to?
a) Physical, logical, and conceptual layers
b) User interface, application logic, and database
c) Data modeling, data storage, and data retrieval
d) Relational, hierarchical, and network databases
Answer: b) User interface, application logic, and database
5.
What is data independence in the context of
databases?
a) The ability to modify data without affecting the database
schema
b) The ability to access data remotely over a network
c) The ability to secure data from unauthorized access
d) The ability to recover data after a system failure
Answer: a) The ability to modify data without affecting the
database schema
6.
What is a database schema?
a) A diagram that represents the structure of a database
b) A set of rules that govern data manipulation in a
database
c) A collection of tables in a database
d) A script that creates a database
Answer: a) A diagram that represents the structure of a
database
7.
What is an instance in the context of databases?
a) A single occurrence of a database schema
b) A backup copy of a database
c) A transaction that modifies data in a database
d) A user account with access to a database
Answer: a) A single occurrence of a database schema
8.
What is data modeling in the context of
databases?
a) The process of creating a database schema
b) The process of generating random data for testing
c) The process of optimizing database performance
d) The process of representing real-world objects and their
relationships in a database
Answer: d) The process of representing real-world objects
and their relationships in a database
9.
What is the Entity-Relationship (ER) model used
for?
a) Representing data in a tabular format
b) Defining the structure of a database schema
c) Describing the relationship between entities in a
database
d) Performing complex calculations on database tables
Answer: c) Describing the relationship between entities in a
database
10.
What is the Relational Model?
a) A model for representing data in a hierarchical structure
b) A model for representing data as a network of
interconnected nodes
c) A model for representing data as a collection of tables
with relationships
d) A model for representing data as a set of objects and
their properties
Answer: c) A model for representing data as a collection of
tables with relationships
11.
Which of the following is not a component of a
Database Management System (DBMS)?
a) Query Language
b) Data Dictionary
c) Data Storage
d) Data Processor
Answer: d) Data Processor
12.
What is the purpose of a Data Dictionary in a
DBMS?
a) It stores the actual data values in the database.
b) It provides information about the structure and
organization of the database.
c) It executes queries and retrieves data from the database.
d) It manages user access and permissions for the database.
Answer: b) It provides information about the structure and
organization of the database.
13.
Which of the following is an example of a
non-relational database model?
a) Hierarchical model
b) Relational model
c) Entity-Relationship model
d) Object-oriented model
Answer: a) Hierarchical model
14.
What is the primary key in a database table?
a) A unique identifier for a table
b) A field that stores numeric data
c) A field that stores character data
d) A field that stores date and time values
Answer: a) A unique identifier for a table
15.
What is the purpose of referential integrity in
a database?
a) To ensure that data is stored in a consistent and valid
state
b) To provide secure access control to the database
c) To improve the performance of data retrieval operations
d) To enforce data encryption and decryption in the database
Answer: a) To ensure that data is stored in a consistent and
valid state
16.
Which of the following is an example of a
database management system?
a) MySQL
b) Microsoft Excel
c) Adobe Photoshop
d) Windows Operating System
Answer: a) MySQL
17.
What is a primary difference between a database
schema and a database instance?
a) The schema defines the structure, while the instance
contains actual data.
b) The instance defines the structure, while the schema
contains actual data.
c) The schema is used for backup purposes, while the
instance is used for data modeling.
d) The instance is specific to a particular user, while the
schema is shared among multiple users.
Answer: a) The schema defines the structure, while the
instance contains actual data.
18.
What does ACID stand for in the context of
database transactions?
a) Atomicity, Consistency, Isolation, Durability
b) Association, Categorization, Integration, Documentation
c) Authentication, Confidentiality, Integrity, Disclosure
d) Aggregation, Calculation, Indexing, Deletion
Answer: a) Atomicity, Consistency, Isolation, Durability
19.
What is a foreign key in a database table?
a) A key used for encrypting sensitive data
b) A key used to establish relationships between tables
c) A key that uniquely identifies a record in a table
d) A key that determines the sorting order of records in a
table
Answer: b) A key used to establish relationships between
tables
20.
What is data normalization in the context of
databases?
a) The process of converting data into a different format
b) The process of removing redundant data and organizing it
efficiently
c) The process of backing up data to prevent loss or
corruption
d) The process of encrypting data to ensure security and
privacy
Answer: b) The process of removing redundant data and
organizing it efficiently