DBMS Quiz

What does DBMS stand for?

• Data Base Managed System

• Database Management System

• Data Business Management System

• Data Backup Management System

Which of the following is NOT a type of data model in DBMS?

• Hierarchical Model

• Network Model

• Linear Model

• Relational Model

Which database language is used to define the structure of a database?

• DDL (Data Definition Language)

• DML (Data Manipulation Language)

• DCL (Data Control Language)

• TCL (Transaction Control Language)

Who is responsible for managing the overall operation of a DBMS?

• Database Designer

• Database Administrator (DBA)

• End User

• Database Developer

Which of the following best describes a data model?

• A programming language used to write queries

• A graphical representation of data relationships

• A way to manage data transactions

• A model used to store system configurations

What is the role of DML (Data Manipulation Language) in a database?

• To define database structures

• To perform queries, insert, update, and delete data

• To control access to the database

• To manage transactions

Which of the following is a type of database user who interacts with the system indirectly through application programs?

• DBA (Database Administrator)

• End User

• Naive User

• Application Programmer

The view level of the three-schema architecture in DBMS is responsible for:

• Storing raw data

• Providing a conceptual view of the data

• Hiding the complexity of the physical level from the user

• Managing the structure and access methods

Which of the following is an example of a network data model?

• Organizational chart

• Supplier-product relationship

• Social media graph

• Relational database schema

What is a key responsibility of a Database Administrator (DBA)?

• Writing application software for the database

• Maintaining the integrity and security of the database

• Using the database to generate reports

• Designing the entity-relationship model