Drm Exma Ii

Chapter 6

1. Which of the following is a purpose of the SQL standard?
A) To specify syntax and semantics of SQL data definition and manipulation
B) To specify minimal and complete standards, which permit different degrees of adoption in products
C) To define the data structures and basic operations for SQL databases
D) All of the above

Answer: D
Level: Moderate Page Ref: 312
Topic: The Role of SQL in a Database Architecture
AACSB Use of Information Technology 2. The benefits of a standardized relational language include:
A) application longevity.
B) reduced training costs.
C) cross-system communication.
D) All of the above

Answer: D
Level: Moderate Page Ref: 313
Topic: The Role of SQL in a Database Architecture
AACSB Use of Information Technology

3. The _____ is the structure that contains descriptions of objects such as tables and views created by users.
A) SQL
B) schema
C) catalog
D) master view

Answer: B
Level: Easy Page Ref: 314
Topic: The SQL Environment
AACSB Use of Information Technology, Analytic Skills

4. _____ is a set of commands used to control a database, which includes security.
A) DML
B) DDL
C) DCL
D) DPL

Answer: C
Level: Easy Page Ref:315
Topic: The SQL Environment
AACSB Use of Information Technology

5. _____ is a set of commands used to update and query a database.
A) DML
B) DDL
C) DCL
D) DPL

Answer: A
Level: Easy Page Ref: 315
Topic: The SQL Environment AACSB Use of Information Technology

6. DDL is typically used during which phases of the development process?
A) Implementation
B) Physical design
C) Analysis
D) All of the above Answer: B
Level: Difficult Page Ref: 314, 315
Topic: The SQL Environment
AACSB Use of Information Technology, Analytic Skills

7. The SQL command _____ defines a logical table from one or more tables or views.
A) create table
B) alter table
C) create view
D) create relationship

Answer: C
Level: