Online Access Free 1Z1-052 Exam Questions

USER1 grants SELECT, INSERT, and UPDATE privileges on USER1, EMP to USER2.
SYS executes this command:
SQL>REVOKE UPDATE ON user1.emp FROM user1;
What will be the outcome?

• A.It will succeed but neither USER1 nor USER2 will be able to perform SELECT, INSERT, or UPDATE on USER1.EMP
• B.It will succeed and neither USER1 nor USER2 will be able to perform INSERT or UPDATE on USER1.EMP, but both will be able to query USER1.EMP
• C.It will succeed and only USER1 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP
• D.It will fail because USER1 is the owner of USER1.EMP
• E.It will succeed and only USER2 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP

You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.
Which three statements are true about these backups? (Choose three.)

• A.The backups would be inconsistent.
• B.The backups would be possible only if the database is running in ARCHIVELOG mode.
• C.The backups would be consistent.
• D.The backups need to be restored and the database has to be recovered in case of a media failure.
• E.The backups would be possible only if the database is running in NOARCHIVELOG mode.

Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance?

• A.The sessions are able to perform only queries
• B.The sessions are not allowed to perform any operations till the listener is started
• C.The sessions are terminated and the active transactions are rolled back
• D.The sessions are not affected and continue to function normally

Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.
What would be your next step to improve performance?

• A.Run the memory Advisor for the PGA
• B.Run the memory Advisor for the SGA
• C.Run the SQL Access Advisor
• D.Run the memory advisor for the shared pool
• E.Run the memory advisor for the buffer cache

In which of the scenario will the DBA perform recovery? (Choose all that apply.)

• A.A tablespace is accidentally dropped
• B.A database user terminates the session abnormally
• C.The hard disk on which the data files is stored is corrupted
• D.One of the redo log members is corrupted
• E.The alert log file is corrupted