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 1561

Which script would you use to query the data dictionary to view only the name of the primary key constraints by using a substitution parameter for the table name?

Option A

A.    ACCEPT table PROMPT 'Table to view primary key constraint: ' SELECT constraint_name
FROM user_constraints
WHERE table_name = UPPER('&table') AND constraint_type = 'PRIMARY';
 

Option B

B.    ACCEPT table PROMPT 'Table to view primary key constraint: ' SELECT constraint_name
FROM user_cons_columns
WHERE table_name = UPPER('&table') AND constraint_type = 'P';
 

Option C

C.    ACCEPT table PROMPT 'Table to view primary key constraint: ' SELECT constraint_name, constraint_type
FROM user_constraints
WHERE table_name = UPPER('&table');
 

Option D

D. ACCEPT table PROMPT 'Table to view primary key constraint: ' SELECT constraint_name
FROM user_constraints
WHERE table_name = UPPER('&table') AND constraint_type = 'P';
 

Correct Answer D
Explanation


Question ID 1562

The EMPLOYEE table contains these columns: ID NUMBER(9) PK
LAST_NAME VARCHAR2(25)NN
DEPT_ID NUMBER(9)
Evaluate this SQL script: DEFINE id_2 = 93004 SELECT *
FROMemployee
WHEREid = (&id_2)
/
Which change should you make to the script so that it will execute?
 

Option A

A.    Remove the ampersand.

 

Option B

B.    Use the ACCEPT command.
 

Option C

C.    Add single quotation marks.
 

Option D

D.    No change is needed

Correct Answer D
Explanation

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