1z0-067試験無料問題集（265題）「Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP 認定」

出題：1

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

A. by creating a new database in the new host, and then using the RMAN recover command

B. by using the RMAN duplicate command with dbid and set newname for tablespace to recover the database to the new host

C. by using the RMAN duplicate command with no filename check to recover the database to the new host

D. by using the RMAN switch command to set the new location for the data files

正解：C 解答を投票する

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

出題：2

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

A. Tables or table partitions from the system and sysaux tablespaces cannot be recovered.

B. Tables with not null constraints cannot be recovered.

C. Tables or table partitions can be recovered only when the database is in mount state.

D. Tables or table partitions with a foreign key cannot be recovered.

E. Tables or table partitions can be recovered by using an auxiliary instance only.

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

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

出題：3

You want to move your existing recovery catalog to another database.
Examine the steps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the create catalog command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
5) Import the source recovery catalog schema by using the import catalog command.
6) Connect to the destination database.
7) Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.

A. 1, 2, 3, 6, 5

B. 1, 2, 6, 4

C. 2, 3, 7, 5

D. 1, 6, 4

正解：C 解答を投票する

出題：4

Examine the command to back up the ASM metadata:
ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup?

A. when the data file on an ASM disk group gets corrupted

B. when all the ASM disk groups for the ASM instance are lost

C. when one or more disks in an ASM disk group are lost

D. when one of the disks in a disk group is accidentally unplugged

E. when one or more file directory paths are accidentally deleted from an ASM disk group

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

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

出題：5

Your database is running in archive log mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?

A. Enable Fast Recovery Area.

B. Enable the recyclebin.

C. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.

D. Enable undo retention guarantee.

E. Enable minimal supplemental logging.

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

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

出題：6

In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.
Which statement is true about undo retention?

A. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency.

B. Inactive undo is retained for at least 1000 seconds if free undo space is available.

C. Inactive undo is retained for 1000 seconds even if new transactions fail due to lack of space in the undo tablespace.

D. Undo becomes expired obsolete after 1000 seconds.

正解：C 解答を投票する

出題：7

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

A. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause

B. to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog

C. to store backup information of multiple databases in one place

D. to automatically delete obsolete backups after a specified period of time

E. to restrict the amount of space that is used by backups

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

出題：8

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv
ORACLE*_SID = [oracle] ? cdb1
The oracle base for ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle
$ rman target /
Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013 Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.
Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?

A. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.

B. It fails and returns an error because a connection is not made by using the sysdba privilege.

C. It succeeds and displays all the tablespaces that belong to the root database.

D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

正解：A 解答を投票する

出題：9

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rc12c user.
The CATDB11 database contains an Oracle Database 11g catalog schema owned by the rc11 user.
A database with dbid=1423241 is registered in the catdb11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:
$rman
RKAN> CONNECT CATALOG rc12c/pass12c@catdb12c
RKAN> IMPORT CATALOG rc11/pwdcat11@catdb11 DBID=1423241;
What is the outcome of the import?

A. It fails because RMAN is not connected to the target database with DBID=1423241

B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.

C. It succeeds but the database is not automatically registered in the RC12C catalog.

D. It fails because the target database and recovery catalog database are of different versions.

正解：D 解答を投票する

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

出題：10

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.

B. The PDB does not close and starts by using the default temporary tablespace defined for the CDB.

C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

D. The PDB is closed and requires media recovery at the PDB level.

正解：C 解答を投票する

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

出題：11

You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceed during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation.
How would you achieve this?

A. Specify the maximum amount of quota a user can be allocated in the undo tablespace

B. Implement a Database Resource Manager plan

C. Implement a profile for these users

D. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions

正解：B 解答を投票する

出題：12

You want to create a database and you have the following:
Oracle Grid Infrastructure is installed and configured
Oracle Database Vault is installed in ORACLE_HOME to be used for this database Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server Examine the requirements:
Configuring the database instance to support shared server mode
Using Automatic Storage Management (ASM) for storing database files
Configuring a naming method to help a remote user connect to a database instance Configuring the Fast Recovery Area Configuring Database Vault Configuring Enterprise Manager (EM) Database Express Registering with EM Cloud Control Configuring remote log archive destinations Enabling daily incremental backups Configuring a nondefault block size for nondefault block size tablespaces Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

A. 1, 2, 4, 5, 7, 8, 9, and 10

B. 1, 2, 3, 8, 9, and 10

C. 1,2,3,4,5,6,8,9, and 10

D. 1,2, 4,5,6,7, and 8

E. 1, 2, 4, 5, 6, and 7

正解：E 解答を投票する

出題：13

Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the statistics level parameter?

A. It is set to all for all PDBs only in the SPFILE.

B. It is immediately set to all only for cd3Sroot.

C. It is immediately set to all in all PDBs where the statistics_level parameter is not set.

D. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.

E. It is immediately set to all in the SPFILE and the CDB instance.

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

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

出題：14

As part of a manual update process, you install Oracle Database 12c software, prepare a new ORACLE_HOME, you shut down an existing single-instance database that runs from that ORACLE_HOME.
What should you do next to start the upgrade of this database?

A. Start up the database instance by using the new location of the server parameter file and run the catupgrd.sql script from the new ORACLE_HOME to use parallel upgrade options that reduce down time.

B. Start up the database instance by using the STARTUP UPGRADE command by using the server parameter file.

C. Start up the database instance by using the new location of the server parameter file and run the catctl.pl script from the new ORACLE_HOME to use parallel upgrade options that reduce down time.

D. Start up the database instance by using the new location of the server parameter file and run the catuppst.sql script to generate informational messages and log files during the upgrade.

正解：C 解答を投票する

出題：15

You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation?
Choose two.

A. You must take the tools01.dbf data file offline.

B. You must have full or level-0 backups to restore blocks.

C. You must configure a block change tracking file.

D. You must ensure that the database is mounted or open.

E. You must use an incremental level-1 backup to restore blocks.

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

出題：16

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

A. The register database privilege should be granted to the virtual catalog owner.

B. The owner of VPC cannot own recovery catalog.

C. A base recovery catalog should exist.

D. At least one target database should be registered in the recovery catalog.

E. The DBA role should be granted to the virtual catalog owner.

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

出題：17

Which three statements are true about Oracle Restart?

A. It runs periodic check operations to monitor the health of Oracle components.

B. It can be configured to automatically attempt to restart various components after a hardware or software failure.

C. It can be used to only start Oracle components.

D. It can be configured to automatically restart a database in case of normal shutdown of the database instance.

E. While starting any components, it automatically attempts to start all dependencies first and in proper order.

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

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

出題：18

When is the UNDO_RETENTION parameter value ignored by a transaction?

A. when the undo tablespace is of a fixed size and retention guarantee is not enabled

B. when Flashback Database is enabled

C. when the data file of the undo tablespace is autoextensible

D. when there are multiple undotablespaces available in a database

正解：A 解答を投票する

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

出題：19

Your database is running in ARCHIVELOG mode. You backup your database regularly. If certain files are lost, an incomplete recovery is required.
In which two cases is this true?

A. flashback logs

B. current online redo log member

C. inactive online redo log

D. all control files

E. archived log files required to perform recovery

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

出題：20

Consider the following scenario for your database:
-Backup optimization is enabled in RMAN.
-The recovery window is set to seven days in RMAN.
-The most recent backup to disk for the tools tablespace was taken on March 1, 2015.
-The tools tablespace is read-only since March 2, 2015.
On March 15, 2015, you issue the RMAN command to back up the database via the Media Manager Interface.
Which statement is true about the backup of the tools tablespace?

A. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

B. The RMAN backup fails because the tools tablespace is read-only.

C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.

D. RMAN skips the backup of the tools tablespace because backup optimization is enabled.

正解：A 解答を投票する

1z0-067試験無料問題集「Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP 認定」