Computer Science - Database Systems

Exercise : Database Systems - Section 3
46.
In SQL, the CREATE TABLESPACE is used
to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
to create a database trigger
to add/rename data files, to change storage
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

47.
In SQL, which command is used to remove a stored function from the database?
REMOVE FUNCTION
DELETE FUNCTION
DROP FUNCTION
ERASE FUNCTION
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

48.
The database administration function includes
application programming
computer operations management
database access planning
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

49.
A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
tables
relations
tuple
both (a) and (b)
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

50.
A command that lets you change one or more fields in a record is
Insert
Modify
Look-up
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.