Online Access Free 1z1-062 Practice Test

Which three statements are true about Oracle Restart? (Choose three.)

• A.It can be configured to automatically restart a database in case of normal shutdown of the database instance.
• B.It runs periodic check operations to monitor the health of Oracle components.
• C.It can be used to only start Oracle components.
• D.While starting any components, it automatically attempts to start all dependencies first and in proper order.
• E.It can be configured to automatically attempt to restart various components after a hardware or software failure.

Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

• A.OMF automatically creates unique file names for table spaces and control files.
• B.The file system directions that are specified by OMF parameters are created automatically.
• C.OMF may affect the location of the redo log files and archived log files.
• D.OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
• E.OMF cannot be used in a database that already has data files created with user-specified directions.

Examine the parameters:

Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks.
Which two actions would you take to prevent this problem? (Choose two.)

• A.Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.
• B.Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.
• C.Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.
• D.Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.
• E.Set a limit in the proles of blocking users to control the number of data blocks that can be accessed in a session.

You want execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600.
Which two statements are true? (Choose two.)

• A.Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
• B.Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.
• C.Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
• D.A suspended statement will report an error if no corrective action has taken place during a timeout period.
• E.A resumable statement can be suspended and resumed only once during execution.

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true? (Choose two.)

• A.The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
• B.The command will, create a common user whose description is contained in the root and each PDB.
• C.The schema for the common user C # # A_ADMIN can be different in each container.
• D.The command will create a user in the root container only because the container clause is not used.
• E.Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.