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 1483

How would you add a foreign key constraint on the dept_no column in the EMP table, referring to the id column in the DEPT table?

Option A

A.    Use the ALTER TABLE command with the ADD clause on the EMP table.
 

Option B

B.    Use the ALTER TABLE command with the MODIFY clause on the EMP table.
 

Option C

C.    Use the ALTER TABLE command with the ADD clause on the DEPT table.

 

Option D

D.    This task cannot be accomplished.

Correct Answer A
Explanation


Question ID 1484

Evaluate this SQL script:
CREATE ROLE manager;
CREATE ROLE clerk;
CREATE ROLE inventory;
CREATE USER scott IDENTIFIED BY tiger;
GRANT inventory TO clerk;
GRANT clerk TO manager;
GRANT inventory TO scott
/
How many roles will user SCOTT have access to?
 

Option A

A.    1
 

Option B

B.    2
 

Option C

C.    0

 

Option D

D.    3

Correct Answer A
Explanation

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