Database Systems Questions

MCQ bookmark_border

21.

The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?

A

Bits

B

Characters

C

Data field

D

Schema

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

22.

Which command is used to remove an index from the database in SQL?

A

DELETE INDEX

B

DROP INDEX

C

REMOVE INDEX

D

ROLL BACK INDEX

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

23.

An-owner-member set in the CODASYL specifications may have

A

only one owner but many owner occurrences

B

only one member but many member occurrence

C

more than one member but only one occurrence per member

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

24.

What is the name given to the database management system which is able to handle full text data, image data, audio and video?

A

Full media

B

Graphics media

C

Multimedia

D

Hypertext

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

25.

A top-to-bottom relationship among the items in a database is established by a

A

Hierarchical schema

B

Network schema

C

Relational schema

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

26.

A database management system

A

allows simultaneous access to multiple files

B

can do more than a record management system

C

is a collection of programs for managing data in a single file

D

both (a) and (b)

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

27.

Which of the following hardware components is the most important to the operation of a database management system?

A

high-resolution video display

B

printer

C

high speed, large-capacity disk

D

plotter

E

mouse

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

28.

The PROJECT command will create new table that has

A

more fields than the original table

B

more rows than the original table

C

both (a) and (b)

D

all the fields of master table

E

None of the above

Correct Answer: E

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

29.

To have a file hold a list, it is necessary to

A

identify the records in the list

B

identify the name, width and type of the fields of each record.

C

decide which fields will be used as sort or index keys

D

All of the above

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

30.

Sophisticated report generators can

A

print row-oriented reports

B

perform arithmetic operations

C

selectively retrieve and print portions of a list

D

All of the above

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion