Question 1

Which SQL keyword is used to change the values of an entire column?

Accepted Answer

A) CHANGE 
B) INSERT 
C) SELECT 
D) SET 
E) MODIFY 
A) CHANGE 
B) INSERT 
C) SELECT 
D) SET 
E) MODIFY

Question 2

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

Accepted Answer

A) the SQL interpreter 
B) the application code 
C) the embedded SQL code 
D) the trigger code 
E) the stored procedure code 
A) the SQL interpreter 
B) the application code 
C) the embedded SQL code 
D) the trigger code 
E) the stored procedure code

Question 3

Because SQL statements are table-oriented,whereas programs are variable-oriented,the results of SQL statements used in programs are treated as pseudofiles.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) the SELECT clause 
B) the FROM clause 
C) the WHERE clause 
D) the ORDER BY clause 
E) SQL view statements can use all of the listed clauses. 
A) the SELECT clause 
B) the FROM clause 
C) the WHERE clause 
D) the ORDER BY clause 
E) SQL view statements can use all of the listed clauses.

Question 5

Rows can be removed from a table by using the SQL DELETE statement.

Accepted Answer

A) True 
 B)False

Question 6

Which SQL keyword is used to impose restrictions on a table,data or relationship?

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

The SQL SET keyword is used to specify a new value when changing a column value.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

SQL triggers can be used with SQL operations INSERT UPDATE,and DELETE.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is an SQL trigger Oracle supports?

Accepted Answer

A) BEFORE 
B) INSTEAD OF 
C) AFTER 
D) B and C only 
E) A,B and C 
A) BEFORE 
B) INSTEAD OF 
C) AFTER 
D) B and C only 
E) A,B and C

Question 12

One advantage of using the CONSTRAINT phrase to define a primary 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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

The SQL keyword CONSTRAINT is used to define one of five types of constraints.

Accepted Answer

A) True 
 B)False

Question 17

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 18

An SQL virtual table 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 19

A set of SQL statements stored in an application written in a standard programming language 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 20

Unless it is being used to copy data from one table to another,the SQL INSERT statement can be used to insert only a single row into a table.

Accepted Answer

A) True 
 B)False

Exam 7: SQL for Database Construction and Application Processing

Which SQL keyword is used to change the values of an entire column?

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

Because SQL statements are table-oriented,whereas programs are variable-oriented,the results of SQL statements used in programs are treated as pseudofiles.

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

Rows can be removed from a table by using the SQL DELETE statement.

Which SQL keyword is used to impose restrictions on a table,data or relationship?

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

The SQL SET keyword is used to specify a new value when changing a column value.

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

SQL triggers can be used with SQL operations INSERT UPDATE,and DELETE.

Which of the following is an SQL trigger Oracle supports?

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

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

Stored procedures have the advantage of ________.

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

The SQL keyword CONSTRAINT is used to define one of five types of constraints.

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.

An SQL virtual table is called ________.

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

Unless it is being used to copy data from one table to another,the SQL INSERT statement can be used to insert only a single row into a table.

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