Home
Home >> Computer>> Advance DBMS

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

Try Advance DBMS Mock Test

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
View Answer   Discuss

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

DML
DDL
VDL
SDL
View Answer   Discuss

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)
View Answer   Discuss

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

data file.
data record.
menu.
bank.
View Answer   Discuss

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

users.
separate files.
database.
database administrator.
View Answer   Discuss

Question No : 20
A subschema expresses

the logical view.
the physical view.
the external view.
all of the above.
View Answer   Discuss

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

values.
distinct values.
groups.
columns.
View Answer   Discuss

Wanna test your skill? Here are some exams we prepared for you. So if you need to test your skill just attempt any exam from bellow.

Exam Name No. Of Q Link
Computer set 1 30 Start
Computer set 2 30 Start
Computer set 3 30 Start
Computer set 4 30 Start
Computer set 5 30 Start
Computer set 6 30 Start
Computer set 7 30 Start
Computer set 8 30 Start
Computer set 9 30 Start
Computer set 10 30 Start
Computer set 11 30 Start
Computer set 12 30 Start