Question 1

An explicit cursor must return two or more rows.

Accepted Answer

A) True 
 B)False  False

Question 2

If the DBMS does not support the INTERSECT statement,you can use a(n)____________________ subquery to achieve the same result.

Accepted Answer

IN

Question 3

The ____________________ outer join returns not only the rows matching the join condition (that is,rows with matching values in the common column),but also the rows in the left-side table with unmatched values in the right-side table.

Accepted Answer

left

Question 4

When using the Oracle TO_DATE function,the code ____ represents a three-letter month name.

Accepted Answer

A)  MON 
B)  MM3 
C)  MONTH 
D)  MM 
A)  MON 
B)  MM3 
C)  MONTH 
D)  MM

Question 5

"Union-compatible" means that the ____.

Accepted Answer

A)  names of the relation attributes can be different,but the data types must be identical 
B)  names of the relation attributes must be the same,but the data types can be different 
C)  names of the relation attributes must be the same and their data types must be identical 
D)  number of attributes must be the same,but the names and data types can be different 
A)  names of the relation attributes can be different,but the data types must be identical 
B)  names of the relation attributes must be the same,but the data types can be different 
C)  names of the relation attributes must be the same and their data types must be identical 
D)  number of attributes must be the same,but the names and data types can be different

Question 6

A(n)____________________ pools multiple transactions into a single batch to update a master table field in a single operation.

Accepted Answer

batch upda

Question 7

A(n)____________________ join returns all rows with matching values in the matching columns and eliminates duplicate columns.

Accepted Answer

The answer of A(n)____________________ join returns all rows with matching...

Question 8

In subquery terminology,the first query in the SQL statement is known as the ____ query.

Accepted Answer

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

Question 9

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 10

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 11

The PL/SQL block starts with the ____ clause.

Accepted Answer

A)  IS 
B)  OPEN 
C)  DECLARE 
D)  BEGIN 
A)  IS 
B)  OPEN 
C)  DECLARE 
D)  BEGIN

Question 12

____________________ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.

Accepted Answer

The answer of ____________________ functions allow you to take a...

Question 13

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 14

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

Question 15

A(n)____________________ view is a view that can be used to update attributes in the base table(s)that are used in the view.

Accepted Answer

The answer of A(n)____________________ view is a view that can...

Question 16

The ____ data type is compatible with NUMBER.

Accepted Answer

A)  VARCHAR(15) 
B)  SMALLINT 
C)  DATE 
D)  CHAR(10) 
A)  VARCHAR(15) 
B)  SMALLINT 
C)  DATE 
D)  CHAR(10)

Question 17

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 18

The syntax for the UNION query is ____.

Accepted Answer

A)  query + query 
B)  UNION (query,query) 
C)  UNION: query query 
D)  query UNION query 
A)  query + query 
B)  UNION (query,query) 
C)  UNION: query query 
D)  query UNION query

Question 19

In an Oracle sequence,the ____________________ pseudo-column retrieves the current value of a sequence.

Accepted Answer

The answer of In an Oracle sequence,the ____________________ pseudo-column retrieves...

Question 20

When using the Oracle TO_NUMBER function to convert a character string into a number,____ represents a digit.

Accepted Answer

A)  0 
B)  9 
C)  $ 
D)  # 
A)  0 
B)  9 
C)  $ 
D)  #

An explicit cursor must return two or more rows.

If the DBMS does not support the INTERSECT statement,you can use a(n)____________________ subquery to achieve the same result.

The ____________________ outer join returns not only the rows matching the join condition (that is,rows with matching values in the common column),but also the rows in the left-side table with unmatched values in the right-side table.

When using the Oracle TO_DATE function,the code ____ represents a three-letter month name.

"Union-compatible" means that the ____.

A(n)____________________ pools multiple transactions into a single batch to update a master table field in a single operation.

A(n)____________________ join returns all rows with matching values in the matching columns and eliminates duplicate columns.

In subquery terminology,the first query in the SQL statement is known as the ____ query.

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

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

The PL/SQL block starts with the ____ clause.

____________________ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.

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

A(n)____________________ view is a view that can be used to update attributes in the base table(s)that are used in the view.

The ____ data type is compatible with NUMBER.

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

The syntax for the UNION query is ____.

In an Oracle sequence,the ____________________ pseudo-column retrieves the current value of a sequence.

When using the Oracle TO_NUMBER function to convert a character string into a number,____ represents a digit.

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

An explicit cursor must return two or more rows.

If the DBMS does not support the INTERSECT statement,you can use a(n)____________________ subquery to achieve the same result.

The ____________________ outer join returns not only the rows matching the join condition (that is,rows with matching values in the common column),but also the rows in the left-side table with unmatched values in the right-side table.

When using the Oracle TO_DATE function,the code ____ represents a three-letter month name.

"Union-compatible" means that the ____.

A(n)____________________ pools multiple transactions into a single batch to update a master table field in a single operation.

A(n)____________________ join returns all rows with matching values in the matching columns and eliminates duplicate columns.

In subquery terminology,the first query in the SQL statement is known as the ____ query.

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

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

The PL/SQL block starts with the ____ clause.

____________________ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.

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

A(n)____________________ view is a view that can be used to update attributes in the base table(s)that are used in the view.

The ____ data type is compatible with NUMBER.

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

The syntax for the UNION query is ____.

In an Oracle sequence,the ____________________ pseudo-column retrieves the current value of a sequence.

When using the Oracle TO_NUMBER function to convert a character string into a number,____ represents a digit.

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