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,


DOWNLOAD & READ Free Dumps For Oracle- 1z0-001



You are reading online questions and answers for Oracle Exam 1z0-001 (Introduction to Oracle SQL and PL/SQL ) 100% free... Please share this site which will help this community to grow...

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
Description
Update Date and Time 2015-11-12 11:51:05

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
Description
Update Date and Time 2015-11-12 11:52:32