Evaluate the following SQL statements: Exhibit: You issue the following command to create
a view that displays the IDs and last names of the sales staff in the organization. Exhibit:
Which two statements are true regarding the above view? (Choose two.)
A.
It allows you to delete details of the existing sales staff from the EMPLOYEES table
B.
It allows you to insert rows into the EMPLOYEES table
C.
It allows you to update job IDs of the existing sales staff to any other job ID in the
EMPLOYEES table
D.
It allows you to insert IDs, last names, and job IDs of the sales staff from the view if it is
used in multitable INSERT statements
Explanation:
why B is false?
why D: “if it is used in multitable INSERT statements”
Because ‘department_id’ is NOT NULL and the view doesn’t have it. So B is wrong
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!!!
Está é uma boa questão…