Computer Science - Database Systems

Exercise :: 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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

« Prev   1 2 3 4 5 6 7 8 9 10