AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-001





Question ID 1479

The PLAYER table contains these columns:
ID NUMBER(9)
NAME VARCHAR(2)
MANAGER_ID NUMBER(9)
In this instance, managers are players and you need to display a list of players. Evaluate these two SQL statements:
SELECT p.name, m.name FROMplayer p, player m
WHEREm.id = p.manager_id;
SELECT p.name, m.name FROMplayer p, player m
WHEREm.manager_id = p.id;
How will the results differ?
 

Option A

A.    Statement 1 will not execute; statement 2 will.
 

Option B

B.    The results will be the same, but the display will be different.
 

Option C

C.    Statement 1 will execute; statement 2 will not.
 

Option D

D.    Statement 1 is self-join; statement 2 is not.
 

Correct Answer B
Explanation


Question ID 1480

Under which situation is it necessary to use an explicit cursor?

Option A

A.    when a SELECT statement in a PL/SQL block retrieves more than one row
 

Option B

B.    when an UPDATE statement in a PL/SQL block has to modify more than one row
 

Option C

C.    when a DELETE statement in a PL/SQL block deletes more than one row

 

Option D

D.    when any DML or SELECT statement is used in a PL/SQL block

Correct Answer A
Explanation

Send email to admin@getfreedumps for new dumps request!!!