Database Management Systems (3130703) MCQs

MCQs of Database System Architecture

Showing 11 to 20 out of 54 Questions
1 2 3 4 5 6
11.

In the architecture of a database system external level is the __________

(a)

Physical level
(b)

Logical level
(c)

Conceptual level
(d)

View level
Answer:

Option (d)

12.

Architecture of the database can be viewed as

(a)

Two levels
(b)

Three levels
(c)

Four levels
(d)

One level
Answer:

Option (b)

13.

An advantage of the database management approach is 

(a)

Data is dependent on programs
(b)

Data redundancy increases
(c)

Data is integrated and can be accessed by multiple programs
(d)

Easy to use
Answer:

Option (c)

14.

Data independence means

(a)

Data is defined separately and not included in programs
(b)

Programs are not dependent on the physical attributes of data
(c)

Programs are not dependent on the logical attributes of data
(d)

Both programs are not dependent on the physical attributes of data & programs are not dependent on the logical attributes of data
Answer:

Option (d)

15.

Which is not the Applications of the database system?

(a)

Sales
(b)

Accounting
(c)

Banking and finance
(d)

Calculation based website or apps
Answer:

Option (d)

16.

DBMS is ________

(a)

A collection of the data only
(b)

A collection of interrelated data and set of programs to access those data
(c)

A collection of the program
(d)

A collection of the software
Answer:

Option (b)

17.

Which of the following is the disadvantage of the file processing system?

(a)

Data Redundancy
(b)

Easy to use
(c)

No trained staff required
(d)

Low cost
Answer:

Option (a)

18.

Redundancy means

(a)

Uniqueness
(b)

Duplication
(c)

Weakness
(d)

Slowness
Answer:

Option (b)

19.

Concurrent access means

(a)

Accessing system by only single user at a time
(b)

Accessing System by more than one user one by one
(c)

Accessing system by more than one user at a time (simultaneously)
(d)

Accessing system by single only
Answer:

Option (c)

20.

How many levels are therer in data abstraction?

(a)

One
(b)

Two
(c)

Three
(d)

Four
Answer:

Option (c)

Showing 11 to 20 out of 54 Questions
1 2 3 4 5 6