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

質問 1

You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script? (Choose two.)

（A）The seed will be opened read-only.

（B）The seed will be in mount state.

（C）The seed will be opened read/write.

（D）The other PDBs will be in mount state.

（E）The other PDBs will be opened read-only.

（F）The PDBs will be opened read/write.

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

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

質問 2

Examine the following command:
CREATE TABLE (prod_id number(4),
Prod_name varchar2 (20),
Category_id number(30),
Quantity_on_hand number (3) INVISIBLE);
Which three statements are true about using an invisible column in the PRODUCTS table? (Choose three.)

（A）The invisible column cannot be made visible and can only be marked as unused.

（B）The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.

（C）Referential integrity constraint cannot be set on the invisible column.

（D）A primary key constraint can be added on the invisible column.

（E）The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.

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

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

質問 3

One of your databases runs in ARCHIVELOG mode.
Examine this command:

Now examine these steps executed from RMAN:
1) SHUTDOWN IMMEDIATE
2) STARTUP MOUNT
3) BACKUP DATABASE;
4) BACKUP ARCHIVELOG ALL;
5) ALTER DATABASE OPEN;
6) STARTUP
Identify the minimum required steps in the correct order needed to perform a whole consistent database backup.

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

（B）3, 4

（C）1, 6, 3, 4

（D）1, 2, 3, 5

（E）1, 6, 3

正解：D 解答を投票する

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

質問 4

Examine this command executed on a client that is remote from the database server.
SQL> CONNECT hr/hr@orcl
Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)

（A）A service name must be defined to the listener that matches the service name in the orcl TNS entry

（B）An orcl TNS entry must be defined in the server-side tnsnames.ora file

（C）An orcl TNS entry must be defined in the client-side and server-side tnsnames.ora files

（D）An orcl TNS entry must be defined in the client-side tnsnames.ora file

（E）The service name orcl must be defined to the listener

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

質問 5

Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? (Choose three.)

（A）Each multithreaded Oracle process has an SCMN thread.

（B）Thread creation must be routed through a dispatcher process

（C）The local listener may spawn a now process and have that new process create a thread

（D）Each Oracle process runs an SCMN thread.

（E）The local listener may pass the request to an existing process which in turn will create a thread.

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

質問 6

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

（A）Taking a new snapshot and comparing it with a preserved snapshot

（B）Compare Period ADDM report

（C）Active Session History (ASH) report

（D）AWR Compare Period report

正解：B 解答を投票する

質問 7

Examine the parameters for your database instance:

You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?

（A）Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.

（B）An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

（C）You can perform a Flashback Database operation only within the duration of 1200 seconds.

（D）Undo data is written to flashback logs after 1200 seconds.

正解：B 解答を投票する

質問 8

Which three statements are true about checkpointing? (Choose three.)

（A）It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file.

（B）It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.

（C）It ensures that all dirty buffers are written to data files during consistent shutdown.

（D）It reduces the time required for recovery in case of an instance failure.

（E）Frequent thread checkpoints can degrade database performance.

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

質問 9

You perform RMAN backups for your database and use a recovery catalog for managing the backups. To free space, you execute this command:
RMAN> DELETE OBSOLETE;
Which three statements are true is this scenario? (Choose three.)

（A）The physical files related to the backup need to be manually deleted.

（B）The physical files related to the backup are deleted automatically.

（C）The backup sets marked as expired are deleted.

（D）The information related to the backups is removed from the recovery catalog and the control file.

（E）The backups deleted are based on the backup retention policy.

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

質問 10

Your database has been running with a peak load for the past hour. You want to preserve the performance statistics collected during this period for comparison when you analyze the performance of the database later.
What must you do to achieve this?

（A）Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour.

（B）Generate Active Session History reports for the peak load period.

（C）Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository (AWR) snapshot retention period.

（D）Create a baseline on a pair of snapshots that span the peak load period.

正解：D 解答を投票する

質問 11

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

（A）Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.

（B）Take the USERDATA tablespace offline in ACCOUNTS_PDB.

（C）Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.

（D）Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.

正解：B 解答を投票する

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

質問 12

You want to create a database and you have the following:
- Oracle Grid Infrastructure is installed and configured.
- Oracle Database Vault is installed in ORACLE_HOME to be used for this database.
- Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server.
Examine the requirements:
1. configuring the database instance to support shared server mode
2. using Automatic Storage Management (ASM) for storing database files.
3. configuring a naming method to help a remote user connect to a database instance
4. configuring the Fast Recovery Area
5. configuring Database Vault
6. configuring Enterprise Manager (EM) Database Express
7. registering with EM Cloud Control
8. configuring remote log archive destinations
9. enabling daily incremental backups
10. configuring a nondefault block size for nondefault block size tablespaces Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

（A）1, 2, 4, 5, 6 and 7

（B）1, 2, 4, 5, 7, 8, 9 and 10

（C）1, 2, 3, 4, 6, 8, 9 and 10

（D）1, 2, 3, 8, 9 and 10

（E）1, 2, 4, 5, 6, 7 and 8

正解：C 解答を投票する

質問 13

You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes.
Which set of tablespace attributes can be specified for a tablespace that satisfies the requirements?

（A）EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT UNIFORM

（B）REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

（C）EXTENT MANAGEMENT LOCAL AUTOALLOCATE

（D）EXTENT MANAGEMENT LOCAL STORAGE (INITIAL 5M MAXSIZE 10M)

正解：C 解答を投票する

質問 14

You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of file arrival events from remote systems.
Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.)

（A）The initialization parameter REMOTE_OS_AUTHENT must be set to TRUE on your database.

（B）Database links to remote databases must be created.

（C）The local database must be set up to run remote external jobs.

（D）The remote system's scheduler agent must be registered with your database.

（E）The remote system must have a running Oracle Database instance and a scheduler agent installed.

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

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

質問 15

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

（A）The valid time columns employee_time_start and employee_time_end are automatically created.

（B）The valid time columns are visible by default when the table is described.

（C）The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

（D）Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

（E）The valid time columns are not populated by the Oracle Server automatically.

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

質問 16

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result? (Choose three.)

（A）Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

（B）Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.

（C）Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

（D）Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.

（E）Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.

（F）Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.

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

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

質問 17

Which three statements are true about using flashback database in a multitenant container database (CDB)?
(Choose three.)

（A）The root container can be flashed back without flashing back the pluggable databases (PDBs).

（B）The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

（C）A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

（D）Individual PDBs can be flashed back without flashing back the entire CDB.

（E）To enable flashback database, the CDB must be mounted.

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

質問 18

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:
1snrctl > STOP
What happens to the sessions that are presently connected to the database Instance?

（A）They are able to perform only queries.

（B）They are terminated and the active transactions are rolled back.

（C）They are not affected and continue to function normally.

（D）They are not allowed to perform any operations until the listener LISTENER is started.

正解：C 解答を投票する

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

質問 19

Examine the parameter settings in your local ORCL database:

Examine the parameter settings for the remote SALES database:

As the SYS user, you issue the following command on ORCL:
CREATE PUBLIC DATABASE LINK sales.us.example.com USING 'sales1';
The sales1 tnsnames entry points to the sales database instance.
Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

（A）Local database users who use this database link should have accounts and the required privileges in the remote database.

（B）Only the user creating the database link must have an account and the required privileges in the remote database.

（C）The GLOBAL_NAMES initialization parameter should be set to FALSE in the ORCL database.

（D）The REMOTE_OS_AUTHENT initialization parameter should be set to FALSE in the remote database.

（E）The SALES1 net service name should be known to both the local and remote databases.

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

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

弊社を連絡する

関連リンク

トップ試験