MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What is TRUE regarding Independent Subquery?i) Equality operator can only be used if subquery returns only one row.ii) IN operator can be used if subquery returns multiple rows.iii) Equality operator can be used if subquery returns multiple rows.
A
BOTH ii) and iii)
B
BOTH i) and iii)
C
ALL i), ii) and iii)
D
BOTH i) and ii)
Explanation: 

Detailed explanation-1: -What is TRUE regarding Independent Subquery? A. Equality operator can only be used if subquery returns only one row.

Detailed explanation-2: -Which of the following is true about sub-queries? Answer: A. A subquery is a complete query nested in the SELECT, FROM, HAVING, or WHERE clause of another query. The subquery must be enclosed in parentheses and have a SELECT and a FROM clause, at a minimum.

Detailed explanation-3: -The SQL ANY Operator The ANY operator: returns a boolean value as a result. returns TRUE if ANY of the subquery values meet the condition.

Detailed explanation-4: -An INDEPENDENT SUBQUERY is a subquery that can be run on its own, without the main subquery. We will be using the Football Delphi database, which can be downloaded here. If you are not familiar with the database, now is a good time to review the different tables and columns in each table.

There is 1 question to complete.
Previous
Next