Question 1

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 2

If the values in an SQL view are not changeable through the view itself,you may still be able to update the view by using unique application logic.In this case,the specific logic is placed in an INSTEAD OF trigger.

Accepted Answer

A) True 
 B)False

Question 3

SQL triggers are created using the SQL ADD TRIGGER statement.

Accepted Answer

A) True 
 B)False

Question 4

If the table PRODUCT has a column PRICE that has the data type Numeric (8,2),the value 12345 will be displayed by the DBMS as ________.

Accepted Answer

A) 123.45 
B) 12345 
C) 12345.00 
D) 123450.00 
E) 00012345 
A) 123.45 
B) 12345 
C) 12345.00 
D) 123450.00 
E) 00012345

Question 5

The values in an SQL view are always changeable through the view itself.

Accepted Answer

A) True 
 B)False

Question 6

If the table ITEM has a column WEIGHT,and WEIGHT has the data type Numeric (7,2),the value 4321 with be displayed by the DBMS as 43.21.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following illustrates the authors' preferred style of defining a primary key?

Accepted Answer

A) CREATE TABLE CUSTOMER (
CustomerID Integer Primary Key
LastName Char(35)Not Null
First Name Char(25)Null 
B) CREATE TABLE CUSTOMER (
CustomerID Integer Not Null
LastName Char(35)Not Null
First Name Char(25)Null
CONSTRAINT CustomerPK PRIMARY KEY (CustomerI
D)  
C) CREATE TABLE CUSTOMER (
CustomerID Integer Not Null
LastName Char(35)Not Null
First Name Char(25)Null 
D) either B or C 
E) The authors do not demonstrate a preference for how to define a primary key. 
A) CREATE TABLE CUSTOMER (
CustomerID Integer Primary Key
LastName Char(35)Not Null
First Name Char(25)Null 
B) CREATE TABLE CUSTOMER (
CustomerID Integer Not Null
LastName Char(35)Not Null
First Name Char(25)Null
CONSTRAINT CustomerPK PRIMARY KEY (CustomerI
D)  
C) CREATE TABLE CUSTOMER (
CustomerID Integer Not Null
LastName Char(35)Not Null
First Name Char(25)Null 
D) either B or C 
E) The authors do not demonstrate a preference for how to define a primary key.

Question 8

The SQL keyword CONSTRAINT is used in conjunction with the SQL keywords PRIMARY KEY and FOREIGN KEY.

Accepted Answer

A) True 
 B)False

Question 9

When the correct SQL command is used to delete a table's structure,the command can only be used with a table that has already had its data removed.

Accepted Answer

A) True 
 B)False

Question 10

What is embedded SQL,and what considerations are necessary when using it in an application?

Accepted Answer

Embedded SQL are SQL statements used,or

Question 11

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of less work,standardized processing,and specialization among developers.

Accepted Answer

A) True 
 B)False

Question 12

According to the SQL-92,statements used to construct views cannot contain the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 13

One advantage of using the CONSTRAINT phrase to define a primary key is that the database designer controls the ________.

Accepted Answer

A) name of the primary key 
B) name of the foreign key 
C) name of the constraint 
D) A and B 
E) A,B,and C 
A) name of the primary key 
B) name of the foreign key 
C) name of the constraint 
D) A and B 
E) A,B,and C

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

When the correct SQL command is used to delete a table's structure,what happens to the data in the table?

Accepted Answer

A) If the deleted table was a parent table,the data is added to the appropriate rows of the child table. 
B) If the deleted table was a child table,the data is added to the appropriate rows of the parent table. 
C) The data in the table is also deleted. 
D) Nothing because there was no data in the table since only an empty table can be deleted. 
E) A and B 
A) If the deleted table was a parent table,the data is added to the appropriate rows of the child table. 
B) If the deleted table was a child table,the data is added to the appropriate rows of the parent table. 
C) The data in the table is also deleted. 
D) Nothing because there was no data in the table since only an empty table can be deleted. 
E) A and B

Question 17

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 18

Stored procedures have the advantage of ________.

Accepted Answer

A) greater security 
B) decreased network traffic 
C) SQL optimized by the DBMS compiler 
D) code sharing 
E) All of the above 
A) greater security 
B) decreased network traffic 
C) SQL optimized by the DBMS compiler 
D) code sharing 
E) All of the above

Question 19

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of ________.

Accepted Answer

A) less work 
B) standardized processing 
C) specialization among developers 
D) A and B 
E) A,B,and C 
A) less work 
B) standardized processing 
C) specialization among developers 
D) A and B 
E) A,B,and C

Question 20

SQL views can be used to hide columns.

Accepted Answer

A) True 
 B)False

Exam 7: Sql for Database Construction and Application Processing

Which of the following is not an ANSI SQL trigger?

If the values in an SQL view are not changeable through the view itself,you may still be able to update the view by using unique application logic.In this case,the specific logic is placed in an INSTEAD OF trigger.

SQL triggers are created using the SQL ADD TRIGGER statement.

If the table PRODUCT has a column PRICE that has the data type Numeric (8,2),the value 12345 will be displayed by the DBMS as ________.

The values in an SQL view are always changeable through the view itself.

If the table ITEM has a column WEIGHT,and WEIGHT has the data type Numeric (7,2),the value 4321 with be displayed by the DBMS as 43.21.

Which of the following illustrates the authors' preferred style of defining a primary key?

The SQL keyword CONSTRAINT is used in conjunction with the SQL keywords PRIMARY KEY and FOREIGN KEY.

When the correct SQL command is used to delete a table's structure,the command can only be used with a table that has already had its data removed.

What is embedded SQL,and what considerations are necessary when using it in an application?

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of less work,standardized processing,and specialization among developers.

According to the SQL-92,statements used to construct views cannot contain the WHERE clause.

One advantage of using the CONSTRAINT phrase to define a primary key is that the database designer controls the ________.

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

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

When the correct SQL command is used to delete a table's structure,what happens to the data in the table?

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

Stored procedures have the advantage of ________.

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of ________.

SQL views can be used to hide 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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

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 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters