B.Tech CSE_2024-25_II Year - 4th Sem_ Section_DBMS Unit 1

What does DBMS stand for?

• Database Management System

• Data Backup Management System

• Data Build Management System

• Database Modular System

What is the primary goal of a DBMS?

• Store data without processing

• Provide a way to store and retrieve data efficiently

• Generate automatic reports

• Manage hardware resources

Which of the following is an example of a DBMS?

• DBMS

• MS Paint

• MS Excel

• Oracle

In a DBMS, the structure of the database is defined using which language?

• Data Query Language (DQL)

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Data Control Language (DCL)

What is a primary key in a database?

• A key used to encrypt data

• A unique identifier for each record

• A duplicate value in the table

• A foreign key in a database

Which of the following is a disadvantage of a DBMS?

• Data redundancy

• Complexity

• Consistency

• Concurrent access

What is the role of a database schema?

• Defines the structure and organization of the database

• Stores actual data in the database

• Encrypts the database

• Controls user access to the database

Which component of DBMS handles authorization and authentication?

• Query Processor

• Storage Manager

• Transaction Manager

• Security Manager

Which Component is responsible for Query Compilation

• Operating System

• Query Compiler

• Pre Processor Stage of Compilation

• DBA

In a two-tier architecture, how many layers are present?

• 2

• 1

• 3

• 4