Database Management Systems (3130703) MCQs

MCQs of Database System Architecture

Showing 31 to 40 out of 54 Questions
1 2 3 4 5 6
31.

Which of the following is/are disadvantages of Database Management System?

(A) Cost of Hardware and Software 

(B) Reduce data redundancy

(C) Remove data inconsistency 

(a)

A
(b)

B
(c)

C
(d)

B and C
Answer:

Option (a)

32.

Either all of its operations are executed or none is called _________

(a)

Consistency
(b)

Isolation
(c)

Atomicity
(d)

Durablity
Answer:

Option (c)

33.

When data is processed, organized, structured or presented in a given context so as to make it useful, it is called ____________

(a)

Superdata
(b)

Cleandata
(c)

Information
(d)

Database
Answer:

Option (c)

34.

_____________ is an information repository which contains metadata.

(a)

Data warehouse
(b)

Data dictionary
(c)

Database
(d)

System
Answer:

Option (b)

35.

____________is an information repository which stores data.

(a)

Data warehouse 
(b)

Data dictionary
(c)

Hard disk
(d)

Server
Answer:

Option (a)

36.

Lowest level of 3 level ANSI SPARC architecture is ________

(a)

Internal Level
(b)

Conceptual Level
(c)

View Level
(d)

External Level
Answer:

Option (a)

37.

___________ level deals with physical storage of data.

(a)

Internal
(b)

External
(c)

View
(d)

Conceptual
Answer:

Option (a)

38.

Conceptual level is also know as ____________

(a)

Physical Level
(b)

View level
(c)

Intenal level
(d)

Logical level
Answer:

Option (d)

39.

External level is also known as ___________

(a)

Physical level
(b)

Internal level
(c)

View level
(d)

Conceptual level
Answer:

Option (c)

40.

The process of hiding irrelevant details from user is called ____________

(a)

Data abstraction
(b)

Mapping
(c)

Data clapping
(d)

Data binding
Answer:

Option (a)

Showing 31 to 40 out of 54 Questions
1 2 3 4 5 6