1z0-062 試験問題を無料オンラインアクセス

You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.
What must you do first in this situation to attempt to fix this problem?

• A.Run utluiobj.sql to filter out objects that were invalidated by the upgrade process.
• B.Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view.
• C.Run preupgrd.sql and then execute the generated "fix-up" scripts to resolve status issues.
• D.Run catuppst.sql to perform revalidation actions

Which four statements are true about the components of the Oracle Scheduler? (Choose four.)

• A.A job is specified as part of a program specification.
• B.A job may get started automatically when a window opens.
• C.A program and job can be specified as part of a schedule definition.
• D.A program and schedule can be specified as part of a job definition.
• E.A schedule can be specified to a single job only.
• F.A scheduler job can point to a chain instead of pointing to a single program object.
• G.A program can be used in the definition of multiple jobs.

Examine the memory-related parameters set in the SPFILE of an Oracle database:

Which statement is true?

• A.Only SGA components are sized automatically.
• B.The size of the PGA cannot grow automatically beyond 500 MB.
• C.Memory is dynamically re-allocated between the SGA and PGA as needed.
• D.The value of the MEMORY_TARGET parameter cannot be changed dynamically.

You have the following entry in the tnsnames.ors of your hq.us.example.com host machine:

You issue the following command at the command prompt:
Sqlplus HR/HR@ORCL
Which statement is true about the connection to the ORCL database instance?

• A.The connection fails because the net service name does not have the suffix us.example.com.
• B.The connection succeeds, provided the ORCL.us.example.com database service is registered with a listener, the listener is up, and the database is open.
• C.The connection succeeds, provided the SERVICE_NAMES initialization parameter is set to ORCL.
• D.The connection succeeds, provided the NAMES.DEFAULT_DOMAIN parameter is set to us.example.com in the sqlnet.ora file on the client side.

Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database.
Which two tools or utilities would you use to achieve this? (Choose two.)

• A.Oracle Enterprise Manager Database Express (EM Express)
• B.Oracle Enterprise Manager Cloud Control
• C.Recovery Manager (RMAN) script invoked by using scheduler
• D.Database Configuration Assistant (DBCA)