Exercise: Database Systems

Questions for: Database Systems

Goals for the design of the logical schema include
A:
avoiding data inconsistency
B:
being able to construct queries easily
C:
being able to access data efficiently
D:
All of the above
Answer: D
No answer description is available. Let's discuss.
Administrate supervision of database activities is the responsibility of the
A:
Database administrator
B:
DP Manager
C:
DB Manager
D:
DP administration
Answer: A
No answer description is available. Let's discuss.
Report generators are used to
A:
store data input by a user
B:
retrieve information from files
C:
answer queries
D:
both (b) and (c)
Answer: D
No answer description is available. Let's discuss.
In SQL, which command(s) is(are) used to recompile a stored function?
A:
SET FUNCTION
B:
SET STORED FUNCTION
C:
ALTER FUNCTION
D:
All of the above
Answer: C
No answer description is available. Let's discuss.
In order to use a DBMS, it is important to understand
A:
the physical schema
B:
all sub-schemas that the system supports
C:
one subschema
D:
both (a) and (b)
Answer: C
No answer description is available. Let's discuss.
Ad Slot (Above Pagination)
Quiz