DBMS Quiz

According to the ANSI three-level model, what are the three levels of a database?

• Internal, External, Conceptual

• Visible, Hidden, Accessible

• Primary, Secondary, Tertiary

• Physical, Logical, External

Who has access to the DBMS at the conceptual level in the ANSI architecture?

• Programmers

• Database Administrator (DBA)

• Users

• Developers

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

• To provide individual user and programmer views

• To describe the organization of data as perceived by a user or programmer

• To provide a universal view of the database

• To control the physical storage of data

What is an important aspect of the provision of views in a DBMS?

• To create a report to present formatted output

• To ensure security and control access rights

• To provide a universal view of the database

• To control the physical storage of data

What is the purpose of a query processor in a DBMS?

• To create and process queries for extracting and manipulating data

• To develop a user interface

• To provide software tools through a developer interface

• To control access rights and security

What is the responsibility of the DBA in a DBMS?

• To develop a user interface

• To define the appropriate access rights and set up user and programmer views

• To provide software tools through a developer interface

• To create and process queries for extracting and manipulating data

What is the purpose of creating an index for a table in a DBMS?

• To ensure the integrity of the data

• To improve performance of the database

• To contain metadata about the data and details of the definitions of tables and attributes

• To provide a universal view of the database

What is the purpose of the facilities provided by a DBMS through a developer interface?

• To control access rights and security

• To allow for tables to be created and attributes to be defined together with their data types

• To develop a user interface

• To process queries for extracting and manipulating data

What is the purpose of the query processor in a DBMS?

• To control access rights and security

• To provide software tools through a developer interface

• To develop a user interface

• To create and process queries for extracting and manipulating data