Computer Science - Database Systems

Exercise :: Database Systems - Section 3

21. 

Related fields in a data base are grouped to form

A. data file
B. data record
C. menu
D. bank
E. None of the above

Answer: Option B

Explanation:

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

22. 

A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.

A. One-to-one relationship
B. One-to-many relationship
C. Many-to-one relationship
D. Many-to-many relationship
E. None of the above

Answer: Option D

Explanation:

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

23. 

In SQL, the _____ command is used to recompile a view

A. COMPILE VIEW
B. DEFINE VIEW
C. CREATE VIEW
D. ALTER VIEW
E. None of the above

Answer: Option D

Explanation:

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

24. 

A list in alphabetical order

A. is in descending order
B. is in ascending order
C. is the result of a sort operation
D. both (b) and (c)
E. None of the above

Answer: Option D

Explanation:

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

25. 

If a piece of data is stored in two places in the database, then

A. storage space is wasted
B. changing the data is one spot will cause data inconsistency
C. it can be more easily accessed
D. both (a) and (b)
E. None of the above

Answer: Option D

Explanation:

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