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 4737

Evaluate the following SQL statements:
DELETE FROM sales;
 
There are no other uncommitted transactions on the SALES table. Which statement is true about the DELETE statement?
 

Option A

A.    It removes all the rows in the table and deleted rows can be rolled back
 

Option B

B.    It removes all the rows as well as the structure of the table
 

Option C

C.    It would not remove the rows if the table has a primary key
 

Option D

D.    It removes all the rows in the table and deleted rows cannot be rolled back
 

Correct Answer A
Explanation


Question ID 4738

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 PUBLIC 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 orders; This command is issued by OE
 

Option D

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

Correct Answer B
Explanation

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