Question 1

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.E) A) and B)
F) A) and C)

Question 2

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.E) B) and C)
F) A) and D)

Question 3

Combining a table with itself results in a faster query.

Accepted Answer

A) True 
 B)False

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.E) A) and B)
F) B) and C)

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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)   unionE) A) and B)
F) C) and D)

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)   flexibility.
B)   efficiency.
C)   sharability.
D)   security.E) None of the above
F) A) and B)

Question 10

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 11

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

Accepted Answer

Several built-in functions were added in...

Question 12

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 13

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.E) A) and B)
F) None of the above

Question 14

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_INDEXESE) B) and D)
F) B) and C)

Question 15

What is the difference between a trigger and a routine?

Accepted Answer

A trigger, once written and compiled, si...

Question 16

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 17

MULTISET is similar to the table datatype.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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)   UNIONE) C) and D)
F) A) and B)

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 6: Advanced SQL

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

Correct AnswerverifiedShow Answer

Combining a table with itself results in a faster query.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

SQL-invoked routines can be:

Correct AnswerverifiedShow Answer

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;

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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);

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedSeveral built-in functions were added in...View AnswerShow Answer

A materialized view is/are:

Correct AnswerverifiedShow Answer

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);

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

MULTISET is similar to the table datatype.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is the difference between a trigger and a routine?

Correct AnswerverifiedA trigger, once written and compiled, si...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Several built-in functions were added in...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A trigger, once written and compiled, si...
View Answer

Correct Answer
verified

Correct Answer
verified