1Z0-074 Online Practice Questions and Answers

From which two failure scenarios can a database be restored and recovered with the REPAIR DATABASE command? (Choose two.)

A. loss of ARCHIVELOGS

B. loss of a redo log member

C. loss of a noncritical data file

D. loss of all copies of the control file

E. loss of a critical data file such as SYSTEM, SYSAUX or UNDO

F. loss of SPFILE

In your database, DEFERRED_SEGMENT_CREATION is set to TRUE. You successfully execute this command:

Which statement is true about the space allocated to the SALES_2016 table?

A. Two subpartitions are allocated to the q1_2016 partition when the first row is inserted into q1_2016.

B. A single subpartition is allocated to the q1_2016 partition when the first row is inserted into q1_2016.

C. Separate segments are allocated to the q1_2016 partition and each of its subpartitions when the first row is inserted into q1_2016.

D. A segment is allocated to the q1_2016 partition but not its subpartitions at table creation.

E. A single segment is allocated to the q1_2016 partition and its subpartitions at table creation.

Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)

A. ESTIMATE (SHORTP_POLICY = 192) estimates the space requirement based on the SHORTP_POLICY value of 192 minutes.

B. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160) estimates the space requirement based on current ADR diagnostics file space usage.

C. ESTIMATE (SIZEP_POLICY = 209715200) estimates only the long retention policy.

D. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760) provides estimates that users can use to set SIZEP_POLICY.

E. ESTIMATE (SIZEP_POLICY = 209715200) estimates the value of LONGP_POLICY.

You create a new application container, SALES_APP, with application PDBs, SALES1_PDB, and SALES2_PDB. You want to install the NEW_APP application in SALES1_PDB and SALES2_PDB by using:

Where should you execute these statements?

A. All the statements should be executed in the application root.

B. All the statements should be executed in the application seed.

C. All the statements should be executed in the SALES1_PDB and SALES2_PDB application containers.

D. BEGIN/END INSTALL statements should be executed in the application root and the SYNC statement in SALES1_PDB and SALES2_PDB.

E. BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root.

Identify a situation where performance profiles can be used for application containers.

A. to specify the total number of parallel execution servers available

B. to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out

C. to specify the maximum percentage of the parallel execution server pool that a particular application container can use

D. to enforce a limit on the number of I/OS issued per second

E. to enforce a limit on I/O throughput per second

You notice a large number of latch: cache buffers lru chain and latch: cache buffers chains wait events.

Which four might be reasons for these? (Choose four.)

A. The same small number of blocks are repeatedly accessed by different sessions simultaneously.

B. The buffer cache is undersized.

C. Cursors are closed explicitly after each execution.

D. A large number of connected user sessions are idle.

E. DBWR is not writing the dirty buffers fast enough.

F. Blocks are ageing out of the buffer cache frequently.

G. Too many sort operations are being performed.

USER1 is an OS user with the password oracle and is only a member of the oinstall group. In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.

Examine these commands executed by the DBA:

SQL> CREATE USER ops$user1 IDENTIFIED externally;

SQL> GRANT create session TO ops$user1;

How can USER1 be given the SYSRAC privilege?

A. Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.

B. Grant SYSRAC to user1.

C. Grant SYSRAC to ops$user1.

D. Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.

E. Grant SYSDBA to ops$user1

Identify two operations for which the bkup_api utility can be used. (Choose two.)

A. to define the retention period for backups

B. to define which system files are backed up

C. to define which database configuration files are backed up

D. to define the cycle period for backups

E. to define the frequency of automatic backups

The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH. For what purpose is this optimized?

A. for parallel query performance only

B. for query performance and space saving

C. for query performance and space saving with greater bias toward space saving

D. for query performance only

E. for space saving only

Which three types of database objects can have their columns stored in the In-Memory column store? (Choose three.)

A. heap tables with composite primary key constraints

B. heap tables with dependent materialized views

C. clustered tables with dependent materialized views

D. index-organized tables stored in system-defined tablespaces

E. sys-owned objects stored in sysaux-defined tablespaces