Free Oracle 1Z0-045 Exam Dumps Questions & Answers

Identify four uses of the Oracle Scheduler. (Choose four.)

• A.  Enables you to periodically execute operating system script files located on the same server as the database.
• B.  Enables you to set idle time limits for a resource plan.
• C.  Enables you to create a job that makes use of saved programs and schedules.
• D.  Enables you to schedule job execution based on time.
• E.  Enables you to assign priorities to the consumer groups.
• F.  Enables you to execute jobs in a clustered environment.
• G.  Enables you to map a consumer group to an Oracle user.

You decide to activate the resumable space allocation feature for all your database users by enabling the feature in a logon trigger. This causes a statement that requires space beyond a user's quota _____.

• A.  to wait in a suspended state until the quota is increased or until the timeout value is reached
• B.  to fail because quota limits do not activate theresumable space allocation feature
• C.  to wait indefinitely for the quota to be increased, regardless of the timeout setting for other space allocation problems.
• D.  to invoke the default trigger that resets user quota, if there is free space in the relatedtablespace

What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?

• A.  It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.
• B.  It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1.
• C.  It is NOT possible to switch unless no active transaction exists in UNDO1.
• D.  It is possible to switch to UNDO2, but current active transactions will abort.

What are three benefits provided by the enhanced Unicode support? (Choose three.)

• A.  support for the AL24UTFFSS character set
• B.  richer support for more character sets, languages, and territories
• C.  support for fixed-width character encoding
• D.  Unicode support in the database character set

Which two statements regarding the Flashback Table feature are correct? (Choose two.)

• A.  Flashback Table operation does not shrink the segments.
• B.  Flashback Table operation acquires exclusive data manipulation language (DML) locks.
• C.  Flashback Table can be performed on system tables.
• D.  Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.