Exercise: Database Systems

Questions for: Database Systems

If a piece of data is stored in two places in the database, then
A:
storage space is wasted
B:
changing the data is one spot will cause data inconsistency
C:
it can be more easily accessed
D:
both (a) and (b)
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
A list in alphabetical order
A:
is in descending order
B:
is in ascending order
C:
is the result of a sort operation
D:
both (b) and (c)
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
In SQL, the _____ command is used to recompile a view
A:
COMPILE VIEW
B:
DEFINE VIEW
C:
CREATE VIEW
D:
ALTER VIEW
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
A:
One-to-one relationship
B:
One-to-many relationship
C:
Many-to-one relationship
D:
Many-to-many relationship
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Related fields in a data base are grouped to form
A:
data file
B:
data record
C:
menu
D:
bank
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz