Advance DBMS MCQ Question with Answer

Advance DBMS MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Question No : 15
Volatile storage

loses its contents when power is switched off.

doesnt loses its contents when power is switched off.

creates backup when power is switched off.

none

Question No : 16
The language used in application programs to request data from the DBMS is referred to as the

DML

DDL

VDL

SDL

Question No : 17
A logical schema

is the entire database.

is a standard way of organizing information into accessible parts.

describes how data is actually stored on disk.

both A) and C)

Question No : 18
Related fields in a database are grouped to form a

data file.

data record.

menu.

bank.

Question No : 19
The database environment has all of the following components except:

users.

separate files.

database.

database administrator.

Question No : 20
A subschema expresses

the logical view.

the physical view.

the external view.

all of the above.

Question No : 21
Count function in SQL returns the number of

values.

distinct values.

groups.

columns.