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 1605

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 all products is displayed for products with parts.
 

Option B

B.    An error is generated.

 

Option C

C.    A list of all product names is displayed.
 

Option D

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

Correct Answer C
Explanation


Question ID 1606

The structure of the DEPT table is as follows:
Name Null? Type
DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14)
LOC VARCHAR2(13)
Examine the declaration section:
 
DECLARE
TYPE dept_table_type IS TABLE OF dept%ROWTYPE INDEX BY BINARY_INTEGER;
dept_table dept_table_type;
You need to assign the LOC field in record 15, the value of 'Atlanta'. Which PL/SQL statement makes this assignment?
 

Option A

A.    dept_table.loc.15 := 'Atlanta';

 

Option B

B.    dept_table(15).loc := 'Atlanta';
 

Option C

C.    dept_table[15].loc := 'Atlanta';
 

Option D

D.    dept_table_type(15).loc := 'Atlanta';

Correct Answer B
Explanation

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