1z1-074無料問題集「Oracle Upgrade Oracle DBA 11g or 12c to 12c R2」

質問 1

In an Oracle 12c Release 2 database, USER1 has CREATE SESSION, CREATE PROCEDURE, and CREATE FUNCTION privileges.
Examine these commands:

SYS executes this command:
SQL> SELECT add_num(1,2) FROM DUAL;
What is the result?

（A）Only "3" is displayed

（B）An error is returned

（C）TESTDBA is created with the SYSDBA privilege only

（D）TESTDBA is created will the SYSDBA privilege and the message "The result is 3" is displayed

（E）The message "The result is 3" only is displayed

正解：B 解答を投票する

質問 2

The ORCL CDB has a PDB, ORCL_PDB.
Examine these parameters in ORCL:

Examine these parameters in ORCL_PDB:

You switch to ORCL_PDB and plan to execute these commands:

What will be the outcome?

（A）Altering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB.SGA_TARGET size is changed to 600 M.

（B）SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDThe other values remain unchanged in both ORCL and ORCL_PD

（C）Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.

（D）SGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB.SGA_TARGET and SGA_MAX_SIZE are set to (1360-600)M and DB_CACHE_SIZE to
200M in ORCL.

（E）SGA_TARGET is set to 600M.The other values remain unchanged in both ORCL and ORCL_PDB.

正解：B 解答を投票する

質問 3

Which three statements are true about the deferred invalidation clause in DDL statements? (Choose three.)

（A）It always overrides the CURSOR_INVALIDATION setting.

（B）It cannot be used for creating a secondary index on index organized tables

（C）The CURSOR_INVALIDATION parameter always overrides the deferred invalidation clause.

（D）It defers invalidating dependent cursor when possible.

（E）It cannot be used for bitmap index creation.

正解：B、C、D 解答を投票する

質問 4

In which three situations would you recommend DB Replay to be used? (Choose three.)

（A）to check the impact of new optimizer statistics

（B）to check the impact of database migration to the cloud

（C）to check the impact of partitioning a table

（D）to check the impact of upgrading and patching databases

（E）to check the impact of schema changes such as adding new indexes or materialized views

（F）to check the impact of changing the storage system or the network

正解：B、D、F 解答を投票する

質問 5

Your CDB has a PDB, EMP_PDB.
You successfully execute these commands as the SYSTEM USER in CDB$ROOT:

Which two statements are true about C##USR1? (Choose two.)

（A）It is a common user.

（B）It can connect to EMP_PDB but cannot view the data in any table in it.

（C）It can connect to EMP_PDB and view the data only in tables created by common users.

（D）It can connect only to the root.

（E）It is a local user.

正解：A、D 解答を投票する

質問 6

Identify a situation where performance profiles can be used for application containers.

（A）to enforce a limit on I/O throughput per second

（B）to specify the maximum percentage of the parallel execution server pool that a particular application container can use

（C）to specify the total number of parallel execution servers available

（D）to enforce a limit on the number of I/OS issued per second

（E）to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out

正解：C 解答を投票する

質問 7

Which statement is true about Trace File Analyzer (TFA) Collector?

（A）If TFA is installed on any cluster node, it automatically collects diagnostic data on all other cluster nodes.

（B）In Oracle 12c Release 2, TFA installation can be done only while executing root.sh.

（C）It is used to collect diagnostic data only for ORA-600, ORA-7445, and ORA-4031 events.

（D）It can be used to collect diagnostic data for predefined events, and can be configured to automatically collect data for other events.

（E）TFA collects diagnostic data only for Oracle 12c Release 2 databases or later versions.

正解：B 解答を投票する

質問 8

Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)

（A）expdp scripts to export database objects belonging to the SYS schema

（B）RMAN database backup scripts

（C）pre- and post-upgrade fixup scripts

（D）a log file containing a list of pre-upgrade patches to be applied

（E）a log file with tool recommendations and requirements

正解：C、E 解答を投票する

1z1-074 無料問題集「Oracle Upgrade Oracle DBA 11g or 12c to 12c R2」

弊社を連絡する

関連リンク

トップ試験