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 1615

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.    The results will be the same, but the display will be different.
 

Option B

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

Option C

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

 

Option D

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

Correct Answer A
Explanation


Question ID 1616

Click on the EXHIBIT button and examine the structure of the PRODUCT and PART tables. You issue this SQL statement:
SELECT pr.name
FROMpart pt, product pr
WHEREpt.product_id(+) = pr.id;
What is the result?

Option A

A.    A list of products is displayed for parts that have products assigned.
 

Option B

B.    A list of all product names is displayed.
 

Option C

C.    A list of all products is displayed for products with parts.
 

Option D

D.    An error is generated.
 

Correct Answer B
Explanation

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