Question 1

Which SQL keyword is used to change one or more rows in a table?

Accepted Answer

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

Question 2

Joins that show the matching rows from the joined tables plus unmatched rows from one other table in their results are called outer joins.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Explain how relationships are created using SQL.

Accepted Answer

In SQL,relationships are created using a

Question 5

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

Accepted Answer

A) a BEFORE trigger 
B) an INSTEAD OF trigger 
C) an AFTER trigger 
D) Depending on the specific logic,either A or B can be used. 
E) Depending on the specific logic,any of A,B or C can be used. 
A) a BEFORE trigger 
B) an INSTEAD OF trigger 
C) an AFTER trigger 
D) Depending on the specific logic,either A or B can be used. 
E) Depending on the specific logic,any of A,B or C can be used.

Question 6

SQL triggers can be used when the DBMS receives a(n)________ request.

Accepted Answer

A) INSERT 
B) UPDATE 
C) DELETE 
D) A and B 
E) A,B and C 
A) INSERT 
B) UPDATE 
C) DELETE 
D) A and B 
E) A,B and C

Question 7

If the values in an SQL view are changeable through the view itself,which SQL statement is used to change the values?

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

SQL views can be used to hide columns.

Accepted Answer

A) True 
 B)False

Question 10

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 11

The SQL command SELECT is used to retrieve view instances.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is an SQL trigger Microsoft SQL Server 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 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

Outer joins can be either up joins or down joins.

Accepted Answer

A) True 
 B)False

Question 16

Discuss what is meant by a data type of "Numeric (10,3)."

Accepted Answer

Numeric indicates a non-integer,decimal

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Distinguish between Char and VarChar data types.

Accepted Answer

Char data type is fixed-length,so that n

Question 19

Because SQL statements are table-oriented,whereas programs are element-oriented,the results of SQL statements used in programs are accessed using ________.

Accepted Answer

A) standard programming tools 
B) custom written programming tools 
C) an SQL cursor 
D) an SQL trigger 
E) an SQL stored procedure 
A) standard programming tools 
B) custom written programming tools 
C) an SQL cursor 
D) an SQL trigger 
E) an SQL stored procedure

Question 20

Which SQL keyword is used to name a new table and describe the table's columns?

Accepted Answer

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

Exam 7: SQL for Database Construction and Application Processing

Which SQL keyword is used to change one or more rows in a table?

Joins that show the matching rows from the joined tables plus unmatched rows from one other table in their results are called outer joins.

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

Explain how relationships are created using SQL.

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

SQL triggers can be used when the DBMS receives a(n)________ request.

If the values in an SQL view are changeable through the view itself,which SQL statement is used to change the values?

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

SQL views can be used to hide columns.

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 command SELECT is used to retrieve view instances.

Which of the following is an SQL trigger Microsoft SQL Server supports?

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.

Outer joins can be either up joins or down joins.

Discuss what is meant by a data type of "Numeric (10,3)."

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

Distinguish between Char and VarChar data types.

Because SQL statements are table-oriented,whereas programs are element-oriented,the results of SQL statements used in programs are accessed using ________.

Which SQL keyword is used to name a new table and describe the table's 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

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