Download Oracle.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 |
| Downloads: | 1 |
Demo Questions
Question 1
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
Question 2
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
Question 3
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
