Exercise: Database Systems

Questions for: Database Systems

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
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
A form can be used to
A:
modify records
B:
delete records
C:
format printed output
D:
All of the above
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz