1z1-074 by Oracle Valid Free Exam Practice Test

Question 1

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. 2, 1, 5, 3, 4 B. 2, 5, 1, 3, 4 C. 1, 2, 3, 4, 5 D. 1, 2, 4, 3, 5 E. 2, 1, 4, 5, 3

Correct Answer: B

Question 2

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

A. maximum number of DML operations performed by a consumer group B. UNDO quota for a consumer group C. sessions that are not blocking other sessions D. sessions that are blocking other sessions E. number of parallel queries issued by a consumer group

Correct Answer: B,D,E

Question 3

Examine these statements executed in the PROD1 database:

Which statements are audited?

A. only the changes to JOB_QUEUE_PROCESSES and the CREATE USER statement B. only the CREATE USER statement C. all the statements D. only the ALTER SYSTEM statements E. only the CREATE USER statement and the first change to JOB_QUEUE_PROCESSES

Correct Answer: A

Question 4

APP1 is an application container that has an application seed and two application PDBs, APP_PDB1 and APP_PDB2.
1.0 is the current version of the application.
You execute this block in the application root:

What is the outcome?

A. A common role is created in the application root, application seed, APP_PDB1, and APP_PDB2. B. An error is thrown because the CONTAINER=ALL clause is missing. C. An error is thrown because the c## prefix is missing in the role name. D. An error is thrown because the version number should be sequential, either 1.1 or 2.0. E. A common role is created only in the application root. F. A common role is created only in the application root and application seed.

Correct Answer: E

Question 5

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema.
BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker's right.
BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.
When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to update?

A. CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok B. CUST_RECORDS table in Bixby's schema C. CUST_RECORDS table in Murdok's schema D. CUST_RECORDS table in Rlayton's schema E. CUST_RECORDS table in the schema of Bixby and Rlayton

Correct Answer: D

Question 6

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. Any data in the In-Memory column store is copied in row major format to the FS_TBS tablespace. B. Any data in the In-Memory column store is copied in uncompressed columnar format to the FS_TBS tablespace. C. Any data in the In-Memory column store is copied in compressed columnar format to the FS_TBS tablespace. D. All columns for all tables in the FS_TBS tablespace are loaded into the In-Memory column store.

Correct Answer: D

Question 7

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 statements are true? (Choose three.)

A. T1 is in uncompressed format B. T1 is in the TBS_UNCMP tablespace C. All indexes on T1 remain valid D. The primary key constraints on T1 are dropped E. T1 is in compressed format F. T1 is in the TBS_CMP tablespace

Correct Answer: A,B,C

Question 8

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

A. It is not used for partitioned tables B. IM area size can be set at the CDB and PDB levels C. IM area size can be increased or decreased dynamically D. It may be used for columns in Index Organized Tables (IOTs) E. It may be used for columns in clustered tables F. IM area size is not controlled by Oracle Automatic Memory Management

Correct Answer: B,F

Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 - 1z1-074 Exam Practice Test