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-007





Question ID 1744

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name
MARY.EMP DEPT LOC VU each time the view is referenced?
 

Option A

A.    Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.
 

Option B

B.    Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE PRIVATE SYNONYM EDL VU
FOR mary.EMP_DEPT_LOC_VU;
then he can prefix the columns with this synonym.
 

Option C

C.    Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE LOCAL SYNONYM EDL VU
FOR mary.EMP_DEPT_LOC_VU;
then he can prefix the columns with this synonym.
 

Option D

D.    Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL VU
ON mary(EMP_DEPT_LOC_VU);
then he can prefix the columns with this synonym.
 

Option E

E.    Scott cannot create a synonym because synonyms can be created only for tables.
 

Option F

F.    Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL VU
FOR mary.EMP_DEPT_LOC_VU;
then he can prefix the columns with this synonym.
 

Correct Answer F
Explanation


Question ID 1745

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?

Option A

A.    ALTER TABLE customers
MODIFY customer_name CONSTRAINT cust_ name_nn NOT NULL;

 

Option B

B.    ALTER TABLE customers
MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
 

Option C

C.    ALTER TABLE customers
MODIFY name CONSTRAINT cust_name_nn NOT NULL;
 

Option D

D.    ALTER TABLE customers
MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;

Correct Answer A
Explanation

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