Exercise: Database Systems

Questions for: Database Systems

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
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Information can be transferred between the DBMS and a
A:
spreadsheet program
B:
word processor program
C:
graphics program
D:
All of the above
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
A _____ DBMS distributes data processing tasks between the workstation and a network server.
A:
Network
B:
Relational
C:
Client Server
D:
Hierarchical
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz