Question 1

SQL triggers are used for ________.

Accepted Answer

A) validity checking 
B) providing default values 
C) updating views 
D) A and B 
E) A,B and C 
A) validity checking 
B) providing default values 
C) updating views 
D) A and B 
E) A,B and C

Question 2

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 3

Based on the tables below,which of the following SQL statements would increase the balance of the Gonzales 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 PLUS (100)
SELECT Balance
WHERE CustName = 'Gonzales'; 
D) INSERT INTO CUSTOMER VALUES (450)
SELECT Balance
WHERE CustName = 'Gonzales'; 
E) 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 PLUS (100)
SELECT Balance
WHERE CustName = 'Gonzales'; 
D) INSERT INTO CUSTOMER VALUES (450)
SELECT Balance
WHERE CustName = 'Gonzales'; 
E) UPDATE CUSTOMER
SET Balance = 450
WHERE CustName = 'Gonzales';

Question 4

SQL views are always updateable when ________.

Accepted Answer

A) the view is based on a single table with no computed columns,and all non-null columns are present in the view 
B) the view is based on any number of tables,with or without computed columns,and the INSTEAD OF trigger is defined for the view 
C) the view is based on multiple tables,the update is being done on the most subordinate table,and the rows of that table can be uniquely identified 
D) A and B 
E) A,B and C 
A) the view is based on a single table with no computed columns,and all non-null columns are present in the view 
B) the view is based on any number of tables,with or without computed columns,and the INSTEAD OF trigger is defined for the view 
C) the view is based on multiple tables,the update is being done on the most subordinate table,and the rows of that table can be uniquely identified 
D) A and B 
E) A,B and C

Question 5

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. 
E) an SQL stored procedure. 
A) the SQL DEFAULT constraint with the CREATE TABLE command. 
B) an SQL view. 
C) embedded SQL. 
D) an SQL trigger. 
E) an SQL stored procedure.

Question 6

The SQL keyword MODIFY is used to change a column value.

Accepted Answer

A) True 
 B)False

Question 7

The SQL keyword UNIQUE is used to define alternative keys.

Accepted Answer

A) True 
 B)False

Question 8

Which SQL statement is used to retrieve view instances?

Accepted Answer

A) CREATE 
B) DELETE 
C) INSERT 
D) SELECT 
E) UPDATE 
A) CREATE 
B) DELETE 
C) INSERT 
D) SELECT 
E) UPDATE

Question 9

Which SQL keyword is used to change the structure,properties or constraints of a table?

Accepted Answer

A) SET 
B) CREATE 
C) SELECT 
D) ALTER 
E) CONSTRAINT 
A) SET 
B) CREATE 
C) SELECT 
D) ALTER 
E) CONSTRAINT

Question 10

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 
E) None of the above is true. 
A) RepName is the primary key 
B) RepName is a foreign key 
C) RepName is a candidate key 
D) RepName is a surrogate key 
E) None of the above is true.

Question 11

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 12

To set a column value to an initial value that is selected according to some business logic,you would use the SQL DEFAULT constraint with the CREATE TABLE command.

Accepted Answer

A) True 
 B)False

Question 13

Data values to be added to a table are specified by using the SQL VALUES clause.

Accepted Answer

A) True 
 B)False

Question 14

SQL views are constructed from ________.

Accepted Answer

A) CREATE statements 
B) INSERT statements 
C) UPDATE statements 
D) SELECT statements 
E) VIEW statements 
A) CREATE statements 
B) INSERT statements 
C) UPDATE statements 
D) SELECT statements 
E) VIEW statements

Question 15

The SQL syntax JOIN ...ON can be used as an alternate way of writing an SQL join statement.

Accepted Answer

A) True 
 B)False

Question 16

The SQL command used to create a virtual table is ________.

Accepted Answer

A) CREATE VTABLE 
B) CREATE VIEW 
C) VTABLE 
D) VIEW 
E) NEWLOOK 
A) CREATE VTABLE 
B) CREATE VIEW 
C) VTABLE 
D) VIEW 
E) NEWLOOK

Question 17

An SQL virtual table is called a view.

Accepted Answer

A) True 
 B)False

Question 18

SQL views are updatable when the view is based on a single table with no computed columns,and all non-null columns are present in the view.

Accepted Answer

A) True 
 B)False

Question 19

The SQL Server DBMS supports the SQL BEFORE trigger.

Accepted Answer

A) True 
 B)False

Question 20

The following database will be used in this question:
GENERAL SALES DATABASE:
SALESREP
   
CUSTOMER
   
Explain the use of the SQL statement CREATE TABLE.Do NOT discuss the ALTER statement in your answer,but DO include an example based on the SALESREP table in the General Sales database.

Accepted Answer

The SQL statement CREATE TABLE forms tha

Exam 7: SQL for Database Construction and Application Processing

SQL triggers are used for ________.

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.

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

SQL views are always updateable when ________.

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

The SQL keyword MODIFY is used to change a column value.

The SQL keyword UNIQUE is used to define alternative keys.

Which SQL statement is used to retrieve view instances?

Which SQL keyword is used to change the structure,properties or constraints of a table?

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

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.

To set a column value to an initial value that is selected according to some business logic,you would use the SQL DEFAULT constraint with the CREATE TABLE command.

Data values to be added to a table are specified by using the SQL VALUES clause.

SQL views are constructed from ________.

The SQL syntax JOIN ...ON can be used as an alternate way of writing an SQL join statement.

The SQL command used to create a virtual table is ________.

An SQL virtual table is called a view.

SQL views are updatable when the view is based on a single table with no computed columns,and all non-null columns are present in the view.

The SQL Server DBMS supports the SQL BEFORE trigger.

The following database will be used in this question: GENERAL SALES DATABASE: SALESREP CUSTOMER Explain the use of the SQL statement CREATE TABLE.Do NOT discuss the ALTER statement in your answer,but DO include an example based on the SALESREP table in the General Sales database.

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