=====================================================================
DBMS MCQ QUESTIONS
MODEL PAPER –11
======================================================================
1. What is a schema in a DBMS?
a. A specific record in a table
b. A specific field in a record
c. A blueprint or plan that describes the structure of the database
d. A specific occurrence of a database schema at a particular moment in
time
Answer: c. A blueprint or plan that describes the structure of the
database
2. What does a database schema
define?
a. The relationships between tables in the database
b. The data types of attributes in table
c. The overall structure of the database
d. A specific occurrence of a database schema
Answer: c. The overall structure of the database
3. In a relational database, what
is the role of a schema?
a. To store a specific record in a table
b. To define the relationships between tables
c. To create a snapshot of the database at a specific point in time
d. To represent the overall structure of the database
Answer: d. To represent the overall structure of the database
4. What is the purpose of having
multiple schemas in a database?
a. To increase data redundancy
b. To complicate user interactions with the database
c. To store multiple records in a table
d. To organize and manage different aspects of the database separately
Answer: d. To organize and manage different aspects of the database
separately
5. What is an external schema in
a DBMS?
a. A schema that represents the overall structure of the database
b. A schema that defines relationships between tables
c. A schema that is specific to a particular instance of the
database
d. A schema that defines the user's view of the database
Answer: d. A schema that defines the user's view of the database
6. What is the difference between
a schema and a database instance?
a. A schema is a specific record in a table, while an instance is a
specific occurrence of a database schema
b. A schema represents the overall structure of the database, while an
instance represents a specific occurrence of the database schema
c. A schema and an instance are synonymous terms and can be used
interchangeably
d. A schema is a specific occurrence of a database schema, while an
instance is a blueprint for the database structure
Answer: b. A schema represents the overall structure of the database,
while an instance represents a specific occurrence of the database schema
7. What is a physical schema in a
DBMS?
a. A schema that represents the overall structure of the database
b. A schema that defines relationships between tables
c. A schema that is specific to a particular instance of the
database
d. A schema that describes how data is stored, accessed, and organized
physically
Answer: d. A schema that describes how data is stored, accessed, and
organized physically
8. In the context of security,
what does a schema provide in a DBMS?
a. A way to increase data redundancy
b. A method to complicate user interactions with the database
c. A means to control access permissions and security
d. A specific occurrence of a database schema at a particular moment in
time
Answer: c. A means to control access permissions and security
9. What is a conceptual schema in
a DBMS?
a. A schema that represents the overall structure of the database
b. A schema that defines relationships between tables
c. A schema that is specific to a particular instance of the
database
d. A schema that provides a high-level, abstract view of the entire
database
Answer: d. A schema that provides a high-level, abstract view of the
entire database
10. What is the purpose of a
logical schema in a DBMS?
a. To represent the overall structure of the database
b. To define relationships between tables
c. To store a specific record in a table
d. To create a snapshot of the database at a specific point in time
Answer: b. To define relationships between tables
11. In the context of data
independence, what does a logical schema provide?
a. Increased data redundancy
b. Logical data independence
c. Dependency on specific hardware configurations
d. Exposure of physical storage details to users
Answer: b. Logical data independence
12. What is a user schema in a
DBMS?
a. A schema that represents the overall structure of the database
b. A schema that defines relationships between tables
c. A schema that is specific to a particular instance of the
database
d. A schema that defines the view of the database for a particular user
or application
Answer: d. A schema that defines the view of the database for a
particular user or application
13. What is the role of a schema
in data modeling?
a. To increase data redundancy
b. To complicate user interactions with the database
c. To store multiple records in a table
d. To provide a
Certainly! Here are more multiple-choice questions (MCQs) related to
Schema in Database Management Systems (DBMS) along with their answers:
14. What is an example of metadata stored in a schema in a DBMS?
a. A specific record in a table
b. A specific field in a record
c. Information about the data types and constraints of attributes in a
table
d. A specific occurrence of a database schema at a particular moment in
time
Answer: c. Information about the data types and constraints of
attributes in a table
15. In a DBMS, what does the term
"schema evolution" refer to?
a. Creating a snapshot of the database at a specific point in time
b. Modifying the overall structure of the database schema over time
c. Defining relationships between tables
d. Controlling access permissions and security
Answer: b. Modifying the overall structure of the database schema over
time
16. What is the significance of a
schema in the context of database design?
a. It increases data redundancy
b. It simplifies user interactions with the database
c. It defines the relationships between tables and the overall database structured. It exposes physical storage details to users
Answer: c. It defines the relationships between tables and the overall
database structure
17. What is the security benefit of
using schemas in a DBMS?
a. Increased data redundancy
b. Simplified user interactions with the database
c. Control over access permissions and security
d. Dependency on specific hardware configurations
Answer: c. Control over access permissions and security
18. In a DBMS, what does the term
"schema mapping" involve?
a. Defining relationships between tables
b. Mapping attributes from one schema to another in a heterogeneous
database environment
c. Modifying the overall structure of the database schema over time
d. Creating a snapshot of the database at a specific point in time
Answer: b. Mapping attributes from one schema to another in a
heterogeneous database environment
19. What is the role of a global
schema in a distributed database environment?
a. To represent the overall structure of the database
b. To store multiple records in a table
c. To define relationships between tables
d. To provide a common view of the entire distributed database
Answer: d. To provide a common view of the entire distributed database
20. What is an example of an
external schema in a DBMS?
a. A schema that represents the overall structure of the database
b. A schema that defines relationships between tables
c. A schema that is specific to a particular user or application
d. A schema that describes how data is stored physically
Answer: c. A schema that is specific to a particular user or application
21. In a DBMS, what does the term
"schema integrity" refer to?
a. Creating a snapshot of the database at a specific point in time
b. Ensuring the consistency and correctness of the overall structure of
the database schema
c. Defining relationships between tables
d. Controlling access permissions and security
Answer: b. Ensuring the consistency and correctness of the overall
structure of the database schema
22. What is the primary purpose
of a data dictionary in the context of schemas?
a. To represent the overall structure of the database
b. To store multiple records in a table
c. To provide metadata and information about the database objects and
their attributes
d. To define relationships between tables
Answer: c. To provide metadata and information about the database
objects and their attributes
23. What is the significance of a
schema in terms of data abstraction?
a. Increased data redundancy
b. Dependency on specific hardware configurations
c. Simplified user interactions with the database
d. Exposure of physical storage details to users
Answer: c. Simplified user interactions with the database
24. In a DBMS, what does the term
"schema migration" involve?
a. Modifying the overall structure of the database schema over time
b. Creating a snapshot of the database at a specific point in time
c. Mapping attributes from one schema to another in a heterogeneous
database environment
d. Controlling access permissions and security
Answer: a. Modifying the overall structure of the database schema over
time
25. What is the role of a schema
in the context of database administration?
a. To create a snapshot of the database at a specific point in time
b. To define relationships between tables
c. To control access permissions and security
d. To provide metadata about the database objects and their attributes
Answer: c. To control access permissions and security
26. In a DBMS, what does the term
"schema decomposition" involve?
a. Modifying the overall structure of the database schema over time
b. Creating a snapshot of the database at a specific point in time
c. Breaking down a global schema into smaller, more manageable
schemas
d. Mapping attributes from one schema to another in a heterogeneous
database environment
Answer: c. Breaking down a global schema into smaller, more manageable
schemas
27. What is the primary purpose
of an external schema in a DBMS?
a. To represent the overall structure of the database
b. To store multiple records in a table
c. To define relationships between tables
d. To provide a view of the database tailored to a specific user or
application
Answer: d. To provide a view
28. What does the term
"schema independence" mean in a DBMS?
a. Independence from user interactions with the database
b. Independence from specific hardware configurations
c. Independence from the overall structure of the database schema
d. Independence from changes in the internal schema while maintaining
the external schema
Answer: d. Independence from changes in the internal schema while
maintaining the external schema
29. In the context of database
design, what is the purpose of a sub-schema in a DBMS?
a. To represent the overall structure of the database
b. To store multiple records in a table
c. To define relationships between tables
d. To provide a view of the database tailored to a specific user or
application
Answer: d. To provide a view of the database tailored to a specific user
or application
30. What is the role of a schema
in the context of database maintenance?
a. To create a snapshot of the database at a specific point in time
b. To define relationships between tables
c. To control access permissions and security
d. To facilitate modifications and updates to the overall structure of
the database schema
Answer: d. To facilitate modifications and updates to the overall
structure of the database schema
31. In a DBMS, what is the
purpose of a schema object?
a. To represent the overall structure of the database
b. To store multiple records in a table
c. To define relationships between tables
d. To represent a specific database object, such as a table or view,
within a schema
Answer: d. To represent a specific database object, such as a table or
view, within a schema
32. What is the significance of a
schema in terms of database security?
a. Increased data redundancy
b. Dependency on specific hardware configurations
c. Control over access permissions and security
d. Exposure of physical storage details to users
Answer: c. Control over access permissions and security
33. In the context of a
distributed database, what role does a schema play in data distribution?
a. To represent the overall structure of the database
b. To store multiple records in a table
c. To define relationships between tables
d. To provide a common structure for data distribution across multiple
sites
Answer: d. To provide a common structure for data distribution across
multiple sites
34. What is the role of a schema
in the context of data modeling and abstraction?
a. Increased data redundancy
b. Dependency on specific hardware configurations
c. Simplified user interactions with the database
d. Exposure of physical storage details to users
Answer: c. Simplified user interactions with the database
35. In a DBMS, what is the
purpose of a schema hierarchy?
a. To represent the overall structure of the database
b. To store multiple records in a table
c. To define relationships between tables
d. To organize schemas in a hierarchical fashion based on dependencies
and relationships
Answer: d. To organize schemas in a hierarchical fashion based on
dependencies and relationships
36. What is the primary goal of
having a schema in a DBMS?
a. To create a snapshot of the database at a specific point in time
b. To define relationships between tables
c. To control access permissions and security
d. To provide a structured and organized blueprint for the database
structure
Answer: d. To provide a structured and organized blueprint for the
database structure
37. In the context of a data
warehouse, what is the role of a schema?
a. To represent the overall structure of the database
b. To store multiple records in a table
c. To define relationships between tables
d. To provide a logical structure for organizing and accessing data in
the data warehouse
Answer: d. To provide a logical structure for organizing and accessing
data in the data warehouse
38. What is an example of a
system catalog in a schema in a DBMS?
a. A specific record in a table
b. A specific field in a record
c. Information about the data types and constraints of attributes in a
table
d. A specific occurrence of a database schema at a particular moment in
time
Answer: c. Information about the data types and constraints of
attributes in a table
39. In the context of database
administration, what is the role of a schema mapping tool?
a. Modifying the overall structure of the database schema over time
b. Creating a snapshot of the database at a specific point in time
c. Mapping attributes from one schema to another in a heterogeneous
database environment
d. Controlling access permissions and security
Answer: c. Mapping attributes from one schema to another in a
heterogeneous database environment
40. What is an example of an
internal schema in a DBMS?
a. A schema that represents the overall structure of the database
b. A schema that defines relationships between tables
c. A schema that is specific to a particular instance of the
database
d. A schema that describes how data is stored physically
Answer: d. A schema that describes how data is stored physically
0 Comments