Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The following code is an example of a correlated subquery.
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) True 
 B)False

Question 3

SQL provides the ________ technique, which involves placing an inner query within the WHERE or HAVING clause of an outer query.

Accepted Answer

A)  grouping 
B)  joining 
C)  subquery 
D)  union 
A)  grouping 
B)  joining 
C)  subquery 
D)  union

Question 4

SQL-invoked routines can be:

Accepted Answer

A)  part of a DDL statement. 
B)  functions or procedures. 
C)  part of a DCL statement. 
D)  contained within a CREATE statement. 
A)  part of a DDL statement. 
B)  functions or procedures. 
C)  part of a DCL statement. 
D)  contained within a CREATE statement.

Question 5

All of the following are advantages of SQL-invoked routines EXCEPT:

Accepted Answer

A)  flexibility. 
B)  efficiency. 
C)  sharability. 
D)  security. 
A)  flexibility. 
B)  efficiency. 
C)  sharability. 
D)  security.

Question 6

The ________ DBA view shows information about all users of the database in Oracle.

Accepted Answer

A)  DBA_USERS 
B)  USERS 
C)  DBA_VIEWS 
D)  DBA_INDEXES 
A)  DBA_USERS 
B)  USERS 
C)  DBA_VIEWS 
D)  DBA_INDEXES

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A function has only input parameters but can return multiple values.

Accepted Answer

A) True 
 B)False

Question 9

What is the difference between a trigger and a routine?

Accepted Answer

A trigger, once written and compiled, si

Question 10

The ________ operator is used to combine the output from multiple queries into a single result table.

Accepted Answer

A)  INTERSECT 
B)  DIVIDE 
C)  COLLATE 
D)  UNION 
A)  INTERSECT 
B)  DIVIDE 
C)  COLLATE 
D)  UNION

Question 11

A materialized view is/are:

Accepted Answer

A)  a virtual table created dynamically on request by a user. 
B)  an in-line query. 
C)  copies or replica of data based on queries. 
D)  always an exact copy of the source table. 
A)  a virtual table created dynamically on request by a user. 
B)  an in-line query. 
C)  copies or replica of data based on queries. 
D)  always an exact copy of the source table.

Question 12

The following SQL statement is an example of a correlated subquery.
SELECT First_Name, Last_Name, Total_Sales
FROM Salesman s1
WHERE Total_Sales > all
(SELECT Total_Sales FROM Salesman s2
WHERE s1.Salesman_ID != s2.Salesman_ID);

Accepted Answer

A) True 
 B)False

Question 13

The UNION clause is used to combine the output from multiple queries into a single result table.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 16

MULTISET is similar to the table datatype.

Accepted Answer

A) True 
 B)False

Question 17

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:

Accepted Answer

A)  using the if-then-else construct. 
B)  using the immediate if statement. 
C)  using the CASE key word in a statement. 
D)  using a subquery. 
A)  using the if-then-else construct. 
B)  using the immediate if statement. 
C)  using the CASE key word in a statement. 
D)  using a subquery.

Question 18

In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier.

Accepted Answer

A) True 
 B)False

Question 19

Combining a table with itself results in a faster query.

Accepted Answer

A) True 
 B)False

Question 20

Discuss some of the SQL:2011 and SQL:2016 enhancements and extensions to SQL.

Accepted Answer

Several built-in functions were added in

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

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

SQL provides the ________ technique, which involves placing an inner query within the WHERE or HAVING clause of an outer query.

SQL-invoked routines can be:

All of the following are advantages of SQL-invoked routines EXCEPT:

The ________ DBA view shows information about all users of the database in Oracle.

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

A function has only input parameters but can return multiple values.

What is the difference between a trigger and a routine?

The ________ operator is used to combine the output from multiple queries into a single result table.

A materialized view is/are:

The following SQL statement is an example of a correlated subquery. SELECT First_Name, Last_Name, Total_Sales FROM Salesman s1 WHERE Total_Sales > all (SELECT Total_Sales FROM Salesman s2 WHERE s1.Salesman_ID != s2.Salesman_ID);

The UNION clause is used to combine the output from multiple queries into a single result table.

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

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;

MULTISET is similar to the table datatype.

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:

In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier.

Combining a table with itself results in a faster query.

Discuss some of the SQL:2011 and SQL:2016 enhancements and extensions to SQL.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 6: Advanced SQL

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

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

SQL provides the ________ technique, which involves placing an inner query within the WHERE or HAVING clause of an outer query.

SQL-invoked routines can be:

All of the following are advantages of SQL-invoked routines EXCEPT:

The ________ DBA view shows information about all users of the database in Oracle.

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

A function has only input parameters but can return multiple values.

What is the difference between a trigger and a routine?

The ________ operator is used to combine the output from multiple queries into a single result table.

A materialized view is/are:

The following SQL statement is an example of a correlated subquery. SELECT First_Name, Last_Name, Total_Sales FROM Salesman s1 WHERE Total_Sales > all (SELECT Total_Sales FROM Salesman s2 WHERE s1.Salesman_ID != s2.Salesman_ID);

The UNION clause is used to combine the output from multiple queries into a single result table.

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

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;

MULTISET is similar to the table datatype.

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:

In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier.

Combining a table with itself results in a faster query.

Discuss some of the SQL:2011 and SQL:2016 enhancements and extensions to SQL.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters