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

質問 1

Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL>STARTUP
Which two statements are true about the successful execution of the command?

（A）All the PDBs are opened in read-write mode.

（B）All the PDBs are in closed state.

（C）All redo log files are opened.

（D）Only the root database is opened in read-write mode.

（E）The root, the seed, and all the PDBs are opened in read-write mode.

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

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

質問 2

Which two statements are true about making RMAN image copies of a database?
Choose two.

（A）They can be made only when the database is running in ARCHIVELOG mode.

（B）They can only be written to disk.

（C）They can be made only when the database is running in NOARCHIVELOG mode.

（D）They can be made only when the database is in MOUNT state.

（E）They consist of all used and unused blocks in the data files.

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

質問 3

Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/') PATH_PREFIX =
'/disk2/oracle/pdb2';
Which two statements are true?

（A）The pluggable database pdb2 is created by cloning pdb1 and is in mount state.

（B）All database objects belonging to common users in PD3I are cloned in PD32.

（C）Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.

（D）pdb2 is created with its own private undo and temp tablespaces.

（E）The tablespace specifications of pdb2 are the same as pdb1.

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

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

質問 4

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.
Examine the steps to recover this table from an RMAN backup:
1.Determine which backup contains the table that needs to be recovered.
2.Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified.
3.Import the Data Pump export dump file into the auxiliary instance.
4.Create a Data Pump export dump file that contains the recovered table on a target database.
Identify the required steps in the correct order.

（A）1, 4, 3

（B）1, 2

（C）1, 2, 4

（D）1, 4, 3, 2

正解：C 解答を投票する

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

質問 5

You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.

（A）Flashback Database must be enabled.

（B）A database backup must be taken.

（C）The recyclebin must be enabled for the database.

（D）The database must be running in archivelog mode.

（E）Fast Recovery Area must be enabled.

（F）Undo retention guarantee must be enabled.

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

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

質問 6

A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?

（A）Set the backup_tape_io_slaves parameter to true.

（B）Always use RMAN compression for tape backups rather than the compression provided by media manager.

（C）Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.

（D）Always use synchronous I/O for the database.

（E）Remove the rate parameter, if specified, in the allocate channel command.

（F）Configure large pool if not already done.

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

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

質問 7

You set the following parameters in the parameter file and restart the database instance:
MEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true?

（A）The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

（B）The memory_max_target parameter is automatically set to 500 MB.

（C）The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

（D）The pga_aggregate_target and sga_target parameters are automatically set to zero.

（E）The value of the memory_max_target parameter remains zero for the database instance.

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

質問 8

You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.
Which two statements are true? (Choose two.)

（A）You must take the tools01.dbf data file offline before you start a block media recovery.

（B）You must ensure that the SALES database is mounted or open.

（C）You must restore a backup control file to perform a block media recovery.

（D）You must put the database in NOARCHIVELOG mode to perform a block media recovery.

（E）You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.

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

質問 9

You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?

（A）capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system

（B）capturing the workload on the production system and replaying the workload for one PDB at a time on the test system

（C）capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

（D）capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

正解：D 解答を投票する

質問 10

Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?

（A）The compatible initialization parameter is set to 10.2 or higher.

（B）The default device for the backup must be set to disk.

（C）The tablespaces are locally managed.

（D）The fast recovery area is less than 50 percent free.

（E）There are no guaranteed restore points defined for the database.

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

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

質問 11

A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status Which two actions would you take to recover the temporary tablespace?

（A）Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.

（B）Drop the temp01.dbf file, and then re-create the temp file.

（C）Create a new temporary tablespace and assign it as the default to the user.

（D）Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.

（E）Add a new temp file to the temporary tablespace and drop the temp01.dbf file.

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

質問 12

Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.
Which three are prerequisites to fulfill this requirement?

（A）Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.

（B）The flashback any table privilege must be granted to the user.

（C）The select any transaction privilege must be granted to the user.

（D）The database must be running in archivelog mode.

（E）Minimal supplemental logging must be enabled.

（F）The recycle bin parameter must be set to on.

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

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

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

弊社を連絡する

関連リンク

トップ試験