Question 1

When a trigger is fired,the DBMS makes the appropriate data available to the trigger code.

Accepted Answer

A) True 
 B)False  True

Question 2

If a trigger is being written to enforce referential integrity actions,you cannot use an INSTEAD OF trigger.

Accepted Answer

A) True 
 B)False  False

Question 3

A stored program that is stored within the database and compiled when used is called a trigger.

Accepted Answer

A) True 
 B)False  False

Question 4

A stored program that is attached to a table or view is called ________.

Accepted Answer

A) a CHECK constraint 
B) a view 
C) embedded SQL 
D) a trigger 
E) a stored procedure 
A) a CHECK constraint 
B) a view 
C) embedded SQL 
D) a trigger 
E) a stored procedure

Question 5

The following database will be used in this question:
GENERAL SALES DATABASE:
SALESREP
   
CUSTOMER
   
What is an SQL view,and what is it used for? Include an example based on the CUSTOMER table of the General Sales Database.

Accepted Answer

An SQL view is a virtual table construct

Question 6

Which SQL keyword is used to delete a table's structure?

Accepted Answer

A) DELETE 
B) DROP 
C) DISPOSE 
D) ALTER 
E) MODIFY 
A) DELETE 
B) DROP 
C) DISPOSE 
D) ALTER 
E) MODIFY

Question 7

Explain the essential format of the CREATE TABLE statement.

Accepted Answer

The essential format for the CREATE TABL

Question 8

What are SQL triggers and how are they used?

Accepted Answer

An SQL trigger is a stored program that

Question 9

Stored procedures have the advantage of greater security,decreased network traffic,SQL optimized by the DBMS compiler,and code sharing.

Accepted Answer

A) True 
 B)False

Question 10

SQL views are used ________.

Accepted Answer

A) to hide columns 
B) to show results of computed columns 
C) to hide complicated SQL statements 
D) to provide a level of indirection between data processed by applications and the data actually stored in the database tables 
E) SQL views are used for all of the above. 
A) to hide columns 
B) to show results of computed columns 
C) to hide complicated SQL statements 
D) to provide a level of indirection between data processed by applications and the data actually stored in the database tables 
E) SQL views are used for all of the above.

Question 11

The SQL keyword CHECK is used to limit column values to specific values.

Accepted Answer

A) True 
 B)False

Question 12

The SQL keyword used to limit column values to specific values is ________.

Accepted Answer

A) CONSTRAINT 
B) CHECK 
C) NOT NULL 
D) UNIQUE 
E) UPDATE 
A) CONSTRAINT 
B) CHECK 
C) NOT NULL 
D) UNIQUE 
E) UPDATE

Question 13

One advantage of using the CONSTRAINT command to define a primary key is that the database designer controls the name of the constraint.

Accepted Answer

A) True 
 B)False

Question 14

Rows in a table can be changed by using the SQL UPDATE statement.

Accepted Answer

A) True 
 B)False

Question 15

Discuss SQL data types.

Accepted Answer

Common examples of standard SQL data typ

Question 16

SQL triggers are created using the SQL ADD TRIGGER statement.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not an ANSI SQL trigger?

Accepted Answer

A) BEFORE UPDATE 
B) INSTEAD OF UPDATE 
C) BEFORE INSERT 
D) INSTEAD OF CONSTRAINT 
E) AFTER DELETE 
A) BEFORE UPDATE 
B) INSTEAD OF UPDATE 
C) BEFORE INSERT 
D) INSTEAD OF CONSTRAINT 
E) AFTER DELETE

Question 18

SQL views are constructed from SELECT statements.

Accepted Answer

A) True 
 B)False

Question 19

A stored program that is attached to a table or view is called a stored procedure.

Accepted Answer

A) True 
 B)False

Question 20

The SQL CREATE statement is used to name a new table and describe the table's columns.

Accepted Answer

A) True 
 B)False

Exam 7: SQL for Database Construction and Application Processing

When a trigger is fired,the DBMS makes the appropriate data available to the trigger code.

If a trigger is being written to enforce referential integrity actions,you cannot use an INSTEAD OF trigger.

A stored program that is stored within the database and compiled when used is called a trigger.

A stored program that is attached to a table or view is called ________.

The following database will be used in this question: GENERAL SALES DATABASE: SALESREP CUSTOMER What is an SQL view,and what is it used for? Include an example based on the CUSTOMER table of the General Sales Database.

Which SQL keyword is used to delete a table's structure?

Explain the essential format of the CREATE TABLE statement.

What are SQL triggers and how are they used?

Stored procedures have the advantage of greater security,decreased network traffic,SQL optimized by the DBMS compiler,and code sharing.

SQL views are used ________.

The SQL keyword CHECK is used to limit column values to specific values.

The SQL keyword used to limit column values to specific values is ________.

One advantage of using the CONSTRAINT command to define a primary key is that the database designer controls the name of the constraint.

Rows in a table can be changed by using the SQL UPDATE statement.

Discuss SQL data types.

SQL triggers are created using the SQL ADD TRIGGER statement.

Which of the following is not an ANSI SQL trigger?

SQL views are constructed from SELECT statements.

A stored program that is attached to a table or view is called a stored procedure.

The SQL CREATE statement is used to name a new table and describe the table's columns.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters