Online Access Free 1Z0-045 Exam Questions

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; only current active transactions will continue to execute inside UNDO1.
• B.It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.
• 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.

Which task would you perform to convert little-endian CLOB data to the big endian format while transporting from a database created in an earlier version of Oracle to an Oracle 10g database?

• A.No action is required because Oracle RDBMS implicitly does the conversion in Oracle 10g database while accessing the data.
• B.Transport the data after changing the character set of the target database to bigendian.
• C.Use the CONVERT command of the RMAN utility.
• D.Transport the data after changing the character set to be anendian-independent format in the target database.
• E.Use the CHANGE command of the RMAN utility.

The _____ identifies and helps to resolve performance problems relating to the execution of SQL statements by recommending which indexes, materialized views, or materialized view logs to create, drop, or retain.

• A.Undo Advisor
• B.SQL Access Advisor
• C.SQL Tuning Advisor
• D.Memory Advisor
• E.Segment Advisor
• F.MTTR Advisor

Which three statements are true about the privileged connection options available in Oracle 10g? (Choose three.)

• A.The CONNECT INTERNAL is disallowed.
• B.The listener must be running to make a connection.
• C.The Server Manager tool is no longer supplied.
• D.The use of a remote password login file (orapwd) is unchanged.

View the Exhibit.
Which two statements regarding the result of the query shown in the Exhibit are correct? (Choose two.)

• A.The LAST_SCN value in the second row is NULL, which means that version of the row no longer exists because it was deleted.
• B.The LAST_SCN value in the first row is NULL, which means that version of the row still exists at SCN 6636300.
• C.The LAST_SCN value in the second row is NULL, which means that version of the row still exists at SCN 6636300.
• D.The LAST_SCN value in the third row is 6636280, which means that version of the row exists above SCN 6636280.