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
CREATE INDEX
MODIFY INDEX
SET INDEX TO FILE
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's 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?
Data storage system
Database management system (DBMS)
Batch processing system
Data communication package
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

3.
A _____ DBMS distributes data processing tasks between the workstation and a network server.
Network
Relational
Client Server
Hierarchical
None of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

4.
Information can be transferred between the DBMS and a
spreadsheet program
word processor program
graphics program
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

5.
Data integrity control
is used to set upper and lower limits on numeric data
requires the use of passwords to prohibit unauthorized access to the file
has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.