1Z0-074 Online Practice Questions and Answers

Your CDB has a PDB, EMP_PDB.

You successfully execute these commands as the SYSTEM USER in CDB$ROOT:

Which two statements are true about C##USR1? (Choose two.)

A. It can connect to EMP_PDB and view the data only in tables created by common users.

B. It can connect to EMP_PDB but cannot view the data in any table in it.

C. It can connect only to the root.

D. It is a common user.

E. It is a local user.

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

Examine these parameters in a PFILE used to start database instance.

Which two statements are true after an instance restart is attempted and why? (Choose two.)

A. PGA_AGGREGATE_TARGET and SGA_TARGET remain 1G and 2G respectively.

B. PGA_AGGREGATE_TARGET and SGA_TARGET are set to zero for the instance.

C. The MEMORY_MAX_TARGET parameter is set to zero for the instance.

D. MEMORY_MAX_TARGET is automatically set to 4G for the instance.

E. The instance does not start because AMM is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET are set to nonzero values.

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

In TESTDB, U1 has SYSDBA privileges and the password Oracle_4U.

You recreate the password file:

$ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5

Examine the command and result:

$ sqlplus u1/Oracle_4U@testdb as sysdba

ERROR:

ORA-01017: invalid username/password; logon denied

What can you do to fix this error?

A. Recreate the password file with the password set to Oracle_4U.

B. Change the password of U1 to Oracle_123.

C. Set the REMOTE_LOGIN_PASSWORDFILE parameter value to NONE.

D. Regrant SYSDBA to U1.

E. Restart the database instance.

You plan to use Information Lifecycle Management (ILM) for the ORDERS table.

Which is true about Heat Map statistics when HEAT_MAP is ON?

A. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace.

B. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.

C. They are collected for all segments and are stored in the SYSAUX tablespace.

D. They are collected for all segments and are stored in the SYSTEM tablespace.

E. They are collected only for the ORDERS table if it has an associated ADO policy.

You create a refreshable copy PDB, PDB_COPY, from the PDB_ORG PDB by using the REFRESH

MODE EVERY 5 MINUTES clause.

What happens every five minutes?

A. An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes.

B. PDB_COPY is automatically closed provided there is no ongoing transaction in PDB_ORG and then reopened as read-only after the refresh is complete.

C. PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.

D. PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete.

E. An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.

Examine these statements:

Which statement is true?

A. Statements 2 and 3 will validate the conversion

B. Only statement 3 will validate the conversion

C. Only statement 1 will validate the conversion

D. Statement 1 will return an error

E. All the statements will validate the conversion

Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

A. It analyzes only those memory components of the database instance that are impacting performance.

B. It determines the segments on which waits are occurring when the database has a high number of buffer busy waits.

C. It analyzes the performance of the database instance based on the latest two AWR snapshots.

D. It determines SQL statements that are performing poorly.

E. It recommends implementing SQL profiles to generate better execution plans.

F. It analyzes only the components and waits that are impacting database performance.

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

A. subpartitions

B. clustered tables

C. materialized views

D. index-organized tables

E. heap tables

F. any SYS owned objects