1Z0-060試験無料問題集（205題）「Oracle Upgrade to Oracle Database 12c 認定」

出題：1

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

A. The rows in the table are truncated without being archived.

B. It fails with the ORA-665610 Invalid DDL statement on history-tracked message

C. The rows in both the table and the archive are truncated.

D. The rows in the table are archived, and then truncated.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c?

A. Shut down the database instance.

B. Restart the database instance in UPGRADE mode.

C. Set the MAX_STRING_SIZE parameter to EXTENDED.

D. Restart the instance in normal mode.

E. Run the ut132k.sql script in $ORACLE_HOME/rdbms/admin.

F. Run the Database Migration Assistant.

G. Restart the database Instance in RESTRICTED mode.

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

解説: (GoShiken メンバーにのみ表示されます)

出題：3

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

A. Helps you to easily upgrade the database from a prior release.

B. Enables you to take advantage of Oracle Managed Files.

C. Effectively implements role separation

D. Enables the Installation of Grid Infrastructure files on block or raw devices.

E. Automatically registers the database with Oracle Restart.

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

解説: (GoShiken メンバーにのみ表示されます)

出題：4

You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor?

A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.

B. It may advise the use of segment shrink for free list managed tables.

C. It may advise the use of online table redefinition for tables in locally managed tablespaces

D. It will detect and advise about chained rows.

E. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

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

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Which three statements are true about tablespaces in a multitenant container database (CDB)?

A. All PDBs and CDBs have their own UNDO tablespaces.

B. There can be only one temporary tablespace group in a CDB.

C. All PDBs and CDBs have their own SYSTEM and SYSAUX tablespaces.

D. CDBs and PDBs may share the same temporary tablespace that is present in the root container.

E. Each pluggable database (PDB) can have a temporary tablespace or a tablespace group.

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

出題：6

What are three purposes of the RMAN "FROM" clause?

A. to support PUSH-based active database duplication

B. To support file recovery over the network in a Data Guard environment

C. To support PULL-based active database duplication

D. to support synchronization of a standby database with the primary database in a Data environment

E. To support file restores over the network in a Data Guard environment

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

解説: (GoShiken メンバーにのみ表示されます)

出題：7

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

A. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

B. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.

C. The shutdown proceeds immediately.
The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.

D. The statement results in an error because there are open PDBs.

正解：A 解答を投票する

出題：8

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?

A. Use Oracle Managed Files (OMF).

B. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

C. Specify the SEED FILE_NAME_CONVERT clause.

D. Specify the DB_FILE_NAMECONVERT initialization parameter.

E. Specify the PDB_FILE_NAME_CONVERT initialization parameter.

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

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Identify two correct statements about multitenant architectures.

A. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.

B. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.

C. Multiple CDBsshare certain PDB resources.

D. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.

E. A PDB can have a private undo tablespace.

F. Patches are always applied at the CDB level.

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

解説: (GoShiken メンバーにのみ表示されます)

出題：10

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

A. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

B. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

C. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

D. BACKUP SPFILE SECTION SIZE 1M;

E. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

F. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

G. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

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

1Z0-060試験無料問題集「Oracle Upgrade to Oracle Database 12c 認定」