Question 1

The following SQL statement uses a(n) ____. SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

Accepted Answer

A)  set operator 
B)  natural join 
C)  "old-style" join 
D)  procedural statement 
A)  set operator 
B)  natural join 
C)  "old-style" join 
D)  procedural statement

Question 2

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

Accepted Answer

A) True 
 B)False

Question 3

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

Accepted Answer

A) True 
 B)False

Question 4

An alternate syntax for a join is SELECT column-list FROM table1 JOIN table2 ____________________ (common-column).

Accepted Answer

The answer of An alternate syntax for a join is...

Question 5

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

Accepted Answer

A)  8 
B)  18 
C)  26 
D)  144 
A)  8 
B)  18 
C)  26 
D)  144

Question 6

What are SQL functions and when are they used? Provide a couple of examples of situations in which they are necessary.

Accepted Answer

SQL functions are very useful tools. You

Question 7

In a subquery, the ____ query is executed first.

Accepted Answer

A)  left 
B)  right 
C)  inner 
D)  outer 
A)  left 
B)  right 
C)  inner 
D)  outer

Question 8

The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables.

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ join is the traditional join in which only rows that meet a given criteria are selected.

Accepted Answer

The answer of The ____________________ join is the traditional join...

Question 10

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

Accepted Answer

A) True 
 B)False

Question 11

The Oracle string concatenation function is ____.

Accepted Answer

A)  CONCAT 
B)  + 
C)  || 
D)  && 
A)  CONCAT 
B)  + 
C)  || 
D)  &&

Question 12

The use of the ____________________ operator allows you to compare a single value with a list of values returned by the first subquery (sqA) using a comparison operator other than EQUALS.

Accepted Answer

The answer of The use of the ____________________ operator allows...

Question 13

In MS Access, you can use the ____________________ data type to define a column in your table that will be automatically populated with unique numeric values.

Accepted Answer

The answer of In MS Access, you can use the...

Question 14

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion.

Accepted Answer

A) True 
 B)False

Question 15

Procedural code is executed on the database client machine.

Accepted Answer

A) True 
 B)False

Question 16

One of the disadvantages of stored procedures is that they increase network traffic.

Accepted Answer

A) True 
 B)False

Question 17

Assume you are using the MINUS operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the MINUS operator?

Accepted Answer

A)  0 
B)  2 
C)  8 
D)  10 
A)  0 
B)  2 
C)  8 
D)  10

Question 18

A(n) ____________________ join returns not only the matching rows but also the rows with unmatched attribute values for one or both tables to be joined.

Accepted Answer

The answer of A(n) ____________________ join returns not only the...

Question 19

In Oracle, ____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.

Accepted Answer

A)  triggers 
B)  indexes 
C)  embedded SQL 
D)  procedural SQL 
A)  triggers 
B)  indexes 
C)  embedded SQL 
D)  procedural SQL

Question 20

Assume you are using the UNION operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION operator?

Accepted Answer

A)  7 
B)  10 
C)  15 
D)  17 
A)  7 
B)  10 
C)  15 
D)  17

The following SQL statement uses a(n) ____. SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

An alternate syntax for a join is SELECT column-list FROM table1 JOIN table2 ____________________ (common-column).

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

What are SQL functions and when are they used? Provide a couple of examples of situations in which they are necessary.

In a subquery, the ____ query is executed first.

The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables.

The ____________________ join is the traditional join in which only rows that meet a given criteria are selected.

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

The Oracle string concatenation function is ____.

The use of the ____________________ operator allows you to compare a single value with a list of values returned by the first subquery (sqA) using a comparison operator other than EQUALS.

In MS Access, you can use the ____________________ data type to define a column in your table that will be automatically populated with unique numeric values.

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion.

Procedural code is executed on the database client machine.

One of the disadvantages of stored procedures is that they increase network traffic.

A(n) ____________________ join returns not only the matching rows but also the rows with unmatched attribute values for one or both tables to be joined.

In Oracle, ____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters

Exam 6: Procedural Language Sql and Advanced Sql

The following SQL statement uses a(n) ____. SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

An alternate syntax for a join is SELECT column-list FROM table1 JOIN table2 ____________________ (common-column).

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

What are SQL functions and when are they used? Provide a couple of examples of situations in which they are necessary.

In a subquery, the ____ query is executed first.

The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables.

The ____________________ join is the traditional join in which only rows that meet a given criteria are selected.

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

The Oracle string concatenation function is ____.

The use of the ____________________ operator allows you to compare a single value with a list of values returned by the first subquery (sqA) using a comparison operator other than EQUALS.

In MS Access, you can use the ____________________ data type to define a column in your table that will be automatically populated with unique numeric values.

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion.

Procedural code is executed on the database client machine.

One of the disadvantages of stored procedures is that they increase network traffic.

A(n) ____________________ join returns not only the matching rows but also the rows with unmatched attribute values for one or both tables to be joined.

In Oracle, ____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters