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- 1z1-051





Question ID 4745

The ORDERS TABLE belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.
Which statement would create a synonym ORD so that HR can execute the following query successfully?
SELECT * FROM ord;
 

Option A

A.    CREATE SYNONYM ord FOR orders; This command is issued by OE
 

Option B

B.    CREATE PUBLIC SYNONY ord FOR oe.orders; This command is issued by the database administrator
 

Option C

C.    CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator
 

Option D

D.    CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE
 

Correct Answer B
Explanation


Question ID 4746

Which two statements are true regarding views? (Choose two.)
 

Option A

A.    A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated
 

Option B

B.    A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table
 

Option C

C.    A sub query that defines a view cannot include the GROUP BY clause
 

Option D

D.    A view is created with the sub query having the DISTINCT keyword can be updated
 

Correct Answer A,B
Explanation

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