Question 1

A stored function uses the ____ statement to return a value.

Accepted Answer

A)  EXIT 
B)  END 
C)  RETURN 
D)  PROCESS 
A)  EXIT 
B)  END 
C)  RETURN 
D)  PROCESS

Question 2

Assume you are using the UNION ALL 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 ALL operator?

Accepted Answer

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

Question 3

Explain the different types of join operations.What are they and how do they work?

Accepted Answer

Join operations can be classified as inn

Question 4

The ____________________ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

Accepted Answer

The answer of The ____________________ statement in SQL combines rows...

Question 5

Triggers can only be used to update table values.

Accepted Answer

A) True 
 B)False

Question 6

Triggers are critical to proper database operation and management.What are some of the ways that triggers are used?

Accepted Answer

Triggers can be used to enforce constrai

Question 7

Each statement inside the PL/SQL code must end with a period (".").

Accepted Answer

A) True 
 B)False

Question 8

SQL supports the conditional execution of procedures (if..then...else statements)that are typically supported by a programming language.

Accepted Answer

A) True 
 B)False

Question 9

A(n)____ join returns not only the rows matching the join condition (that is,rows with matching values in the common columns)but also the rows with unmatched values.

Accepted Answer

A)  outer 
B)  inner 
C)  equi- 
D)  cross 
A)  outer 
B)  inner 
C)  equi- 
D)  cross

Question 10

Stored procedures must have at least one argument.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Every PL/SQL block must be given a name.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

____ is a relational set operator.

Accepted Answer

A)  MINUS 
B)  PLUS 
C)  ALL 
D)  EXISTS 
A)  MINUS 
B)  PLUS 
C)  ALL 
D)  EXISTS

Question 15

Stored procedures are executed using the EXEC command.

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

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

Question 19

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 20

Assume you are using the INTERSECT 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 INTERSECT operator?

Accepted Answer

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

A stored function uses the ____ statement to return a value.

Explain the different types of join operations.What are they and how do they work?

The ____________________ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

Triggers can only be used to update table values.

Triggers are critical to proper database operation and management.What are some of the ways that triggers are used?

Each statement inside the PL/SQL code must end with a period (".").

SQL supports the conditional execution of procedures (if..then...else statements)that are typically supported by a programming language.

A(n)____ join returns not only the rows matching the join condition (that is,rows with matching values in the common columns)but also the rows with unmatched values.

Stored procedures must have at least one argument.

In a subquery,the ____ query is executed first.

Every PL/SQL block must be given a name.

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

____ is a relational set operator.

Stored procedures are executed using the EXEC command.

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.

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

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 MS Access,you can use the ____________________ data type to define a column in your table that will be automatically populated with unique numeric values.

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 8: Advanced SQL

A stored function uses the ____ statement to return a value.

Explain the different types of join operations.What are they and how do they work?

The ____________________ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

Triggers can only be used to update table values.

Triggers are critical to proper database operation and management.What are some of the ways that triggers are used?

Each statement inside the PL/SQL code must end with a period (".").

SQL supports the conditional execution of procedures (if..then...else statements)that are typically supported by a programming language.

A(n)____ join returns not only the rows matching the join condition (that is,rows with matching values in the common columns)but also the rows with unmatched values.

Stored procedures must have at least one argument.

In a subquery,the ____ query is executed first.

Every PL/SQL block must be given a name.

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

____ is a relational set operator.

Stored procedures are executed using the EXEC command.

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.

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

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 MS Access,you can use the ____________________ data type to define a column in your table that will be automatically populated with unique numeric values.

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters