Database Management Systems (3130703) MCQs

MCQs of Database System Architecture

Showing 41 to 50 out of 54 Questions
41.

Process of transforming requests and results between the three levels is called ______________

(a)

Data abstraction

(b)

Data moving

(c)

Mapping

(d)

Data translating

Answer:

Option (c)

42.

Ability to modify a schema definition in one level without affecting a schema definition in the next higher level is called ________

(a)

Data Binding

(b)

Data Abstraction

(c)

Mapping

(d)

Data Independence

Answer:

Option (d)

43.

___________ is the ability to modify the physical schema without requiring any change in logical (conceptual) schema and application programs

(a)

Logical Data Independence

(b)

Physical Data Independence

(c)

View Data Independence

(d)

External Data Independence

Answer:

Option (b)

44.

Modifications at the internal levels are occasionally necessary to _____________

(a)

Decrease data in database

(b)

Increase data in database

(c)

 Improve performance

(d)

Increase space

Answer:

Option (c)

45.

_____________ is the ability to modify the conceptual schema without requiring any change in application programs.

(a)

Physical Data Independence

(b)

Logical data independence

(c)

View Data Independence

(d)

External Data Independence

Answer:

Option (b)

46.

Modification at the logical levels is necessary whenever __________________________

(a)

we need to reduce data in database

(b)

we need to increase space

(c)

we need to improve performance

(d)

the logical structure of the database is changed.

Answer:

Option (d)

47.

The collection of information stored in the database at particular moment is called instance.

(a)

True

(b)

False

Answer:

Option (a)

48.

Instances are changed frequently.

(a)

True

(b)

False

Answer:

Option (a)

49.

The overall design of database is called database schema.

(a)

True

(b)

False

Answer:

Option (a)

50.

Schemas are changed frequently.

 

(a)

True

(b)

False

Answer:

Option (b)

Showing 41 to 50 out of 54 Questions