1Z0-072 Online Practice Questions and Answers

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

A. Incremental backups cannot be used to roll forward the database while performing it.

B. Uncommitted transactions will be rolled back after it completes.

C. It is possible only when the database is in MOUNT state.

D. The database must have FLASHBACK enabled in order to perform it.

E. Only RMAN backupsets can be used to restore a database as part of it.

Which two are true about undo tablespaces? (Choose two.)

A. They can be recovered only when an instance is in MOUNT state.

B. They are always owned by SYS.

C. They must have only one data file.

D. There can be multiple active undo tablespaces for a single instance database.

E. SYSDBA users can create objects in them.

Which two are true about the roles? (Choose two.)

A. All privileges and roles granted to a user are enabled by default when the user logs in.

B. The SET ROLE statement can be used once per session.

C. The SET ROLE statement enables as well as disables roles in a session.

D. A role must be disabled before it can be revoked from a user.

E. The ALTER USER statement must be used to set specific default roles for a user.

In your database, you want to create a tablespace of non-standard block size by using this command:

Which is a requirement for this command to succeed?

A. All other DB_nK_CACHE_SIZE parameters should be set to zero.

B. The DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA.

C. The value of the DB_CACHE_SIZE parameter should not be 16 KB.

D. The DB_16K_CACHE_SIZE parameter should be set to a value less than that of DB_CACHE_SIZE.

E. The DB_BLOCK_SIZE parameter must be set to a value greater than 16 KB.

Examine this extract from the show parameters command: How are SGA and PGA memory managed by an instance using these parameter settings?

A. SGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management.

B. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is managed by using Automated SQL Execution Memory Management.

C. SGA and PGA memory are managed by using Automatic Memory Management (AMM).

D. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed.

E. SGA and PGA memory are manually managed.

You want to use table compression suitable for OLTP that will:

1.

Compress rows for all DML statements on that table

2.

Minimize the overheads associated with compression.

Which compression option is best suited for this?

A. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

B. ROW STORE COMPRESS ADVANCED

C. COLUMN STORE COMPRESS FOR ARCHIVE LOW

D. ROW STORE COMPRESS BASIC

E. COLUMN STORE COMPRESS FOR QUERY LOW

Which is true about unexpired undo?

A. It is required when a transaction rolls back.

B. It may be used to support flashback queries.

C. It consists of undo only for uncommitted transactions.

D. It is always retained for the time specified in UNDO__RETENTION.

E. It is the first type of undo overwritten when trying to avoid out-of-space errors.

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.

Which two are true about instance recovery? (Choose two.)

A. It is guaranteed to complete within fast_start_mttr_target number of seconds.

B. Archived REDO log files are required to perform instance recovery.

C. The database opens after the roll forward phase of instance recovery.

D. It is performed when mounting a database.

E. Archived REDO log files are never required to perform instance recovery.

F. It occurs after a SHUTDOWN IMMEDIATE.