Database Systems – Section 4

1. In SQL, the command(s) is(are) used to create an index for a table or cluster

A. CREATE INDEX
B. MODIFY INDEX
C. SET INDEX TO FILE
D. All of the above
E. None of the above

Correct Answer: A. CREATE INDEX

2. There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?

A. Data storage system
B. Database management system (DBMS)
C. Batch processing system
D. Data communication package
E. None of the above

Correct Answer: B. Database management system (DBMS)

3. A _____ DBMS distributes data processing tasks between the workstation and a network server.

A. Network
B. Relational
C. Client Server
D. Hierarchical
E. None of the above.

Correct Answer: C. Client Server

4. Information can be transferred between the DBMS and a

A. spreadsheet program
B. word processor program
C. graphics program
D. All of the above
E. None of the above

Correct Answer: D. All of the above

5. Data integrity control

A. is used to set upper and lower limits on numeric data
B. requires the use of passwords to prohibit unauthorized access to the file
C. has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
D. All of the above
E. None of the above

Correct Answer: C. has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files

Leave A Comment?

15 − three =