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

質問 1

Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)

（A）It divides files into extents and allows an extent to span disks.

（B）It mounts databases and diskgroups to make ASM files available to database instances.

（C）It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.

（D）It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load.

（E）It automatically places each disk from an external redundancy diskgroup in its own failure group.

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

質問 2

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 解答を投票する

質問 3

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?

（A）The transaction in Scott's session is rolled back and the tablespace becomes readonly.

（B）The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.

（C）The command fails as a transaction is still pending.

（D）The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.

正解：A 解答を投票する

質問 4

You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c.
Which three tasks should be performed before a manual upgrade? (Choose three.)

（A）copying net configuration files to the new Oracle home

（B）running preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file

（C）running utlu121s.sql from the new Oracle home to display information about the required initialization parameters

（D）copying the initialization parameter file to the new Oracle home

（E）copying the password file to the new Oracle home

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

質問 5

Which three are activities performed by SMON? (Choose three.)

（A）applying online redo during instance recovery

（B）recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors

（C）performing database services registration with the default listener

（D）restarting a server or a dispatcher process that terminated abnormally

（E）cleaning up temporary segments that are no longer needed

（F）cleaning up the database buffer cache and freeing resources that a client process was using

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

質問 6

You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file? (Choose two.)

（A）It contains usernames and passwords of database users who are members of the OSDBA operating system group.

（B）It contains username and passwords of database users who are members of the OSOPER operating system group.

（C）It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

（D）It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

（E）It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

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

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

質問 7

You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?

（A）CKPT

（B）PMON

（C）RBAL

（D）CTWR

（E）SMON

（F）MMON

（G）DBWR

正解：D 解答を投票する

質問 8

Your database instance has Automatic Memory Management enabled and supports shared server connections.
Examine the following:
1. Parallel execution messages and control structures
2. Local variables for a process
3. Security and resource usage information
4. Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan
5. SQL execution work areas
Which option indicates what is allocated from the large pool in this instance?

（A）only 1

（B）1, 2, and 5

（C）1, 2, 3, and 5

（D）1, 2, and 4

正解：D 解答を投票する

質問 9

Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)

（A）The PDB must be unplugged.

（B）The PDB must be in mount state.

（C）The PDB must be open in read-only mode.

（D）The PDB data files are always removed from disk.

（E）A dropped PDB can never be plugged back into a multitenant container database (CDB).

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

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

質問 10

DEFERRED_SEGMENT_CREATION is TRUE in one of your databases.
You execute this command:

Which three statements are true immediately after this statement executes successfully?

（A）No database segment is created.

（B）A database object is created.

（C）No column definitions are stored in the data dictionary.

（D）No object definition is stored in the data dictionary.

（E）No table definition is stored in the data dictionary.

（F）The table and column definitions are stored in the data dictionary.

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

質問 11

You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed.
You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these schemas.
What must you run to achieve this?

（A）SQL Access Advisor with a SQL tuning set

（B）Automatic Database Diagnostic Monitor (ADDM) report

（C）SQL Access Advisor with a hypothetical workload

（D）SQL Performance Analyzer

（E）SQL Tuning Advisor

正解：C 解答を投票する

質問 12

Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

（A）recommending optimization of materialized views

（B）recommending restructuring of SQL statements that have suboptimal plans

（C）checking schema objects for missing and state statistics

（D）generating SQL profiles

（E）recommending creation of indexes based on SQL workload

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

質問 13

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?

（A）The database is created as a non-CDB and can never contain a PDB.

（B）The database is created as a non-CDB but can be plugged into an existing CDB.

（C）The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

（D）The database is created as a non-CDB and can never be plugged into a CDB.

（E）The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).

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

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

質問 14

Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database.
Which two tools or utilities would you use to achieve this? (Choose two.)

（A）Recovery Manager (RMAN) script invoked by using scheduler

（B）Oracle Enterprise Manager Database Express (EM Express)

（C）Database Configuration Assistant (DBCA)

（D）Oracle Enterprise Manager Cloud Control

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

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

弊社を連絡する

関連リンク

トップ試験