Home

Advance DBMS MCQ Question with Answer

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

Download Advance DBMS MCQ Question Answer PDF

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.