Database Management Systems (3130703) MCQs

MCQs of Database System Architecture

Showing 21 to 30 out of 54 Questions
1 2 3 4 5 6
21.

Arrange the following levels of Data abstraction from lowest level to highest level (Logical, View, Physical)

(a)

Physical, Logical, View
(b)

View, Logical, Physical
(c)

View, Physical, Logical
(d)

Physical, View, Logical
Answer:

Option (a)

22.

Which level of abstraction describe How data are actuly stored?

(a)

Physical
(b)

Logical
(c)

External
(d)

View
Answer:

Option (a)

23.

Which level of abstraction describe What data are actuly stored?

(a)

Physical
(b)

Logical
(c)

External
(d)

View
Answer:

Option (b)

24.

How many different types of Database users?

(a)

Two
(b)

Four
(c)

Three
(d)

One
Answer:

Option (b)

25.

Which users is unsophisticated users?

(a)

Naive
(b)

Sophisticated
(c)

Application Programming
(d)

Specialized
Answer:

Option (a)

26.

Which user can intract with system without writing Application Programming?

(a)

Naive User
(b)

Sophisticated User
(c)

Application Programer
(d)

Specialized User
Answer:

Option (b)

27.

Which of the following is/are task of DBA?

(a)

Schema Defination
(b)

Granting of authorization for data access
(c)

Schema of Physical Organization Modification
(d)

All
Answer:

Option (d)

28.

Which of the following is not a Storage Manager Component?

(a)

Transaction Manager
(b)

Logical Manager
(c)

Buffer Manager
(d)

File Manager
Answer:

Option (b)

29.

Which of the following schemas does define a view or views of the database for particular users?

(a)

External schema
(b)

Physical schema
(c)

Conceptual schema
(d)

Internal schema
Answer:

Option (a)

30.

Which of the following terms does refer to the correctness and completeness of the data in a database?

(a)

Data model
(b)

Data independence
(c)

Data integrity
(d)

Data security
Answer:

Option (c)

Showing 21 to 30 out of 54 Questions
1 2 3 4 5 6