READ Free Dumps For Oracle- 1z1-051

Question ID 4888	DROP TABLE DEPT: Which four statements are true of the SQL statement? (Choose four)
Option A	A. You cannot roll back this statement.
Option B	B.    All pending transactions are committed.
Option C	C.    All views based on the DEPT table are deleted.
Option D	D.    All indexes based on the DEPT table are dropped.
Option E	E.    All data in the table is deleted, and the table structure is also deleted.
Option F	F.    All data in the table is deleted, but the structure of the table is retained.
Correct Answer	A,B,D,E

Explanation

Question ID 4889	You are granted the CREATE VIEW privilege. What does this allow you to do?
Option A	A.    Create a table view.
Option B	B.    Create a view in any schema.
Option C	C.    Create a view in your schema.
Option D	D.    Create a sequence view in any schema.
Option E	E.    Create a view that is accessible by everyone.
Option F	F.    Create a view only of it is based on tables that you created.
Correct Answer	C

Explanation

Previous-Page 1 2. . . 79 80 81 82 83 84 85. . . 127 128 Next-Page

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