Database Systems MCQ Questions & Answers | Computer Science

A. COMPILE VIEW

B. DEFINE VIEW

C. CREATE VIEW

D. ALTER VIEW

E. None of the above

A. is in descending order

B. is in ascending order

C. is the result of a sort operation

D. both (b) and (c)

E. None of the above

A. storage space is wasted

B. changing the data is one spot will cause data inconsistency

C. it can be more easily accessed

D. both (a) and (b)

E. None of the above

A. the names of all fields in all files

B. the data types of all fields in all files

C. the widths of all fields in all files

D. All of the above

E. None of the above

A. Document

B. Database

C. Record

D. Structured data file

E. None of the above

A. modify records

B. delete records

C. format printed output

D. All of the above

E. None of the above

A. Oracle

B. SQL

C. dBASE

D. 4GL

E. None of the above

A. to create a table, defining its columns, integrity constrains, and storage allocation

B. to add a column/integrity constraint to a table

C. to redefine a column

D. to change a table's storage characteristics

E. All of the above

A. There is common sharing of data among the various applications

B. It is file-oriented

C. Programs are dependent on the files

D. It is inflexible

E. All of the above are true

A. a large computer system is available

B. only a small computer system is available

C. only a few transactions are involved

D. All of the above

E. None of the above