MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

DATABASE MANAGEMENT SYSTEM

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following is not a Storage Manager Component?

A	Transaction Manager
B	Logical Manager
C	Buffer Manager
D	File Manager

Explanation:

Detailed explanation-1: -Following are the components of the storage manager; Authorization and Integrity Manager: It tests the integrity constraints and checks the authorization of users to access data. Transaction Manager: It ensures that no kind of change will be brought to the database until a transaction has been completed totally.

Detailed explanation-2: -Answer: 1 query processor is not the dbms.

Detailed explanation-3: -Expert Answer Option D) Catalog is not component of database system .

Detailed explanation-4: -DBMS. Storage Manager: A storage manager is a program module which is responsible for storing, retrieving and updating data in the database. Following are the components of the storage manager; Authorization and Integrity Manager: It tests the integrity constraints and checks the authorization of users to access data.

There is 1 question to complete.