Database Systems MCQ Questions & Answers | Computer Science

A. SELECT ALL FROM BOOK

B. SELECT DISTINCT SUB FROM BOOK

C. SELECT SUB FROM BOOK

D. All of the above

E. None of the above

A. is sorted in ascending order

B. contains only a list of keys and record numbers

C. has a number assigned to each record

D. both (b) and (c)

E. None of the above

A. creating the physical and logical designs

B. removing flagged records for deletion

C. creating and maintaining the data dictionary

D. monitoring performance

E. None of the above

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

A. REMOVE FUNCTION

B. DELETE FUNCTION

C. DROP FUNCTION

D. ERASE FUNCTION

E. None of the above

A. application programming

B. computer operations management

C. database access planning

D. All of the above

E. None of the above

A. tables

B. relations

C. tuple

D. both (a) and (b)

E. None of the above

A. Insert

B. Modify

C. Look-up

D. All of the above

E. None of the above