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

出題：1

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

A. SQL profile recommendations

B. statistics recommendations

C. SQL statement restructure recommendations

D. creation of materialized views to improve query performance

正解：A 解答を投票する

出題：2

As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT's password is TIGER. The service mane "HQ" is used to connect to the remote HQ database.
Which command would you execute to create the database link?

A. CREATE DATABASE LINK HQ USING 'HQ';

B. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';

C. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';

D. CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING 'HQ';

正解：C 解答を投票する

出題：3

Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

A. Database Vault in ORACLE_HOME

B. Configure Label Security

C. Database Resident Connection Pooling

D. Nondefault blocksize tablespaces

E. Oracle Suggested Backup Strategy

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

出題：4

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true? (Choose two.)

A. The schema for the common user C # # A_ADMIN can be different in each container.

B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

C. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

D. The command will create a user in the root container only because the container clause is not used.

E. The command will, create a common user whose description is contained in the root and each PDB.

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

出題：5

You are administering a database and you receive a requirement to apply the following restrictions:
1. A connection must be terminated after four unsuccessful login attempts by user.
2. A user should not be able to create more than four simultaneous sessions.
3. User session must be terminated after 15 minutes of inactivity.
4. Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?

A. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.

B. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE

C. by granting a secure application role to the users

D. By creating and assigning a profile to the users and setting the
SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4

E. By implementing the database resource Manager plan and setting the
SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

正解：C 解答を投票する

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

出題：6

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.
Which two files are removed automatically if space is required in the FRA as per the retention policy?
(Choose two.)

A. flashback logs

B. user-managed backups of data files and control files

C. RMAN backups that are obsolete

D. Archived redo log files that have multiple copies in a different archive location

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

出題：7

Which three statements are true about automated maintenance tasks? (Choose three.)

A. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.

B. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.

C. A maintenance window is automatically extended until all the maintenance tasks defined are completed.

D. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.

E. They run at predefined time intervals that are intended to occur during a period of low system load.

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

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

出題：8

You have successfully taken a database backup by using the command:
RMAN> BACKUP AS BACKUPSET DATABASE;
Now you execute this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;
What is the outcome?

A. It first takes an incremental level 0 backup and then an incremental level 1 backup.

B. It takes an incremental level 0 backup of the database.

C. It takes a backup of blocks that have been formatted since the last full database backup.

D. It fails because an incremental level 0 backup does not exist.

E. It fails because an incremental level 1 backup always searches for an image copy as level 0 backup.

正解：A 解答を投票する

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

出題：9

Which four statements are true about database instance behavior? (Choose four.)

A. Redo log files can be renamed in MOUNT state

B. Datafiles can be renamed in MOUNT state

C. All dynamic performance views (v$ views) return data when queried from a session connected to an instance in NOMOUNT state

D. The consistency of redo logs and data files is checked when mounting the database

E. An SPFILE can be updated when connected to an idle instance

F. An idle instance is created when a STARTUP NOMOUNT is successful

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

出題：10

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 backups deleted are based on the backup retention policy.

B. The physical files related to the backup need to be manually deleted.

C. The backup sets marked as expired are deleted.

D. The physical files related to the backup are deleted automatically.

E. The information related to the backups is removed from the recovery catalog and the control file.

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

出題：11

A database instance is started by using an SPFILE. The database is configured in ARCHIVELOG mode and the control file autobackup is configured. Daily full database backups are performed by using RMAN.
You lost all control files due to media failure.
Given the steps to recover from the error in random order:
1. Shut down the instance, if it is not already down.
2. Restore the control file from autobackup to a new location.
3. Start the database instance to NOMOUNT state.
4. Recover the database to the point of failure of the control file.
5. Open the database with the RESETLOGS option.
6. Mount the database.
7. Update the SPFILE with the new location of the control file by using the ALTER SYSTEM command.
Identify the correct sequence of the required steps.

A. 1, 2, 6, 4, 5

B. 1, 3, 7, 2, 6, 4, 5

C. 1, 3, 2, 6, 7, 4, 5

D. 1, 6, 2, 4, 5

E. 1, 3, 2, 4, 5

正解：C 解答を投票する

出題：12

You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario? (Choose two.)

A. The database must be opened with the RESETLOGS option after the flashback is complete.

B. The database must be MOUNTED for the flashback to succeed.

C. The database must have multiplexed redo logs for the flashback to succeed.

D. The database must be opened in restricted mode for the flashback to succeed.

E. The database must use block change tracking for the flashback to succeed.

F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

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

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