Database Systems – Section 2

31. A _____ means that one record in a particular record type is related to only one record of another record type.

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: A. One-to-one relationship

32. A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.

A. Network
B. Hierarchical
C. Relational
D. Object-Oriented
E. None of the above

Correct Answer: C. Relational

33. In SQL, which command(s) is(are) used to redefine an index’s future storage allocation

A. ALTER INDEX
B. REDEFINE INDEX
C. MODIFY INDEX
D. DO INDEX
E. None of the above

Correct Answer: A. ALTER INDEX

34. Which of the following is a serious problem of file management systems?

A. difficult to update
B. lack of data independence
C. data redundancy
D. program dependence
E. All of the above

Correct Answer: E. All of the above

35. With respect to data input, the most accurate description of batch control is

A. dividing documents to be entered into batches
B. controlling the input of each input clerk
C. comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
D. All of the above
E. None of the above

Correct Answer: C. comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system

Leave A Comment?

20 + 18 =