Computer Science - Database Systems

Exercise : 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.
One-to-one relationship
One-to-many relationship
Many-to-one relationship
Many-to-many relationship
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

32.
A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
Network
Hierarchical
Relational
Object-Oriented
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

33.
In SQL, which command(s) is(are) used to redefine an index's future storage allocation
ALTER INDEX
REDEFINE INDEX
MODIFY INDEX
DO INDEX
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

34.
Which of the following is a serious problem of file management systems?
difficult to update
lack of data independence
data redundancy
program dependence
All of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

35.
With respect to data input, the most accurate description of batch control is
dividing documents to be entered into batches
controlling the input of each input clerk
comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.