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

Comments

No comments yet. Why don’t you start the discussion?

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    sixteen − 10 =