Question 1

MULTISET is similar to the table datatype.

Accepted Answer

A) True 
 B)False

Question 2

There is a special operation in SQL to join a table to itself.

Accepted Answer

A) True 
 B)False

Question 3

What is a self-join and how is it used?

Accepted Answer

A self-join is a join of one table to it

Question 4

The following code would include: 
SELECT Customer_T.CustomerID, Order_T.CustomerID,
CustomerName, OrderID
FROM Customer_T, Order_T
WHERE Customer_T.CustomerID = Order_T. CustomerID;

Accepted Answer

A)  all rows of the Order_T Table regardless of matches with the Customer_T Table. 
B)  all rows of the Customer_T Table regardless of matches with the Order_T Table. 
C)  only rows that match both Customer_T and Order_T Tables. 
D)  only rows that don't match both Customer_T and Order_T Tables. 
A)  all rows of the Order_T Table regardless of matches with the Customer_T Table. 
B)  all rows of the Customer_T Table regardless of matches with the Order_T Table. 
C)  only rows that match both Customer_T and Order_T Tables. 
D)  only rows that don't match both Customer_T and Order_T Tables.

Question 5

________ differs from array because it can contain duplicates.

Accepted Answer

A)  BIGINT 
B)  XML 
C)  MULTISET 
D)  TABLE 
A)  BIGINT 
B)  XML 
C)  MULTISET 
D)  TABLE

Question 6

Correlated subqueries are less efficient than queries that do not use nesting.

Accepted Answer

A) True 
 B)False

Question 7

A ________ is a temporary table used in the FROM clause of an SQL query.

Accepted Answer

A)  correlated subquery 
B)  derived table 
C)  view table 
D)  trigger 
A)  correlated subquery 
B)  derived table 
C)  view table 
D)  trigger

Question 8

What results would the following SQL statement produce? select owner, table_name
From dba_tables
Where table_name = 'CUSTOMER';

Accepted Answer

A)  A listing of all customers in the customer table 
B)  A listing of the owner of the customer table 
C)  A listing of the owner of the customer table as well as customers 
D)  An error message 
A)  A listing of all customers in the customer table 
B)  A listing of the owner of the customer table 
C)  A listing of the owner of the customer table as well as customers 
D)  An error message

Question 9

Explicit commands to manage transactions are needed when:

Accepted Answer

A)  a transaction consists of just one SQL command. 
B)  multiple SQL commands must be run as part of a transaction. 
C)  autocommit is set to off. 
D)  DDL statements are prohibited. 
A)  a transaction consists of just one SQL command. 
B)  multiple SQL commands must be run as part of a transaction. 
C)  autocommit is set to off. 
D)  DDL statements are prohibited.

Question 10

The following code would include: 
SELECT Customer_T.CustomerID,CustomerName, OrderID
FROM Customer_T RIGHT OUTER JOIN Order_T ON
Customer_T.CustomerID = Order_T.CustomerID;

Accepted Answer

A)  all rows of the Order_T Table regardless of matches with the Customer_T Table. 
B)  all rows of the Customer_T Table regardless of matches with the Order_T Table. 
C)  only rows that match both Customer_T and Order_T Tables. 
D)  only rows that don't match both Customer_T and Order_T Tables. 
A)  all rows of the Order_T Table regardless of matches with the Customer_T Table. 
B)  all rows of the Customer_T Table regardless of matches with the Order_T Table. 
C)  only rows that match both Customer_T and Order_T Tables. 
D)  only rows that don't match both Customer_T and Order_T Tables.

Question 11

If the DBA wishes to describe all tables in the database, which data dictionary view should be accessed in Oracle?

Accepted Answer

A)  DBA_TAB_PRIVS 
B)  DBA_TAB_COMMENTS 
C)  DBA_TABLE_LABEL 
D)  DBA_TABLES 
A)  DBA_TAB_PRIVS 
B)  DBA_TAB_COMMENTS 
C)  DBA_TABLE_LABEL 
D)  DBA_TABLES

Question 12

The following code is an example of a: SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState,
CustomerPostalCode
FROM Customer_T
WHERE Customer_T.CustomerID =
(SELECT Order_T.CustomerID
FROM Order_T
WHERE OrderID = 1008);

Accepted Answer

A)  Correlated subquery. 
B)  Subquery. 
C)  JOIN. 
D)  FULL OUTER JOIN. 
A)  Correlated subquery. 
B)  Subquery. 
C)  JOIN. 
D)  FULL OUTER JOIN.

Question 13

Explain how to combine queries using the UNION clause.

Accepted Answer

The UNION clause is used to combine the

Question 14

The following queries produce the same results.
Select DISTINCT customer_name, customer_city
from customer, salesman
where customer.salesman_id = salesman.salesman_id
and salesman.lname = 'SMITH';
select customer_name, customer_city
from customer
where customer.salesman_id =
(select salesman_id
from salesman
where lname = 'SMITH');

Accepted Answer

A) True 
 B)False

Question 15

All of the following are part of the coding structure for triggers EXCEPT:

Accepted Answer

A)  event. 
B)  condition. 
C)  selection. 
D)  action. 
A)  event. 
B)  condition. 
C)  selection. 
D)  action.

Question 16

The advantages of SQL-invoked routines are flexibility, efficiency, shareability and applicability.

Accepted Answer

A) True 
 B)False

Question 17

RANK and DENSE-RANK are examples of:

Accepted Answer

A)  ceilings. 
B)  door functions. 
C)  window functions. 
D)  moving functions. 
A)  ceilings. 
B)  door functions. 
C)  window functions. 
D)  moving functions.

Question 18

A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n):

Accepted Answer

A)  equi-join. 
B)  natural join. 
C)  multivariate join. 
D)  inner join. 
A)  equi-join. 
B)  natural join. 
C)  multivariate join. 
D)  inner join.

Question 19

A subquery in which processing the inner query depends on data from the outer query is called a codependent query.

Accepted Answer

A) True 
 B)False

Question 20

In SQL, a(n) ________ subquery is a type of subquery in which processing the inner query depends on data from the outer query.

Accepted Answer

A)  correlated 
B)  paired 
C)  natural 
D)  inner 
A)  correlated 
B)  paired 
C)  natural 
D)  inner

MULTISET is similar to the table datatype.

There is a special operation in SQL to join a table to itself.

What is a self-join and how is it used?

The following code would include: SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID;

________ differs from array because it can contain duplicates.

Correlated subqueries are less efficient than queries that do not use nesting.

A ________ is a temporary table used in the FROM clause of an SQL query.

What results would the following SQL statement produce? select owner, table_name From dba_tables Where table_name = 'CUSTOMER';

Explicit commands to manage transactions are needed when:

The following code would include: SELECT Customer_T.CustomerID,CustomerName, OrderID FROM Customer_T RIGHT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID;

If the DBA wishes to describe all tables in the database, which data dictionary view should be accessed in Oracle?

The following code is an example of a: SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerID = (SELECT Order_T.CustomerID FROM Order_T WHERE OrderID = 1008);

Explain how to combine queries using the UNION clause.

All of the following are part of the coding structure for triggers EXCEPT:

The advantages of SQL-invoked routines are flexibility, efficiency, shareability and applicability.

RANK and DENSE-RANK are examples of:

A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n):

A subquery in which processing the inner query depends on data from the outer query is called a codependent query.

In SQL, a(n) ________ subquery is a type of subquery in which processing the inner query depends on data from the outer query.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 7: Advanced SQL

MULTISET is similar to the table datatype.

There is a special operation in SQL to join a table to itself.

What is a self-join and how is it used?

The following code would include: SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID;

________ differs from array because it can contain duplicates.

Correlated subqueries are less efficient than queries that do not use nesting.

A ________ is a temporary table used in the FROM clause of an SQL query.

What results would the following SQL statement produce? select owner, table_name From dba_tables Where table_name = 'CUSTOMER';

Explicit commands to manage transactions are needed when:

The following code would include: SELECT Customer_T.CustomerID,CustomerName, OrderID FROM Customer_T RIGHT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID;

If the DBA wishes to describe all tables in the database, which data dictionary view should be accessed in Oracle?

The following code is an example of a: SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerID = (SELECT Order_T.CustomerID FROM Order_T WHERE OrderID = 1008);

Explain how to combine queries using the UNION clause.

All of the following are part of the coding structure for triggers EXCEPT:

The advantages of SQL-invoked routines are flexibility, efficiency, shareability and applicability.

RANK and DENSE-RANK are examples of:

A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n):

A subquery in which processing the inner query depends on data from the outer query is called a codependent query.

In SQL, a(n) ________ subquery is a type of subquery in which processing the inner query depends on data from the outer query.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters