Database Systems – Section 3

46. In SQL, the CREATE TABLESPACE is used

A. to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
B. to create a database trigger
C. to add/rename data files, to change storage
D. All of the above
E. None of the above

Correct Answer: A. to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace

47. In SQL, which command is used to remove a stored function from the database?

A. REMOVE FUNCTION
B. DELETE FUNCTION
C. DROP FUNCTION
D. ERASE FUNCTION
E. None of the above

Correct Answer: C. DROP FUNCTION

48. The database administration function includes

A. application programming
B. computer operations management
C. database access planning
D. All of the above
E. None of the above

Correct Answer: C. database access planning

49. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As

A. tables
B. relations
C. tuple
D. both (a) and (b)
E. None of the above

Correct Answer: D. both (a) and (b)

50. A command that lets you change one or more fields in a record is

A. Insert
B. Modify
C. Look-up
D. All of the above
E. None of the above

Correct Answer: B. Modify

Leave A Comment?

10 − four =