Question 1

SQL triggers are used for providing default values,validity checking,updating views,and performing referential integrity actions.

Accepted Answer

A) True 
 B)False

Question 2

Given the SQL statement CREATE TABLE SALESREP (
SalesRepNo int NOT NULL,
RepName char(35) NOT NULL,
HireDate date NOT NULL,
CONSTRAINT SalesRepPK PRIMARY KEY (SalesRepNo),
CONSTRAINT SalesRepAK1 UNIQUE (RepName)
);
We know that ________.

Accepted Answer

A) RepName is the primary key 
B) RepName is a foreign key 
C) RepName is a candidate key 
D) RepName is a surrogate key 
A) RepName is the primary key 
B) RepName is a foreign key 
C) RepName is a candidate key 
D) RepName is a surrogate key

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 table 
B) name of the foreign key field 
C) name of the constraint 
D) name of the primary key field 
A) name of the table 
B) name of the foreign key field 
C) name of the constraint 
D) name of the primary key field

Question 5

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

SQL triggers are created using ________.

Accepted Answer

A) the SQL CREATE TRIGGER statement 
B) the SQL ADD TRIGGER statement 
C) the SQL TRIGGER statement 
D) the SQL ADD CONSTRAINT TRIGGER statement 
A) the SQL CREATE TRIGGER statement 
B) the SQL ADD TRIGGER statement 
C) the SQL TRIGGER statement 
D) the SQL ADD CONSTRAINT TRIGGER statement

Question 9

Based on the tables below,which of the following SQL statements would increase the balance of the Gonzales account by $100 to a total of $450? GENERAL SALES DATABASE:
SALESREP
  CUSTOMER

Accepted Answer

A) SELECT Gonzales
FROM CUSTOMER
INSERT VALUES PLUS (100)INTO Balance; 
B) SELECT Gonzales
FROM CUSTOMER
INSERT VALUES (450)INTO Balance; 
C) INSERT INTO CUSTOMER VALUES (450)
SELECT Balance
WHERE CustName = 'Gonzales'; 
D) UPDATE CUSTOMER
SET Balance = 450
WHERE CustName = 'Gonzales'; 
A) SELECT Gonzales
FROM CUSTOMER
INSERT VALUES PLUS (100)INTO Balance; 
B) SELECT Gonzales
FROM CUSTOMER
INSERT VALUES (450)INTO Balance; 
C) INSERT INTO CUSTOMER VALUES (450)
SELECT Balance
WHERE CustName = 'Gonzales'; 
D) UPDATE CUSTOMER
SET Balance = 450
WHERE CustName = 'Gonzales';

Question 10

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 11

What are SQL triggers and how are they used?

Accepted Answer

An SQL trigger is a stored program that

Question 12

To set a column value to an initial value that is selected according to some business logic,you would use ________.

Accepted Answer

A) the SQL DEFAULT constraint with the CREATE TABLE command 
B) an SQL view 
C) embedded SQL 
D) an SQL trigger 
A) the SQL DEFAULT constraint with the CREATE TABLE command 
B) an SQL view 
C) embedded SQL 
D) an SQL trigger

Question 13

SQL triggers use the ANSI SQL keywords BEFORE,INSTEAD OF,and AFTER.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

SQL views can be used to provide a level of insulation between data processed by applications and the data actually stored in the database tables.

Accepted Answer

A) True 
 B)False

Question 16

A set of SQL statements stored in an application written in a standard programming language is called ________.

Accepted Answer

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

Question 17

Because SQL statements are table-oriented,whereas programs are variable-oriented,the results of SQL statements used in programs are accessed using an SQL cursor.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

A set of SQL statements stored in an application written in a standard programming language is called embedded SQL.

Accepted Answer

A) True 
 B)False

Question 20

Which keyword is used to remove one or more rows from a table?

Accepted Answer

A) DELETE 
B) INSERT 
C) ERASE 
D) SET 
A) DELETE 
B) INSERT 
C) ERASE 
D) SET

Exam 7: SQL for Database Construction and Application Processing

SQL triggers are used for providing default values,validity checking,updating views,and performing referential integrity actions.

Given the SQL statement CREATE TABLE SALESREP ( SalesRepNo int NOT NULL, RepName char(35) NOT NULL, HireDate date NOT NULL, CONSTRAINT SalesRepPK PRIMARY KEY (SalesRepNo), CONSTRAINT SalesRepAK1 UNIQUE (RepName) ); We know that ________.

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

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

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

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

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

SQL triggers are created using ________.

Based on the tables below,which of the following SQL statements would increase the balance of the Gonzales account by $100 to a total of $450? GENERAL SALES DATABASE: SALESREP CUSTOMER

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

What are SQL triggers and how are they used?

To set a column value to an initial value that is selected according to some business logic,you would use ________.

SQL triggers use the ANSI SQL keywords BEFORE,INSTEAD OF,and AFTER.

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

SQL views can be used to provide a level of insulation between data processed by applications and the data actually stored in the database tables.

A set of SQL statements stored in an application written in a standard programming language is called ________.

Because SQL statements are table-oriented,whereas programs are variable-oriented,the results of SQL statements used in programs are accessed using an SQL cursor.

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

A set of SQL statements stored in an application written in a standard programming language is called embedded SQL.

Which keyword is used to remove one or more rows from a table?

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters