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
Advertisement

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
Advertisement

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
Advertisement

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
Advertisement

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
Advertisement

Leave A Comment?