1Z0-074 Exam Questions

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

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 comm...

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.)

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 b...

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

You receive complaints about poor performance in an Oracle 12c database while long running queries execute. You must obtain statistics such as elapsed time, CPU time, number of rea...

In which situation can the optimizer choose a hash join?

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 ena...

Examine these commands executed in the cdb1 container database: Which statement is true about the c##USER1 account?

Which statement is true about policy expressions?

A CDB, CDB1, has a LOCATIONS application container. NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS. In CDB2, you create a remote clone, LOC_R, of the LOCATIONS appli...

U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace, TBS_CMP with default compression for query low. You execute commands: Which three...

The EMP_CDB1 and EMP_CDB2 CDBs are in ARCHIVELOG mode. Oracle Managed Files is enabled in both CDBs. EMP_CDB1 has a PDB, EMP_PDB1. In EMP_CDB2, you log in as the SYS user. You plan...

QUERY_REWRITE_INTEGRITY and QUERY_REWRITE_ENABLED are set to TRUSTED and TRUE respectively in an Oracle 12c Release 2 database. You create the SALES_EVAL real-time materialized vie...

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

You plan to use Information Lifecycle Management (ILM) for the ORDERS table. Which is true about Heat Map statistics when HEAT_MAP is ON?

HR.EMP.EMPLOYEE_ID is the primary key of the HR.EMP partitioned table, which contains 108 rows and HR executes this command: SQL> CREATE TABLE employees TABLESPACE users FOR EXCHAN...

In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?

You create and enable a unified audit policy on a database that has the default auditing configuration. What is true about the SELECT statement and why?

In a database on an Oracle Exadata Database machine, a DBA executes this command: SQL> exec DBMS_INMEMORY_ADMIN.ENABLE_FASTSTART ('fs_tbs'); What is the result?

In your CDB, DEPTCDB, local undo is enabled. You successfully execute this command: FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366; Which action must you perform next?

Your CDB is in ARCHIVELOG mode and has an application container with a container PDB. A backup exists for the CDB. When you connect to the container PDB and try to execute a query,...

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

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

In an Oracle 12c Release 2 database, USER1 has CREATE SESSION, CREATE PROCEDURE, and CREATE FUNCTION privileges. Examine these commands: SYS executes this command: SQL> SELECT add_...

You want to partition the SALES table on the CITY and SALE_DATE columns. Which three partitioning methods can you use? (Choose three.)

The COMPATIBLE parameter is set to 12.2.0.0.0. Which two statements are true about SQL identifier lengths? (Choose two.)

Which method can be used to migrate from an on-premises Oracle Database 11g to Oracle Database 12c in the cloud if the on-premises platform is big-endian?

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?

Which two are true about tables recovered by using the RMAN RECOVER TABLE command or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

Examine these statements: Which statement is true?

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

One of your databases supports an OLTP workload. If a better plan is discovered for a statement, then you want that plan to be used. Which two can cause better plans to be used for...

Which three statements are true about the deferred invalidation clause in DDL statements? (Choose three.)

Examine these steps to create a Transparent Sensitive Data Protection (TSDP) policy with unified auditing to protect sensitive data in certain table columns: Create a TSDP policy a...

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

You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code: The SCOTT user has the SELECT privilege on HR.EMP. Which statement is true about querie...

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

Which statement is true about the Automatic Diagnostic Repository (ADR)?

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

A multi-tenant container database (CDB) contains three PDBs. Which three are prerequisites for performing a cross-platform transport of any of the PDBs? (Choose three.)

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

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

You execute this command in your database: ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL; How does this affect the creation of tablespaces?

You plan to execute this command: Which statement is true and why?

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

Which three statements are true about sequences in a single instance Oracle database? (Choose three.)

Which two statements are true about the SET VERIFY ON command? (Choose two.)

Which two statements are true about the rules of precedence for operators? (Choose two.)

Examine this statement: What is returned upon execution?