1Z0-072 Online Practice Questions and Answers

The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.

UNDOTBS2 is the active undo tablespace.

Examine these commands:

USER1 executes DML, which generates more than 2 MB of UNDO.

What is the result and why?

A. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.

B. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.

C. It suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.

D. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.

E. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.

F. It returns an error because UNDOTBS2 is fixed size.

Which three are true about the Oracle Optimizer? (Choose three.)

A. It determines the optimal table join order and method.

B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

C. It can optimize only SELECT statements.

D. It will only generate SQL Plan Directives specific to a given SQL statement.

E. It can re-optimize execution plans after previous executions detect suboptimal plans.

F. It updates stale object statistics in the Data Dictionary.

Which two are true about Oracle database wait events that are described in V$EVENT_NAME? (Choose two.)

A. They reveal the cause of performance problems.

B. They are grouped into classes.

C. They are maintained at the session and system level.

D. They display how often a database instance performs particular operations.

E. All events might be used by an instance regardless of parameter settings.

Which two statements are true about VSTABLESPACE and DBA_ TABLESPACE?

A. VSTABLESPACE cab be queries by all users, but DBA_ TABLESPACEs cab be queries only by SYSDBA users.

B. VSTABLESPACE is a dynamic view that is populated with data from th DBA_ TABLESPACE dictionary view.

C. VSTABLESPACE is a dynamic view that is populated with data from the DBA_ TABLESPACES data queried only when a database is open.

D. VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.

E. VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.

Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value.

Which three actions could help in handling a large number of concurrent users?

A. using Automatic SGA Memory Management (ASMM)

B. setting the LARGE_POOL_SIZE parameter to a non-zero value

C. increasing the size of the PGA

D. setting the SHARED_POOL_SIZE parameter to a non-zero value

E. increasing the number of dispatchers

Which three statements are true about an spfile? (Choose three)

A. It contains only static initialization parameters.

B. It is the first file processed at instance startup.

C. It can be edited by SYS when the database instance is shut down.

D. It must exist for a database instance to start.

E. It can be used to create a pfile.

F. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.

Which three actions are required to manually upgrade a database to Oracle Database 12c Release 2? (Choose three.)

A. Run the Pre-Upgrade information tool on the source database.

B. Take all user tablespaces offline before starting the upgrade.

C. Copy the network configuration files from the existing database home to the new Oracle home location.

D. Run the Parallel Upgrade utility from the new Oracle home.

E. Run Oracle Net Configuration Assistant (NETCA) to configure the listening protocol address and service information for the new release of Oracle Database.

F. Make all user tablespaces "read only" before starting the upgrade.

G. Start the existing database in upgrade mode.

Which two are true about complete and incomplete recovery? (Choose two.)

A. Uncommitted transactions will be rolled back after complete recovery completes.

B. The database must have FLASHBACK enabled in order to perform incomplete recovery.

C. Uncommitted transactions will be rolled back after incomplete recovery completes.

D. Incomplete recovery is possible only when the database is open.

E. Only incremental backups can be used to roll forward the database while performing complete recovery.

Which two are true about RETENTION GUARANTEE? (Choose two.)

A. It is a tablespace attribute.

B. It prevents FLASHBACK DATABASE operation failure.

C. It prevents out-of-space errors.

D. It prevents "Snapshot too old" errors.

E. It is a static parameter.

In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2. The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1. USER1.EMP_IDX residing in TBS2 is an index on U1.EMP.ENAME. TBS1 is exported from ORCL by using this command:

The TESTDB database has a TBS1 tablespace but no TBS2. The SYSTEM user in TESTDB executes this command:

What is the result and why?

A. It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.

B. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.

C. It fails because TESTDB has TBS1.

D. It imports only EMP.

E. It fails because TESTDB does not have TBS2 to create EMP_IDX.