Question 1

SQL triggers can be used when the DBMS receives an INSERT request.

Accepted Answer

A) True 
 B)False

Question 2

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 
E) the SQL 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 
E) the SQL CONSTRAINT TRIGGER statement

Question 3

The SQL keyword MODIFY is used to change the structure,properties or constraints of a table.

Accepted Answer

A) True 
 B)False

Question 4

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 5

The Oracle DBMS supports the SQL BEFORE trigger.

Accepted Answer

A) True 
 B)False

Question 6

What are SQL stored procedures and how are they used?

Accepted Answer

An SQL stored procedure is a stored prog

Question 7

One or more rows can be added to a table by using the SQL INSERT statement.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

If the table PRODUCT has a column PRICE,and PRICE has the data type Numeric (8,2),the value 98765 stored in that field will be displayed by the DBMS as 98765.00.

Accepted Answer

A) True 
 B)False

Question 10

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 author does 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 author does not demonstrate a preference for how to define a primary key.

Question 11

Unlike application code,stored procedures are never distributed to the client computers.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The SQL keyword PRIMARY KEY is used to designate the column(s)that are the primary key for the table.

Accepted Answer

A) True 
 B)False

Question 14

The SQL keyword DELETE is used to delete a table's structure.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

Because SQL statements are set-oriented,whereas programs are element-oriented,the results of SQL statements used in programs are treated as ________.

Accepted Answer

A) tables 
B) columns 
C) rows 
D) files 
E) pseudofiles 
A) tables 
B) columns 
C) rows 
D) files 
E) pseudofiles

Question 17

In an SQL query of two tables,which SQL keyword indicates that we want data from all the rows of one table to be included in the result,even if the row does not correspond to any data in the other table?

Accepted Answer

A) LEFT JOIN 
B) RIGHT JOIN 
C) INCLUDE 
D) A and B 
E) A,B and C 
A) LEFT JOIN 
B) RIGHT JOIN 
C) INCLUDE 
D) A and B 
E) A,B and C

Question 18

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 19

Which SQL keyword is used to add one or more rows of data to a table?

Accepted Answer

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

Question 20

Joins that show only matching rows from the joined tables in their results are called inner joins.

Accepted Answer

A) True 
 B)False

Exam 7: SQL for Database Construction and Application Processing

SQL triggers can be used when the DBMS receives an INSERT request.

SQL triggers are created using ________.

The SQL keyword MODIFY is used to change the structure,properties or constraints of a table.

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

The Oracle DBMS supports the SQL BEFORE trigger.

What are SQL stored procedures and how are they used?

One or more rows can be added to a table by using the SQL INSERT statement.

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

If the table PRODUCT has a column PRICE,and PRICE has the data type Numeric (8,2),the value 98765 stored in that field will be displayed by the DBMS as 98765.00.

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

Unlike application code,stored procedures are never distributed to the client computers.

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

The SQL keyword PRIMARY KEY is used to designate the column(s)that are the primary key for the table.

The SQL keyword DELETE is used to delete a table's structure.

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

Because SQL statements are set-oriented,whereas programs are element-oriented,the results of SQL statements used in programs are treated as ________.

In an SQL query of two tables,which SQL keyword indicates that we want data from all the rows of one table to be included in the result,even if the row does not correspond to any data in the other table?

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

Which SQL keyword is used to add one or more rows of data to a table?

Joins that show only matching rows from the joined tables in their results are called inner joins.

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