Question 1

Constraints are a special case of triggers.

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

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 4

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 5

Subqueries can only be used in the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 SQL 
A)  GET SQL 
B)  EXEC SQL 
C)  RUN SQL 
D)  SQL SQL

Constraints are a special case of triggers.

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

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

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

Subqueries can only be used in the WHERE clause.

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

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

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

Constraints are a special case of triggers.

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

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

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

Subqueries can only be used in the WHERE clause.

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

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

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