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

Correct Answer: D. All of the above

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

Correct Answer: D. Structured data file

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

Correct Answer: D. All of the above

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

Correct Answer: B. SQL

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

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

Leave A Comment?

4 + 7 =