Database Systems MCQ Questions & Answers | Computer Science

A. DEFINE TABLE

B. MODIFY TABLE

C. ALTER TABLE

D. All of the above

E. None of the above

A. to add/rename data files

B. to change storage characteristics

C. to take a tablespace online/offline

D. to begin/end a backup

E. All of the above

A. DML

B. DDL

C. query language

D. All of the above

E. None of the above

A. FORTRAN

B. AUTOFLOW

C. BPL

D. TOTAL

E. None of the above

A. is used to make back-up copies

B. is the recorded history of operations performed on a file

C. can be used to restore lost information

D. All of the above

E. None of the above

A. Two concurrent activities interact to cause a processing error

B. two users of the DBMS are interacting with different files at the same time

C. both (a) and (b)

D. All of the above

E. None of the above

A. sorts a file using a single key

B. sorts file using two keys

C. establishes an index for a file

D. both (b) and (c)

E. None of the above

A. forecasting report

B. exception report

C. regularly scheduled report

D. on demand report

E. None of the above

A. CREATE SCHEMA

B. CREATE SYNONYM

C. CREATE SAME

D. All of the above

E. None of the above

A. Network

B. Distributed

C. Hierarchical

D. Object-Oriented

E. None of the above