DBMS CSEDS

What is a Database Management System (DBMS)?

• A software application that manages databases

• A computer hardware component used for data storage

• A programming language for creating databases

• A network protocol for database communication

Which of the following is not a function of a DBMS?

• Data storage

• Data retrieval

• Data manipulation

• Data transmission

What is the primary purpose of a DBMS?

• To store and manage data efficiently

• To analyze and visualize data

• To create data backups

• To secure data from unauthorized access

Which type of data can be stored in the database?

• All of the above
• image oriented data
• Text, files containing data
• Data in the form of audio or video

Which of the following is not a type of database?

• Decentralised
• Hierarchical
• Network
• Relational

Keys to represent relationship between tables is called

• Foreign Key
• Primary key
• Seconadary Key
• Partial Key

A database-management system (DBMS) consists of

• A collection of interrelated data and a collection of programs to access those data.

• A collection of unrelated data and a collection of programs to access those data.

• A collection of interrelated data and a collection of programs to delete those data.

• A collection of unrelated data and a collection of programs to delete those data.

What is the primary role of the transaction manager in a database-management system (DBMS)?

• To ensure that concurrent transaction executions proceed without conflicts.

• To manage the physical storage of data.

• To handle user authentication and authorization.

• To optimize query performance.

What are the different types of schema's in DBMS?(three options)

• Physical Schema

• Sub Schema

• Logical

• Data Schema

What is the primary function of a Query Processor in a Database Management System (DBMS)

• To manage the physical storage of data

• To execute and interpret database commands

• To interpret and execute database queries

• To handle user authentication and authorization