Exercise: Database Systems

Questions for: Database Systems

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
Answer: C
No answer description is available. Let's discuss.
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
Answer: E
No answer description is available. Let's discuss.
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
Answer: A
No answer description is available. Let's discuss.
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
Answer: C
No answer description is available. Let's discuss.
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
Answer: A
No answer description is available. Let's discuss.
Ad Slot (Above Pagination)
Quiz