Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e
JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40)
ORDER BY dept_name; The statement fails when executed. Which change fixes the error?
A.
remove the table alias prefix from the WHERE clause
B.
replace the condition ”d.department_id NOT IN (10,40)” in the WHERE clause with
”d.department_id <> 10 AND d.department_id <> 40”
C.
prefix the column in the ORDER BY clause with the table alias
D.
remove the table alias from the SELECT clause
E.
remove the ORDER BY clause
F.
prefix the column in the USING clause with the table alias
the answer must be A.
Because we can not qualify a column that is used in the USING clause.
for answer D if the columns that are not common for the two table it must be prefixed
user plz answers of my question if you know..actualy mein ny bhot sy question par coments kiye hain ..questin pochy hain but no one respnse me.
yes b is only the right answer.
sory A is the only right answer
it must be A
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!!
By the way, part of that 303q 1Z0-051 dumps are available here:
http://www.oraclebraindump.com/?s=1z0-051
(
p.s. More 1Z0-051 exam questions on Google Drive:
drive.google.com/open?id=0B-ob6L_QjGLpWXpBUEhyRnVXVlE
)
Good Luck!!!
A – tested