Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?

• A.Database replay
• B.SQL Tuning Advisor
• C.SQL Access Advisor
• D.SQL Performance Analyzer
• E.Automatic Workload Repository compare reports

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about initialization parameter files? (Choose two.)

• A.A PFILE must exist for an SPFILE to be created.
• B.A lost or damaged SPFILE can be re-created by using the parameter values listed in the alert log.
• C.On startup, by default a database instance always first searches for an SPFILE, and if it does not find any, searches for a PFIL
• D.The ALTER SYSTEM command cannotbe used to change the value of any parameter if a database instance has started using a PFILE.
• E.Both the SPFILE and PFILE must always reside on a file system accessible from the database host server.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about a job chain? (Choose three.)

• A.It can contain a nested chain of jobs.
• B.It can be used to implement dependency-based scheduling.
• C.It cannot invoke the same program or nested chain in multiple steps in the chain.
• D.It cannot have more than one dependency.
• E.It can be executed using event-based or time-based schedules.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A.By default, EM express is available for a database after database creation.
• B.You can use EM express to manage multiple databases running on the same server.
• C.You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D.You cannot start up or shut down a database Instance by using EM express.
• E.You can create and configure pluggable databases by using EM express.

Comment: *

Name: *

Email: *

Verification: *

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command? (Choose three.)

• A.The import operation must be performed by a user on the target database by a user with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user with the DATAPUMP_EXP_FULL_DATABASE role on the source database.
• B.All the user-defined tablespaces must be in read-only mode on the source database.
• C.The export dump file must be created before starting the import on the target database.
• D.The source and target database must be running on the same operating system (OS) with the same endianness.
• E.The impdp operation must be performed by the same user that performed the expdp operation.

Comment: *

Name: *

Email: *

Verification: *