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

Which statement is true about transportable tablespaces?

A. The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database's data file or files.

B. The cannot be dictionary-managed tablespaces

C. The source tablespace can be encrypted D. They can be administrative tablespaces such as SYSTEM or SYSAUX

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.

To which two components does the term "shape" refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

A. number of network interface cards (NICs)

B. number of database instances

C. number of CPUs

D. amount of RAM

E. number of storage LUNs

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

Which three tasks are performed automatically by Database Upgrade Assistant (DBUA) when the database to be upgraded is in archivelog mode and has the database flashback feature enabled? (Choose three.)

A. It changes Oracle kernel parameters if required

B. It creates a restore point to restore the database if the upgrade fails

C. It drops all the invalid objects

D. It calls the catctl.pl script to perform the upgrade process in parallel

E. It automatically resets the COMPATIBLE parameter value to 12.0.0

F. It modifies or creates new tablespaces as required

Which two statements are true about the In-Memory (IM) column store? (Choose two.)

A. It may be used for columns in Index Organized Tables (IOTs)

B. It may be used for columns in clustered tables

C. IM area size is not controlled by Oracle Automatic Memory Management

D. IM area size can be set at the CDB and PDB levels

E. IM area size can be increased or decreased dynamically

F. It is not used for partitioned tables

Which two operations is the opc user authorized to perform in an Oracle Database Cloud environment? (Choose two.)

A. Log in to the database deployment compute node.

B. Run some commands as root.

C. Run all commands as root.

D. Only run all commands as oracle.

E. Only run some commands as oracle.

Which two statements are true about FLEX ASM? (Choose two.)

A. A database instance on any node can connect to an ASM instance on any node.

B. A separate ASM network is required.

C. It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.

D. Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.

E. Database instances that depend on an ASM instance that is terminated connect to a surviving ASM instance.

In which four situations does the RMAN DUPLICATE command use the "pull" method? (Choose four.)

A. when the USING BACKUPSET clause is used

B. when the SET ENCRYPTION clause is added before the DUPLICATE command

C. when the SECTION SIZE clause is used

D. when the number of auxiliary channels allocated is less than the number of target channels allocated

E. when the USING COMPRESSED BACKUPSET clause is used

F. when no auxiliary channels are allocated

G. when IMAGE COPIES are used for the DUPLICATE operation