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

出題：1

You Execute the Following command to create a password file in the database server:
$ orapwd file = '+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12' Which two statements are true about the password file? (Choose two.)

A. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

B. It records the usernames and passwords of users when granted the DBA role.

C. It contains the usernames and passwords of users for whom auditing is enabled.

D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.

E. Is used by Oracle to authenticate users for remote database administration.

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

出題：2

You install Oracle Grid Infrastructure standalone server and issue the following command:
crsctl start has
Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.)

A. Oracle CSSD services

B. Oracle Net Listener

C. Oracle Notification services

D. the database whose instance is running

E. Oracle Healthcheck services

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

出題：3

Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups.
Which statement is true about the loss of a duplexed control file?

A. The database instance remains open and the control file can be restored without shutting down the database.

B. The database instance aborts and a control file restore operation does not require media recovery.

C. The database remains open but transactions are not permitted.

D. The database instance aborts, and media recovery is required after restoration of the control file to open the database.

正解：A 解答を投票する

出題：4

Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

A. It clears all user recycle bins in a database and releases their storage space.

B. It identifies any deprecated and unsupported parameters.

C. It writes a list of invalid SYS and SYSTEM object to the registry$sys_inv_objs table.

D. It evaluates the dependencies of network utility packages.

E. It generates fix-up scripts and automatically runs them to resolve issues that are flagged in the source database.

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

出題：5

Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose two.)

A. It frees unused temporary segments.

B. It frees resources held by abnormally terminated processes.

C. It registers database services with all local and remote listeners known to the database instance.

D. It records checkpoint information in the control file.

E. It kills sessions that exceed idle time.

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

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

出題：6

Which two statements are true about a server parameter file (SPFILE)? (Choose two.)

A. A PFILE can be used to start up a database instance even if an SPFILE exists.

B. An SPFILE must reside in the ORACLE_HOME/dbs directory.

C. An SPFILE can be created from a PFILE or from memory.

D. An SPFILE can be created only before a database instance is started.

E. An SPFILE contains only those dynamic parameters that can be changed without having to restart the database instance.

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

出題：7

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to tape drive fast enough.
What could be a solution to make streaming happen during the backup?

A. Configure backup optimization

B. Configure the channel to increase MAXOPENFILES

C. Configure the channel to increase the capacity with the RATE parameter

D. Configure the channel to adjust the tape buffer size with the BLKSIZE option

正解：D 解答を投票する

出題：8

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

A. Frequent thread checkpoints can degrade database performance.

B. It reduces the time required for recovery in case of an instance failure.

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

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

E. It ensures that all dirty buffers are written to data files during consistent shutdown.

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

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