1Z0-062 Free Practice Test

Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

1. A. It terminates if the SYSTEM tablespace in the source database is not autoextensible.
2. B. It automatically makes necessary changes to Oracle environment variables.
3. C. It automatically enables unified auditing in the upgraded database.
4. D. It automatically adds new data files if there is not enough disk space to grow.

Correct Answer: D
References: https://docs.oracle.com/cd/E18283_01/server.112/e17222/upgrade.htm#insertedID5

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

1. A. Setting a metric threshold
2. B. Implementing Database Resource Manager
3. C. Enabling resumable timeout for user sessions
4. D. Decreasing the value of the IDLE_TIME resource limit in the default profile

Correct Answer: B

Examine the details of the uncompressed, non-partitioned heap table CITIES.
<>>> >

1. A. Ensure free space that is approximately equal to the space used by the table should be available.
2. B. Ensure there are no pending transactions on the table.
3. C. Enable row movement is enabled.
4. D. Disable all indexes on the tabl

Correct Answer: C

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? (Choose two.)

1. A. Database operations will be monitored only when they consume a significant amount of resource.
2. B. Database operations for all sessions will be monitored.
3. 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.
4. D. Only DML and DDL statements will be monitored for the session.
5. E. All subsequent statements in the session will be treated as one database operation and will be monitored.

Correct Answer: CE
C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
Note:
* The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function
starts a composite database operation in the current session.
/ (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable \'Y\'.
/ (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable \'N\'.

Which statement is true regarding the startup of a database instance?

1. A. The instance does not start up normally and requires manual media recovery after a shutdown using the ABORT option.
2. B. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.
3. C. There is no difference in the underlying mechanics of the startup whether the database is shut down by using the IMMEDIATE option or the ABORT option.
4. D. Media recovery is required when the database is shut down by using either the IMMEDIATE option or the ABORT option.
5. E. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.

Correct Answer: E
References:
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/start.htm