ABD seems to be correct.
A,B: TRUE
SELECT column1,
(SELECT MAX(column2) FROM table1) AS max_value,
(SELECT COUNT(*) FROM table2) AS row_count
FROM table3
WHERE column4 = (SELECT MIN(column4) FROM table4);
C: FALSE - column name is placed on the left side of the condition/operator, while subquery is placed on the right side of it.
D: TRUE
SELECT deptno, MIN(sal) FROM emp GROUP BY deptno HAVING MIN(sal) > ( SELECT MIN(sal) FROM emp WHERE deptno = 30);
E: FALSE, a subquery does not need to be surrounded by a condition or operator, see example for A+B answer
F: FALSE, single-row subquery can return no row without raising an error
SELECT ename, init, bdate FROM employees WHERE bdate > (SELECT bdate FROM employees WHERE empno = 99999);
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Rafafm
3 months agoRafafm
2 months, 3 weeks agoRafafm
4 months agoauwia
1 year, 6 months agoDarkseid1231
1 year, 6 months agonautil2
1 year, 7 months ago