Where can sub queries be used?

Where can sub queries be used? (Choose all that apply)

A.
field names in the SELECT statement

B.
the FROM clause in the SELECT statement

C.
the HAVING clause in the SELECT statement

D.
the GROUP BY clause in the SELECT statement

E.
the WHERE clause in only the SELECT statement

F.
the WHERE clause in SELECT as well as all DML statements

Show Hint

← Previous question

Next question →

Leave a Reply 11

Bartosz

In my opinion E is wrong.

Ayman

Dears,
i think the answer above is wrong, please check the V1 exam answer its totally different
http://www.aiotestking.com/oracle/where-can-sub-queries-be-used/

wuxun

Yes, I think it should be ABCF.

amon

In my opinion options B,C,F are correct

Odumba

Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, , >=, <=, IN, BETWEEN etc.

Ender

Something wrong here,
I think ABCF are correct. Also,
In V1 exam answers, Eric Says;
a subquery may be used are as follows:
■ In the SELECT list used for column projection
■ In the FROM clause
■ In the WHERE clause
■ In the HAVING clause
* Page 358 (SQL Fundamentals I Exam Guide)
(http://www.aiotestking.com/oracle/where-can-sub-queries-be-used/)

Malcolm

Cleared Oracle Database 11g 1Z0-051 exam last weekend!

Scored 90%! (The passing score is 60%)

There were 64 questions in my actual 1Z0-051 test.

Many questions on SQL statements (Examine, Evaluate…etc.), Manipulating Data (Insert, Update, Delete), Using DDL Statements to Create and Manage Tables.

Also, please pay close attention to questions on Reporting Aggregated Data Using the Group Functions, Using Subqueries to Solve Queries, Creating Schema Objects, a little difficult!

I mainly learned the PassLeader 1Z0-051 dumps (http://www.passleader.com/1z0-051.html) (303q VCE and PDF), all questions were from it, and many wrong answers have been corrected in it, the most valid 1Z0-051 dumps! DO RECOMMEND!!