DBMS UNIT 2

What is the main goal of normalization in a database?

• • A) To increase redundancy

• • B) To minimize data integrity

• • C) To reduce data redundancy and improve data integrity

• • D) To increase the complexity of the database structure

Which normal form is a relation in if it contains no partial dependencies?

• • A) First Normal Form (1NF)

• • B) Second Normal Form (2NF)

• • C) Third Normal Form (3NF)

• • D) Boyce-Codd Normal Form (BCNF)

What is the primary purpose of the external schema in the three-schema architecture?

• a) To describe the physical storage of data

• b) To provide a user-specific view of the data

• c) To manage data security and integrity

• d) To define the overall logical structure of the database

The conceptual schema in a DBMS is primarily concerned with which of the following?

• a) Physical data storage and retrieval

• b) User-specific views of data

• c) The overall logical structure of the database, including entities and relationships

• d) Network communication between database servers

Which schema in the three-schema architecture abstracts the complexity of the physical data storage from the users?

• a) External Schema

• b) Conceptual Schema

• c) Internal Schema

• d) All of the above

Which schema in the three-schema architecture abstracts the complexity of the physical data storage from the users?

• a) External Schema

• b) Conceptual Schema

• c) Internal Schema

• d) All of the above

In the three-schema architecture, which schema can have multiple views for different users?

• a) External Schema

• b) Conceptual Schema

• c) Internal Schema

• d) Logical Schema

The external schema is also known as which of the following?

• a) Physical View

• b) Logical View

• c) User View

• d) Structural View

Which schema level is responsible for data independence in a database?

• a) External Schema

• b) Conceptual Schema

• c) Internal Schema

• d) All levels contribute equally

In the three-schema architecture, changes to the internal schema are intended to be transparent to which other schema(s)?

• a) Only the external schema

• b) Only the conceptual schema

• c) Both external and conceptual schemas

• d) Changes are not intended to be transparent