1z1-074試験無料問題集（75題）「Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 認定」

出題：1

In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to
'/u01/app/oracle/oradata'.
CDB1 has an application container called REGIONS_APP.
There are no seeds for REGIONS_APP and there are no other application containers.
You plan to execute this command.
CREATE PLUGGABLE DATABASE AS SEED ADMIN USER seed_adm IDENTIFIED BY admin_123; What must you do for the command to execute successfully?

A. Add the CREATE_FILE_DEST clause to the command

B. Set the PDB_FILE_NAME_CONVERT parameter to '/u01/app/oracle/oradata'

C. Add the FILE_NAME_CONVERT clause to the command

D. Set the current container to REGIONS_APP

E. Set the current container to CDB1

正解：B 解答を投票する

出題：2

One of your databases supports an OLTP workload.
If a better plan is discovered for a statement, then you want that plan to be used.
Which two can cause better plans to be used for a statement? (Choose two.)

A. adaptive execution plans

B. SQL Performance Analyzer

C. using literals in SQL statements

D. adaptive cursor sharing

E. SQL Access Advisor

正解：A,E 解答を投票する

出題：3

From which two failure scenarios can a database be restored and recovered with the REPAIR DATABASE command? (Choose two.)

A. loss of all copies of the control file

B. loss of SPFILE

C. loss of a redo log member

D. loss of a critical data file such as SYSTEM, SYSAUX or UNDO

E. loss of a noncritical data file

F. loss of ARCHIVELOGS

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

出題：4

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

A. It always executes triggers that are fired recursively in FULLDML mode.

B. It recommends the use of SQL Tuning Advisor for regressed SQL statements.

C. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).

D. It generates execution plans for each SQL statement in an STS.

E. It recommends the creation of indexes for regressed SQL statements.

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

出題：5

In a database on an Oracle Exadata Database machine, a DBA executes this command:
SQL> exec DBMS_INMEMORY_ADMIN.ENABLE_FASTSTART ('fs_tbs');
What is the result?

A. Any data in the In-Memory column store is copied in uncompressed columnar format to the FS_TBS tablespace.

B. Any data in the In-Memory column store is copied in row major format to the FS_TBS tablespace.

C. All columns for all tables in the FS_TBS tablespace are loaded into the In-Memory column store.

D. Any data in the In-Memory column store is copied in compressed columnar format to the FS_TBS tablespace.

正解：C 解答を投票する

出題：6

In your database, DEFERRED_SEGMENT_CREATION is set to TRUE.
You successfully execute this command:

Which statement is true about the space allocated to the SALES_2016 table?

A. A single segment is allocated to the q1_2016 partition and its subpartitions at table creation.

B. Two subpartitions are allocated to the q1_2016 partition when the first row is inserted into q1_2016.

C. A single subpartition is allocated to the q1_2016 partition when the first row is inserted into q1_2016.

D. A segment is allocated to the q1_2016 partition but not its subpartitions at table creation.

E. Separate segments are allocated to the q1_2016 partition and each of its subpartitions when the first row is inserted into q1_2016.

正解：B 解答を投票する

出題：7

Examine these statements executed in the PROD1 database:

Which statements are audited?

A. only the CREATE USER statement

B. all the statements

C. only the CREATE USER statement and the first change to JOB_QUEUE_PROCESSES

D. only the changes to JOB_QUEUE_PROCESSES and the CREATE USER statement

E. only the ALTER SYSTEM statements

正解：D 解答を投票する

出題：8

In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?

A. oinstall

B. grid

C. opc

D. oracle

E. nobody

正解：C 解答を投票する

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