Download Oracle Database 11g: Administration I.1z0-052.PracticeTest.2018-04-24.153q.tqb

Vendor:	Oracle
Exam Code:	1z0-052
Exam Name:	Oracle Database 11g: Administration I
Date:	Apr 24, 2018
File Size:	5 MB

Download Exam

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

Demo Questions

Examine the following steps performed on a database instance:

The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION
The SKD user creates a table
The SKD user grants the CREATE TABLE system privilege to the HR user
The HR user creates a table
The DBA revokes the CREATE TABLE system privilege from SKD

Which statement is true after step 5 is performed?

The table created by SKD is not accessible and SKD cannot create new tables
The tables created by SKD and HR remain, but both cannot create new tables
The table created by HR remains and HR still has the CREATE TABLE system privilege
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users

Correct answer: C

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:

SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;

Which two statements are true about the effect of the command? (Choose two.)

No flashback is possible to bring back the ITEM table.
The ORDERS table is dropped along with the ITEM table.
The dependent referential integrity constraints in the ORDERS table are disabled.
The dependent referential integrity constraints in the ORDERS table are removed.
The table definition of the ITEM table and associated indexes are placed in the recycle bin.

Correct answer: AD

View the Exhibit and examine the privileges granted to the SL_REP user.

The EMP table is owned by the SCOTT user. The SL_REP user executes the following command:

SQL> GRANT SELECT ON scott.emp TO hr;

Which statement describes the outcome of the command?

The command executes successfully.
The command produces an error because the EMP table is owned by SCOTT.
The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION.
The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table.

Correct answer: A

CONNECT US

HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset