Online Access Free 1Z0-052 Practice Test

In a new installation of Oracle Database 11g, you perform these activities:
1 . Organize software and data on different subdirectories to avoid poor performance.
2 . Use consistent naming conventions for database files.
3 . Separate administrative information pertaining to the database in different directories.
Which option corresponds to the type of activities you performed?

• A.Oracle Grid Architecture
• B.Optimal Flexible Architecture
• C.Oracle Managed Files
• D.Oracle database architecture
• E.Automatic Storage Management

You want to use the ALTER SYSTEM statement with SCOPE=MEMORY to change an initialization parameter value.
Which is true?

• A.It can be used only if an spfile is used
• B.The change occurs immediately in memory for static parameters but it is not persistent after instance restart
• C.The change occurs immediately in memory for dynamic parameters but it is not persistent after instance restart
• D.It can be used only if a pfile is used

Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What affect would this command have on the database?

• A.The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten
• B.The extents in the undo tablespace retain data until the next full database backup
• C.The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes
• D.The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down

Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

• A.The taking of AWR snapshots cannot be disabled
• B.It is the foundation for the self-managing infrastructure
• C.By default, AWR snapshots are taken every 60 minutes
• D.AWR data is stored in the SYSTEM tablespace
• E.Its collection level is determined by the value of the STATISTICS_LEVEL database parameter

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
On investigation, you find that a session opened by user JIM has a transaction that caused the deadlock.
Which two statements are true regarding the session of SCOTT in this scenario? (Choose two.)

• A.The session is rolled back after receiving the error and JIM can continue with his transaction.
• B.SCOTT has to reexecute the last command in the transaction after he commits the transaction.
• C.The session is terminated after receiving the error and JIM can continue with his transaction.
• D.SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.