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:
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: