1z1-062試験無料問題集（380題）「Oracle Database 12c: Installation and Administration 認定」

出題：1

Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

A. Network auditing is available in the post-migrated database.

B. The ability of users to audit their own schema objects is not available in the post-migrated database.

C. Mandatory auditing of audit administrative actions is available in the post-migrated database.

D. Operating system audit trail is available in the post-migrated database.

正解：B,C 解答を投票する

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

出題：2

You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time? (Choose two.)

A. Increasing the priority of the job class to which the job belongs

B. Moving the job to an existing higher priority scheduler window with the same schedule and duration

C. Increasing the value of the JOB_QUEUE_PROCESSES parameter

D. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

E. Increasing the job's relative priority within the Job class to which it belongs

F. Increasing the priority of the scheduler window to which the job belongs

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

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

出題：3

Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged.
Which command must you execute before starting the recovery of this tablespace?

A. SWITCH DATAFILE ALL

B. STARTUP FORCE

C. ALTER TABLESPACE users OFFLINE

D. STARTUP FORCE NOMOUNT

正解：C 解答を投票する

出題：4

You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
' /mydir/rman_change_track.f';
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true? (Choose three.)

A. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

B. Block change tracking will always reduce I/O performed during cumulative incremental backups.

C. The change tracking file must always be backed up when you perform a full database backup.

D. More than one database block may be read by an incremental backup for a change made to a single block.

E. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

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

出題：5

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

A. Enabling resumable timeout for user sessions

B. Decreasing the value of the IDLE_TIME resource limit in the default profile

C. Implementing Database Resource Manager

D. Setting a metric threshold

正解：C 解答を投票する

出題：6

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)

A. backup pieces

B. trace file generated using BACKUP CONTROLFILE TO TRACE

C. copies of all parameter files

D. control file autobackups

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

出題：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. Undo data is written to flashback logs after 1200 seconds.

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

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

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

正解：D 解答を投票する

出題：8

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?

A. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.

B. It must be made up of the value in ORACLE_SID and HOSTNAME.

C. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

D. It must be made up of a database name and a domain name.

正解：D 解答を投票する

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

出題：9

To enable faster incremental backups, you enabled block change tracking for the database.
Which two statements are true about the block change tracking file? (Choose two.)

A. The change tracking file must be created after the first level 0 backup.

B. Multiple change tracking files can be created for a database.

C. RMAN does not support backup and recovery of the change tracking file.

D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

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

出題：10

A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following:
1. The user account must be locked after five unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
How would you accomplish this?

A. by granting a secure application role to the user

B. by using Oracle Label Security options

C. by assigning a profile to the user

D. by implementing Database Resource Manager

正解：C 解答を投票する

出題：11

You create a locally managed tablespace ORDERS_TBS with automatic segment management.
You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.
CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?

A. It minimizes row chaining during row insertion.

B. It allows only 80% of space to be occupied in all data blocks of this table.

C. It automatically coalesces free space of a data block when it reaches 20% of available space.

D. It minimizes row migration during existing row data updation.

正解：B 解答を投票する

出題：12

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

A. The ADDM runs after each AWR snapshot is collected automatically by MMON

B. The ADDM requires at least four AWR snapshots for analysis

C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

D. The ADDM calls other advisors if required, but does not provide recommendations about the advisors

E. The ADDM analysis provides only diagnostics information but does not provide recommendations

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

出題：13

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

A. The same port number is used for multiple Database Express configurations on the same host.

B. It can use the HTTP protocol.

C. It can use the HTTPS protocol.

D. It can be used to perform database backup operations.

E. It is available only when the database is open.

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

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