Read online free dumps for Oracle- 1z0-001

Here you can read online questions and answers for Oracle Exam 1z0-001 (Introduction to Oracle SQL and PL/SQL ) 100% free...

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

============================================================================