Database Systems - Section 1 (4)

25.

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

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

26.

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

Answer: Option E

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

28.

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

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

29.

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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

30.

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

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

31.

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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

32.

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

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

1
2
3
4
5
6