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

質問 1

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to Issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

（A）Ensure that HR_PDB is open.

（B）Place the root container in ARHCHIVELOG mode.

（C）Take the user data tablespace offline.

（D）Place the root container in the nomount stage.

正解：B 解答を投票する

質問 2

You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

（A）Stack space

（B）Location of a part of the runtime area for SELECT statements

（C）User session data

（D）Location of the runtime area for DML and DDL Statements

（E）Private SQL area

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

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

質問 3

You plan to drop the column of a table that has Flashback Archiving enabled.
You want to ensure minimal service disruption.
How would you do this in your Oracle 12c Database?

（A）Drop the column using the ALTER TABLE statement.

（B）Disassociate the Flashback Archive using the
DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, set the column unused, and re-associate the Flashback Archive using the procedure.
DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA

（C）Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.

（D）Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.

（E）Disassociate the Flashback Archive using the
DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re- associate the Flashback Archive using the procedure.
DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA

正解：A 解答を投票する

質問 4

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.
On further investigation, you find that buffer busy waits is caused by contention on data blocks.
Which option would you consider first to decrease the wait event immediately?

（A）Decreasing PCTFREE

（B）Increasing the number of DBWNprocess

（C）Decreasing PCTUSED

（D）Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

（E）Using Automatic Segment Space Management (ASSM)

正解：E 解答を投票する

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

質問 5

You issue the following commands:

The directories '/u0l/app/oracle/oradata/orcl'and '/u0l/app/oracle/mydata' exist.
Which statement describes the outcome?

（A）Tablespace creation ignores the data file and temp file locations specified in the CREATE commands, and creates both the tablespaces in the DB_CREATE_FILE_DEST location.

（B）The AUGUST_SALES tablespace is created with its data file in the DB_CREATE_FILE_DEST location and the TEMP101 tablespace is created with its temp file in the '/u01/app/oracle/mydata' location.

（C）The two tablespaces are created with the data file and temp file in their respective locations as specified in the CREATE commands.

（D）The TEMP101 tablespace is created with its temp file in the DB_CREATE_FILE_DEST location and the tablespace is created with its data file in the '/u01/app/oracle/mydata/ AUGUST_SALES location.
mysales.dbf'

正解：C 解答を投票する

質問 6

You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = `*' SCOPE = SPFILE; Which is true about the result of this command?

（A）The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.

（B）The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.

（C）Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

（D）The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

正解：D 解答を投票する

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

質問 7

An application accesses a small lookup table frequently.
You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?

（A）Configure the RECYCLE bufferpool and alter the table with the corresponding storage clause.

（B）Configure Automata Shared Memory Management.

（C）Configure Automatic Memory Management-

（D）Increase the database buffer cache size.

（E）Configure the KEEP buffer pool and alter the table with the corresponding storage clause.

正解：E 解答を投票する

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

質問 8

Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (`SRV1');
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1
service.
3. An aggregated trace file is created for all the sessions that are
running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?

（A）3 and 4

（B）1

（C）2 and 4

（D）2 and 5

（E）3 and 5

正解：C 解答を投票する

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

質問 9

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

（A）All users except SYS

（B）All users except SCOTT

（C）All users except sys, system, and SCOTT

（D）All users except sys and SCOTT

正解：B 解答を投票する

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

質問 10

Examine the following parameters for a database instance:

Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

（A）STREAMS_POOL_SIZE

（B）JAVA_POOL_SIZE

（C）DB_16K_CACHE_SZIE

（D）DB_KEEP_CACHE_SIZE

（E）SORT_AREA_SIZE

（F）LOG_BUFFER

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

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

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

弊社を連絡する

関連リンク

トップ試験