1z1-062無料問題集「Oracle Database 12c: Installation and Administration」

質問 1

Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)

（A）Backup retention policy

（B）Default backup device type

（C）Multiple backup device types for single backup

（D）Default section size for backups

（E）Default destinations for backups

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

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

質問 2

Which three statements are true about Oracle Restart? (Choose three.)

（A）It can be used to only start Oracle components.

（B）It runs periodic check operations to monitor the health of Oracle components.

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

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

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

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

質問 3

Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM).
How would you achieve this?

（A）by using Data Pump

（B）by using the Database Upgrade Assistant (DBUA)

（C）by using RMAN

（D）by using a transportable database

正解：C 解答を投票する

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

質問 4

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command? (Choose two.)

（A）It fails because no SQL *Loader control file location is specified.

（B）It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

（C）It fails because no SQL *Loader data file location is specified.

（D）It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

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

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

質問 5

To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message:
SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.

（A）The PGA_AGGREGATE_TARGET parameter is set to zero.

（B）The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

（C）Both the SGA_TARGET and MEMORY_TARGET parameters are set.

（D）The STATISTICS_LEVEL parameter is set to BASIC.

正解：D 解答を投票する

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

質問 6

Examine the parameter for your database instance:

You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

Identify the reason why the optimizer chose different execution plans.

（A）The optimizer chose different plan because extended statistics were created for the columns used.

（B）The optimizer used re-optimization cardinality feedback for the query.

（C）The optimizer used a dynamic plan for the query.

（D）The optimizer chose different plans because automatic dynamic sampling was enabled.

正解：C 解答を投票する

質問 7

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

（A）The DBMS_PDB package

（B）RMAN

（C）Transportable tablespace

（D）Transportable database

（E）Data Pump full export / import

正解：E 解答を投票する

質問 8

Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose two.)

（A）It kills sessions that exceed idle time.

（B）It records checkpoint information in the control file.

（C）It frees unused temporary segments.

（D）It registers database services with all local and remote listeners known to the database instance.

（E）It frees resources held by abnormally terminated processes.

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

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

質問 9

You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

（A）A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

（B）A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows

（C）A TOP-N query is created to limit the rows to 20 percent of the total rows

（D）All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

正解：A 解答を投票する

質問 10

Examine the parameters for a database instance:

Your database has three undo tablespaces and the default undo tablespace is not autoextensible.
Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

（A）Transactions wait until space becomes available in UNDOTBS1.

（B）Transactions write their undo in a temporary tablespace.

（C）Transactions fail.

（D）Transactions write their undo in the SYSTEM undo segment.

正解：C 解答を投票する

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

質問 11

Examine the details of the uncompressed, non-partitioned heap table CITIES.

Examine the command:
SQL> ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?

（A）Enable row movement is enabled.

（B）Ensure free space that is approximately equal to the space used by the table should be available.

（C）Ensure there are no pending transactions on the table.

（D）Disable all indexes on the table.

正解：A 解答を投票する

質問 12

You plan to upgrade your Oracle Database 9i to Oracle Database 12c.
Which two methods can you use? (Choose two.)

（A）Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

（B）Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.

（C）Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database
12c.

（D）Perform a rolling upgrade.

（E）Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.

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

質問 13

Examine the parameters for a database instance:

Which two statements are true? (Choose two.)

（A）No redo is generated for the undo records belonging to temporary tables.

（B）Undo records for temporary tables are stored in a temporary tablespace.

（C）Undo records for temporary tables are stored in the undo tablespace and logged in the redo.

（D）No redo and undo records are generated for temporary tables.

（E）Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.

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

質問 14

In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?
(Choose three.)

（A）when free space in a dictionary managed tablespace falls below a specified percentage

（B）when free space in a locally managed tablespace falls below a specified percentage

（C）when the total number of logons exceeds a specific value

（D）when the number of logons per second exceeds a specific value

（E）when the total number of locked user account exceeds a specific value

（F）when a resumable statement is suspended

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

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

1z1-062 無料問題集「Oracle Database 12c: Installation and Administration」

弊社を連絡する

関連リンク

トップ試験