Question 1

Cursor-style processing involves retrieving data from the cursor,one row at a time.

Accepted Answer

A) True 
 B)False

Question 2

Describe the characteristics of an Oracle sequence.

Accepted Answer

Oracle sequences are an independent obje

Question 3

In Oracle,you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

Accepted Answer

A) True 
 B)False

Question 4

If you wish to create an inner join,but the two tables do not have a commonly named attribute,you can use a(n)____ clause.

Accepted Answer

A)  OF 
B)  USING 
C)  HAS 
D)  JOIN ON 
A)  OF 
B)  USING 
C)  HAS 
D)  JOIN ON

Question 5

The ____ operator could be used in place of MINUS if the RDBMS does not support it.

Accepted Answer

A)  IN 
B)  NOT IN 
C)  AND 
D)  UNION 
A)  IN 
B)  NOT IN 
C)  AND 
D)  UNION

Question 6

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 7

A(n)____ join will select only the rows with common values in the common attribute(s).

Accepted Answer

A)  natural 
B)  cross 
C)  full 
D)  outer 
A)  natural 
B)  cross 
C)  full 
D)  outer

Question 8

The IN subquery uses a(n)____________________ operator.

Accepted Answer

The answer of The IN subquery uses a(n)____________________ operator....

Question 9

Using Oracle ____________________,you can write a PL/SQL code block by enclosing the commands inside BEGIN and END clauses.

Accepted Answer

The answer of Using Oracle ____________________,you can write a PL/SQL...

Question 10

Stored procedures must have at least one argument.

Accepted Answer

A) True 
 B)False

Question 11

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

Accepted Answer

A) True 
 B)False

Question 12

Stored procedures help reduce code duplication by means of code isolation and code sharing.

Accepted Answer

A) True 
 B)False

Question 13

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 14

Triggers can only be used to update table values.

Accepted Answer

A) True 
 B)False

Question 15

What are the four different result types that can be returned from a subquery? For each type,explain what it is and when it is used.

Accepted Answer

One single value (one column and one row

Question 16

PL/SQL blocks have a section used to declare variables.

Accepted Answer

A) True 
 B)False

Question 17

The ____________________ statement can be used to combine rows from two queries,returning only the rows that appear in both sets.

Accepted Answer

The answer of The ____________________ statement can be used to...

Question 18

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 19

A(n)____________________ query can be used to produce a relation that retains the duplicate rows.

Accepted Answer

The answer of A(n)____________________ query can be used to produce...

Question 20

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'

Cursor-style processing involves retrieving data from the cursor,one row at a time.

Describe the characteristics of an Oracle sequence.

In Oracle,you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

If you wish to create an inner join,but the two tables do not have a commonly named attribute,you can use a(n)____ clause.

The ____ operator could be used in place of MINUS if the RDBMS does not support it.

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

A(n)____ join will select only the rows with common values in the common attribute(s).

The IN subquery uses a(n)____________________ operator.

Using Oracle ____________________,you can write a PL/SQL code block by enclosing the commands inside BEGIN and END clauses.

Stored procedures must have at least one argument.

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

Stored procedures help reduce code duplication by means of code isolation and code sharing.

Triggers can only be used to update table values.

What are the four different result types that can be returned from a subquery? For each type,explain what it is and when it is used.

PL/SQL blocks have a section used to declare variables.

The ____________________ statement can be used to combine rows from two queries,returning only the rows that appear in both sets.

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

A(n)____________________ query can be used to produce a relation that retains the duplicate rows.

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

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

Cursor-style processing involves retrieving data from the cursor,one row at a time.

Describe the characteristics of an Oracle sequence.

In Oracle,you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

If you wish to create an inner join,but the two tables do not have a commonly named attribute,you can use a(n)____ clause.

The ____ operator could be used in place of MINUS if the RDBMS does not support it.

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

A(n)____ join will select only the rows with common values in the common attribute(s).

The IN subquery uses a(n)____________________ operator.

Using Oracle ____________________,you can write a PL/SQL code block by enclosing the commands inside BEGIN and END clauses.

Stored procedures must have at least one argument.

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

Stored procedures help reduce code duplication by means of code isolation and code sharing.

Triggers can only be used to update table values.

What are the four different result types that can be returned from a subquery? For each type,explain what it is and when it is used.

PL/SQL blocks have a section used to declare variables.

The ____________________ statement can be used to combine rows from two queries,returning only the rows that appear in both sets.

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

A(n)____________________ query can be used to produce a relation that retains the duplicate rows.

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

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