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

Correct Answer: B. data record

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

Correct Answer: D. Many-to-many relationship

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

Correct Answer: D. ALTER VIEW

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

Correct Answer: D. both (b) and (c)

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

Correct Answer: D. both (a) and (b)

Leave A Comment?

18 − four =