Computer Science - Database Systems

Exercise : Database Systems - Section 4
6.
In order to use a DBMS, it is important to understand
the physical schema
all sub-schemas that the system supports
one subschema
both (a) and (b)
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

7.
In SQL, which command(s) is(are) used to recompile a stored function?
SET FUNCTION
SET STORED FUNCTION
ALTER FUNCTION
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

8.
Report generators are used to
store data input by a user
retrieve information from files
answer queries
both (b) and (c)
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

9.
Administrate supervision of database activities is the responsibility of the
Database administrator
DP Manager
DB Manager
DP administration
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

10.
Goals for the design of the logical schema include
avoiding data inconsistency
being able to construct queries easily
being able to access data efficiently
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.