Question 1

Figuring out what attributes you want in your query before you write the query will help with query writing.

Accepted Answer

A) True 
 B)False

Question 2

User-defined functions can improve system performance because they will be processed as sets rather than individually, thus reducing system overhead.

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

Question 4

It is better not to have a result set identified before writing GROUP BY and HAVING clauses for a query.

Accepted Answer

A) True 
 B)False

Question 5

Constraints are a special case of triggers.

Accepted Answer

A) True 
 B)False

Question 6

In order to embed SQL inside of another language, the ________ statement must be placed before the SQL in the host language.

Accepted Answer

A)   GET SQL
B)   EXEC SQL
C)   RUN SQL
D)   SQL SQLE) C) and D)
F) A) and C)

Question 7

Subqueries can only be used in the WHERE clause.

Accepted Answer

A) True 
 B)False

Exam 7: Advanced SQL

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

Correct Answer
verified

It is better not to have a result set identified before writing GROUP BY and HAVING clauses for a query.

Correct Answer
verified

Figuring out what attributes you want in your query before you write the query will help with query writing.

Correct Answer
verified

In order to embed SQL inside of another language, the ________ statement must be placed before the SQL in the host language.

Correct Answer
verified

Constraints are a special case of triggers.

Correct Answer
verified

Subqueries can only be used in the WHERE clause.

Correct Answer
verified

User-defined functions can improve system performance because they will be processed as sets rather than individually, thus reducing system overhead.

Correct Answer
verified

Exam 7: Advanced SQL

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

Correct AnswerverifiedShow Answer

It is better not to have a result set identified before writing GROUP BY and HAVING clauses for a query.

Correct AnswerverifiedShow Answer

Figuring out what attributes you want in your query before you write the query will help with query writing.

Correct AnswerverifiedShow Answer

In order to embed SQL inside of another language, the ________ statement must be placed before the SQL in the host language.

Correct AnswerverifiedShow Answer

Constraints are a special case of triggers.

Correct AnswerverifiedShow Answer

Subqueries can only be used in the WHERE clause.

Correct AnswerverifiedShow Answer

User-defined functions can improve system performance because they will be processed as sets rather than individually, thus reducing system overhead.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified