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

質問 1

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?

（A）Flush the shared pool.

（B）Restart the database instance.

（C）Re-enable redaction policies that use FULL data redaction.

（D）Re-create redaction policies that use FULL data redaction.

（E）Re-connect the sessions that access objects with redaction policies defined on them.

正解：B 解答を投票する

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

質問 2

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform? (Choose two.)

（A）Sequential recompilation of any stored PL/SQL code

（B）Parallel compilation of only the stored PL/SQL code

（C）Parallel recompilation of Java code

（D）Sequential recompilation of Java code

（E）Sequential recompilation of only the stored PL/SQL code

（F）Parallel recompilation of any stored PL/SQL code

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

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

質問 3

Your database is open in read/write mode and multiple users are connected to the database instance.
You execute the following command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
What would be the effect on current sessions?

（A）They are not affected.

（B）They are terminated after completing the transaction.

（C）They are not terminated but may only issue queries.

（D）They are terminated immediately.

正解：A 解答を投票する

質問 4

You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.

（A）1, 5, 6, 4, 3, 2

（B）2, 1, 3, 4, 5, 6

（C）1, 3, 4, 5, 6, 7

（D）1, 4, 3, 5, 6, 7

（E）2, 1, 3, 4, 5, 6, 7

正解：D 解答を投票する

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

質問 5

Which statement is true about the loss of a data file belonging to the default undo tablespace?

（A）The database remains open for querying but no DML statements can be executed except by the users with SYSDBA privilege.

（B）The database instance aborts.

（C）The database is put in MOUNT state and requires recovery to be opened.

（D）The database remains open in read-only mode.

（E）All the noncommitted transactions are lost.

正解：A 解答を投票する

質問 6

Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

（A）It loads data more efficiently than conventional SQL*Loader

（B）No data file needs to be specified

（C）It loads data faster than conventional SQL*Loader

（D）It requires Enterprise Manager Express to be configured

（E）It can load data in parallel

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

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

質問 7

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 メンバーにのみ表示されます)

質問 8

Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

（A）It terminates if the SYSTEM tablespace in the source database is not autoextensible.

（B）It automatically makes necessary changes to Oracle environment variables.

（C）It automatically enables unified auditing in the upgraded database.

（D）It automatically adds new data files if there is not enough disk space to grow.

正解：D 解答を投票する

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

質問 9

Examine the memory-related parameters set in the SPFILE of an Oracle database:

Which statement is true?

（A）Memory is dynamically re-allocated between the SGA and PGA as needed.

（B）Only SGA components are sized automatically.

（C）The value of the MEMORY_TARGET parameter cannot be changed dynamically.

（D）The size of the PGA cannot grow automatically beyond 500 MB.

正解：A 解答を投票する

質問 10

Which three statements are true about Database Resource Manager? (Choose three.)

（A）A resource plan change can be automated by using the Oracle Scheduler.

（B）It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.

（C）It can be used to enable resumable timeout for user sessions.

（D）A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.

（E）It can be used to control the usage of the temp tablespace by consumer groups.

（F）It can be used to control the usage of the undo tablespace by consumer groups.

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

質問 11

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? (Choose three.)

（A）The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

（B）The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

（C）RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

（D）The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

（E）The ASM compatibility attribute controls the format of the disk group metadata.

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

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

質問 12

A database is open READ WRITE and the instance has multiple sessions some of which have active transactions.
You execute this command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
Which three are true about the active transactions? (Choose three.)

（A）They are terminated immediately

（B）They may issue COMMIT OR ROLLBACK statements

（C）They may continue to issue queries

（D）They are suspended and unable to issue any statements

（E）They may continue to issue DML statements

（F）They are rolled back automatically

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

質問 13

Examine these two statements:

Which three are true about the MRKT tablespace? (Choose three.)

（A）The MRKT tablespace may be dropped if it has no contents.

（B）The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

（C）Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

（D）No more data files can be added to the tablespace.

（E）The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

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

質問 14

You want to load data from a large file into your database without causing an overhead on the SGA.
Which tool would you use.

（A）SQL*Loader with a direct data path

（B）SQL*Loader with a conventional data path

（C）Enterprise Manager Database Express

（D）external table

（E）Oracle data Pump

正解：A 解答を投票する

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

質問 15

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
(Choose three.)

（A）The database to be migrated must be opened read-only.

（B）The DMU can report columns that are not represented in the converted characterset.

（C）The release of the database to be converted can be any release since 9.2.0.8.

（D）A DBA can check specific tables with the DMU

（E）The DMU can report columns that are too long in the converted characterset.

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

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

質問 16

One of your databases supports an OLTP workload.
The default UNDO tablespace is fixed size with:
1. RETENTION NOGUARANTEE
2. UNDO_RETENTION is 12 minutes
User SCOTT gets this error after a query on the SALES table has run for more than 15 minutes:
ORA-01555: snapshot too old
Which three factors taken separately or in some combination might be the cause? (Choose three.)

（A）A committed update to the SALES table was made more than 12 minutes before the query began

（B）An update was made to the SALES table after the query began

（C）An uncommitted delete to the SALES table was made more than 12 minutes before the query began

（D）A committed delete to the SALES table was made more than 12 minutes before the query began

（E）An update to the SALES table was committed after the query began

（F）An update was made to the SALES table before the query began

（G）An uncommitted update to the SALES table was made more than 12 minutes before the query began

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

質問 17

Examine this command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true? (Choose two.)

（A）The Alert Log still contains some DDL statements

（B）All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home

（C）Some data definition language (DDL) statements are written to the control file

（D）Some DDL statements are written to an XML file in the ADR home

（E）All data definition language (DDL) statements are written to the control file

（F）Some DDL statements are written to a text file in the ADR home

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

質問 18

The following parameter are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps:

（A）1, 2, 3, 4, 5

（B）2, 1, 4, 3, 5

（C）2, 4, 5

（D）1, 2, 4, 5

正解：B 解答を投票する

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

質問 19

Which four actions are possible during an Online Data file Move operation? (Choose four.)

（A）Executing DML statements on objects stored in the data file being moved

（B）Performing file shrink of the data file being moved

（C）Flashing back the database

（D）Creating and dropping tables in the data file being moved

（E）Querying tables in the data file being moved

（F）Performing Block Media Recovery for a data block in the data file being moved

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

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

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

弊社を連絡する

関連リンク

トップ試験