Oracle 1z0-062 問題集

質問 1：
You have the following entry in the tnsnames.ors of your hq.us.example.com host machine:

You issue the following command at the command prompt:
Sqlplus HR/HR@ORCL
Which statement is true about the connection to the ORCL database instance?
A. The connection succeeds, provided the ORCL.us.example.com database service is registered with a listener, the listener is up, and the database is open.
B. The connection succeeds, provided the SERVICE_NAMES initialization parameter is set to ORCL.
C. The connection fails because the net service name does not have the suffix us.example.com.
D. The connection succeeds, provided the NAMES.DEFAULT_DOMAIN parameter is set to us.example.com in the sqlnet.ora file on the client side.
正解：A

質問 2：
You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12c.
Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.
After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.
How do you accomplish this?
A. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
C. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
D. Enable real-time database operation monitoring using the
DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the
DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?
A. SMON
B. CTWR
C. CKPT
D. MMON
E. DBWR
F. PMON
G. RBAL
正解：B

質問 4：
Which three statements are true about Oracle Data Pump? (Choose three.)
A. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
B. DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients.
C. A directory object must exist and a user performing an EXPDP or IMPDP operation must have read and write permission on that directory object.
D. Oracle Data Pump export and import operations can be performed to move data across different database releases.
E. Oracle Data Pump export operations invoked from the clients that are connected remotely by using a connection string, create Data Pump files on the client file system.
正解：B,C,D

質問 5：
Examine these statements:

Which three are true about the effects of executing these statements? (Choose three.)
A. User HR sessions will terminate after ten minutes of continuous inactivity.
B. The password complexity will not enforce on the HR account.
C. The HR account will be locked after three consecutive failed login attempts.
D. The HR account will get locked by Oracle after ten consecutive failed login attempts.
E. User HR is permitted to create more than three concurrent sessions.
F. Password complexity checking is enforced for user HR.
正解：B,C,E