1Z0-074 Online Practice Questions and Answers

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

Examine these statements executed in the PROD1 database: Which statements are audited?

A. only the CREATE USER statement

B. only the ALTER SYSTEM statements

C. only the CREATE USER statement and the first change to JOB_QUEUE_PROCESSES

D. only the changes to JOB_QUEUE_PROCESSES and the CREATE USER statement

E. all the statements

Which statement is true about policy expressions?

A. A named policy expression is stored in the Data Masking format library.

B. A named policy expression applied to a column in a redacted table overrides the default expression of its redaction policy.

C. A redacted table can have only one policy expression defined on it.

D. A policy expression can be applied to columns in different redacted tables.

E. A named policy expression is stored in the Enterprise Manager Database Express repository.

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?

A. All columns for all tables in the FS_TBS tablespace are loaded into the In-Memory column store.

B. Any data in the In-Memory column store is copied in compressed columnar format to the FS_TBS tablespace.

C. Any data in the In-Memory column store is copied in uncompressed columnar format to the FS_TBS tablespace.

D. Any data in the In-Memory column store is copied in row major format to the FS_TBS tablespace.

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?

A. Open HRPDB

B. Take a backup of DEPTCDB

C. Take a backup of HRPDB

D. Open HRPDB with RESETLOGS

E. Open DEPTCDB with RESETLOGS

F. Open DEPTPDB

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

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_num(1,2) FROM DUAL;

What is the result?

A. An error is returned

B. The message "The result is 3" only is displayed

C. TESTDBA is created with the SYSDBA privilege only

D. Only "3" is displayed

E. TESTDBA is created will the SYSDBA privilege and the message "The result is 3" is displayed

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 and define the audit parameter for the audited columns.

Create a TSDP sensitive type using DBMS_TSDP_MANAGE.ADD_SENSITIVE_TYPE.

Associate the TSDP policy with the sensitive type by using

DBMS_TSDP_PROTECT.ASSOCIATE_POLICY.

Enable the TSDP policy at the sensitive type level.

Associate the column to be audited to the sensitive type by using

DBMS_TSDP_MANAGE.ADD_SENSITIVE_COLUMN.

Identify the steps in the correct sequence.

A. 1, 2, 3, 4, 5

B. 2, 1, 4, 5, 3

C. 2, 5, 1, 3, 4

D. 1, 2, 4, 3, 5

E. 2, 1, 5, 3, 4

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

A. The CDB should be in MOUNT state.

B. The source and target platforms must have the same endianness.

C. The COMPATIBLE parameter must be set to 12.2 or greater in the CDB.

D. The source PDBs must be closed for a cross-platform PDB backup.

E. Flashback database must be enabled for the CDB.

F. The CDB must use Automatic Memory Management.

You execute this command in your database: ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;

How does this affect the creation of tablespaces?

A. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are not encrypted anywhere.

B. TEMP and UNDO tablespaces are transparently encrypted with AES128 by default only in the cloud.

C. TEMP and UNDO tablespaces are transparently encrypted with AES128 by default in an on-premise database.

D. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in an on- premise database.

E. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in the cloud.