Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

• A.Tables or table partitions with a foreign key cannot be recovered.
• B.Tables or table partitions can be recovered only when the database is in mount state.
• C.Tables or table partitions from the system and sysaux tablespaces cannot be recovered.
• D.Tables or table partitions can be recovered by using an auxiliary instance only.
• E.Tables with not null constraints cannot be recovered.

Comment: *

Name: *

Email: *

Verification: *

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

• A.It recompiles all stored PL/SQL code by using utlrp.sql.
• B.It empties the RECYCLE BIN.
• C.It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
• D.It sets all user tablespaces to "read-only" before starting the upgrade.
• E.It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
• F.It increases tablespace size, if required, to meet upgrade requirements.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A.It is part of the DBMS_STATS package.
• B.It always analyzes all schemas in the database.
• C.It runs automatically every night by default.
• D.It can recommend changes to improve the statistics gathering process.
• E.It is part of the DBMS_ADVISOR package.
• F.It can be run only manually.

Comment: *

Name: *

Email: *

Verification: *

You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have different endian formats.
Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4. Copy the UNIVERSITY tablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

• A.1,2,3,4,5,6,7,8
• B.1,2,3,4,5,7,8
• C.1,2,4,6,7,8
• D.2,4,5,6,7
• E.1,2,4,5,7,8

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Oracle dataabse methodology? (Choose two.)

• A.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• B.Tuning activities should stop once the user is satisfied with performance.
• C.Tuning activities should stop once agreed service levels for performance have been met.
• D.The database instance memory should always be tuned before tuning any file systems.
• E.SQL statements should always be tuned before tuning any file systems.
• F.The alert log should be used to find the database and instance areas most in need of tuning.

Comment: *

Name: *

Email: *

Verification: *