Oracle 1z0-062 실제 시험문제 및 답변

문제1
Which three activities are supported by the Data Recovery Advisor? (Choose three.)

A. Advising on invalid block header field values

B. Advising on inaccessible block change tracking files

C. Advising on inaccessible control files

D. Advising on empty password files

E. Advising on block checksum failures

정답: A,C,E

설명: (ExamPassdump 회원만 볼 수 있음)

문제2
Which action takes place when a file checkpoint occurs?

A. The checkpoint position is advanced in the checkpoint queue.

B. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.

C. The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.

D. The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.

정답: B

문제3
Which three statements are true about space usage alerts? (Choose three.)

A. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.

B. Database alerts can provide warnings about low space availability at both tablespace and segment levels.

C. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.

D. Alerts are issued only when the critical threshold for space available in a tablespace is breached.

E. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.

정답: C,D,E

설명: (ExamPassdump 회원만 볼 수 있음)

문제4
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

A. running the Pre-Upgrade Information Tool

B. copying the listener.ora file to the new ORACLE_HOME

C. shutting down the database instance that is being upgraded

D. executing the catctl.pl script to run the upgrade processes in parallel

정답: A

설명: (ExamPassdump 회원만 볼 수 있음)

문제5
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c? (Choose two.)

A. ALTER TABLE ADD PARTITION

B. ALTER TABLE MERGE PARTITION

C. ALTER TABLE MOVE PARTITION

D. ALTER TABLE TRUNCATE PARTITION

E. ALTER TABLE DROP PARTITION

F. ALTER TABLE SPLIT PARTITION

정답: D,E

설명: (ExamPassdump 회원만 볼 수 있음)

문제6
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?

A. Database replay

B. SQL Access Advisor

C. SQL Performance Analyzer

D. SQL Tuning Advisor

E. Automatic Workload Repository compare reports

정답: C

설명: (ExamPassdump 회원만 볼 수 있음)

문제7
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?

A. The installation is being performed by the root user.

B. The operating system group that is specified must have permission to write to the inventory directory.

C. The ORACLE_BASE base parameter is not set.

D. The operating system group that is specified should have the root user as its member.

정답: B

설명: (ExamPassdump 회원만 볼 수 있음)

문제8
You plan to install the Oracle Database 12c software on a new server. The database will use Automatic Storage Management (ASM) and Oracle Restart. Oracle Grid Infrastructure for a standalone server is already installed on the server.
You want to configure job role separation. You create the following operating system users and groups:
- The user oracle as the owner of the Oracle database installation
- The user grid as the owner of Oracle Grid Infrastructure
- The group oinstall as an Oracle Inventory group
- The group dba as the OSDBA group for Oracle database
- The group asmdba as the OSDBA group for Oracle ASM
- The group asmadmin as the administration privileges group for Oracle ASM
- The group asmoper as the group for Oracle ASM
Which two additional tasks should you perform with regard to the OS-level owners and groups? (Choose two.)

A. assigning asmadmin and asmoper as primary groups for the oracle user

B. creating OS groups associated with the OSBACKUPDBA, OSDGDBA, and OSKMDBA system privileges

C. assigning oinstall as the primary group for the oracle user

D. creating a separate central inventory group for the Oracle Database 12c installation

E. assigning asmdba as the secondary group for the oracle user

정답: B,C

문제9
Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity.
Which action generates recommendations to overcome the performance issues?

A. running the Memory Advisor for the SGA

B. running the Memory Advisor for the buffer cache

C. running the Memory Advisor for the PGA

D. running the Memory Advisor for the library cache

정답: D

최신Oracle Database 12c: Installation and Administration - 1z0-062무료샘플문제

자격증의 중요성:

ExamPassdump 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공: