Computer Science - Database Systems

Exercise :: 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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

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.

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.