Oracle 1Z0-060 問題集

質問 1：
Which three statements are true about Automatic Workload Repository (AWR)?
A. All AWR tables belong to the SYSTEM schema.
B. The snapshots collected by AWR are used by the self-tuning components in the database
C. The AWR data is stored in memory and in the database.
D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
E. AWR contains systemwide tracing and logging information.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two statements are true about Oracle Data Pump export and import operations?
A. You can detach from a Data Pump export job and reattach later.
B. Data pump import requires an import file to be in a directory owned by the oracle owner.
C. You can detach from a data pump import job and reattach later.
D. Data Pump always automatically uses the direct path method for loading and unloading all types of data.
E. Data Pump uses parallel execution server processes to implement parallel import.
正解：A,E

質問 3：
Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (`batch_job' ,
FORCED_TRACKING => `Y');
Which two statements are true?
A. Only DML and DDL statements will be monitored for the session.
B. All subsequent statements in the session will be treated as one database operation and will be monitored.
C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
D. Database operations will be monitored only when they consume a significant amount of resource.
E. Database operations for all sessions will be monitored.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three activities are supported by the Data Recovery Advisor?
A. Advising on block checksum failures
B. Advising on invalid block header field values
C. Advising on empty password files
D. Advising on inaccessible control files
E. Advising on inaccessible block change tracking files
正解：A,B,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:

What does this imply?
A. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
C. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
D. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Your database uses Automatic Memory Management, and has the large pool configured.
You issue the following command:
SQL> ALTER SYSTEM SET SHARED_SERVERS = 5;
Which statement is true about the shared server configuration?
A. It is enabled and the UGA is located in the large pool for connections that use the shared server configuration.
B. It is enabled only if at least five dispatchers are configured.
C. It is enabled and all the DBA and non-DBA sessions function in shared server mode.
D. It is enabled only if the SHARED_SERVER_SESSIONS parameter is configured.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?
A. Helps you to easily upgrade the database from a prior release.
B. Automatically registers the database with Oracle Restart.
C. Enables the Installation of Grid Infrastructure files on block or raw devices.
D. Effectively implements role separation
E. Enables you to take advantage of Oracle Managed Files.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema.
Examine the following steps:
1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (`SH',
`CUSTOMERS') FROM dual statement.
2. Execute the DBMS_STATS.SEED_COL_USAGE (null, `SH', 500) procedure.
3. Execute the required queries on the CUSTOMERS table.
4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (`SH', `CUSTOMERS')
FROM dual statement.
Identify the correct sequence of steps.
A. 4, 1, 3, 2
B. 2, 3, 4, 1
C. 3, 2, 4, 1
D. 3, 2, 1, 4
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges:

Which statement is true about the common user created by the command?
A. The user can connect only to the root database.
B. The user cannot connect to any database because the CREATE ANY SESSION privilege must be granted.
C. The user can connect to the root and all PDBs.
D. The user cannot connect any database because the CONTAINER clause is missing.
正解：C