Long Test ITEP 204

Describe subquery.

i. It is a query inside another query is possible

ii. Subqueries can be found in different parts of SELECT statements, each with different distinction and requirements.

iii. Subqueries can be inserted into any clauses in the SELECT statement.

• a. i only
• b. ii, iii
• c. none of the above
• d. all of the above

The following are the main ways of classifying queries, except:

• a. A subquery that is part of a tablelist that specifies data source
• b. A subquery that is part of a condition that specifies criteria
• c. A subquery that is part of a columnlist that specifies a single calculated column
• d. A subquery that is part of a tablelist that specifies a single calculated column

Which of the following statements is false?

• a. Subqueries can only be dependent on the main query.
• b. Subqueries can be found in different parts of SELECT statements.
• c. Subqueries are queries that are contained within other queries.
• d. There is no definite template in implementing subquery.

Correlated subquery is a subquery that is related to the outer query while uncorrelated subquery is unrelated and independent of the outer query.

• a. True
• b. False

Which of the following are the characteristics of a subquery?

i. A subquery is a query (SELECT statement) inside another query.

ii. A subquery is normally expressed inside parentheses.

iii. The first query in the SQL statement is known as the outer query.

iv. The query inside the SQL statement is known as the inner query.

• a. i, iii, iv
• b. i,ii
• c. none of the above
• d. all of the above

Type of subquery where the subquery is related to the outer query.

• a. Having Subquery
• b. From Subquery
• c. Correlated Subquery
• d. Uncorrelated Subquery

Type of subquery where the subquery is unrelated and completely independent of the outer query.

• a. Having Subquery
• b. From Subquery
• c. Correlated Subquery
• d. Uncorrelated Subquery

Using the two tables given, what will be the output of the subquery that performs the following syntax, such as SELECT student_no,student_name FROM tbl_students WHERE (SELECT SUM(amt_pd) FROM tbl_fees WHERE tbl_students.student_no = tbl_fees.student_no) <= 12000;

• 
• 
• 
• 

Using the two tables given, What will be the output of the subquery that performs the following syntax, such as SELECT student_no,student_name FROM tbl_students WHERE (SELECT SUM(amt_pd) FROM tbl_fees WHERE tbl_students.student_no = tbl_fees.student_no) > 12000;

• 
• 
• 
• 

Using the two tables given, What will be the output of the subquery that performs the following syntax, such as SELECT student_no,student_name FROM tbl_students WHERE (SELECT MIN(amt_pd) FROM tbl_fees WHERE tbl_students.student_no = tbl_fees.student_no) < 5000;

• 
• 
• 
•