Computer Science - Database Systems

Exercise :: Database Systems - Section 3

26. 

A data dictionary is a special file that contains

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

Answer: Option D

Explanation:

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

27. 

A file that is organized in uniform format is formally referred to as a _____ or a database file.

A. Document
B. Database
C. Record
D. Structured data file
E. None of the above

Answer: Option D

Explanation:

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

28. 

A form can be used to

A. modify records
B. delete records
C. format printed output
D. All of the above
E. None of the above

Answer: Option D

Explanation:

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

29. 

Which language has recently become the de-facto standard for interfacing application programs with relational database system?

A. Oracle
B. SQL
C. dBASE
D. 4GL
E. None of the above

Answer: Option B

Explanation:

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

30. 

In SQL, the CREATE TABLE is used

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

Answer: Option A

Explanation:

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