Upgrade Oracle DBA 11g or 12c to 12c R2 (1z0-074) Free 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, 5, 1, 3, 4

B. 2, 1, 5, 3, 4

C. 1, 2, 3, 4, 5

D. 1, 2, 4, 3, 5

E. 2, 1, 4, 5, 3

Correct Answer: A

Question 2

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 all commands as root.

C. Only run some commands as oracle.

D. Run some commands as root.

E. Only run all commands as oracle.

Correct Answer: A,B

Question 3

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. sessions that are not blocking other sessions

C. sessions that are blocking other sessions

D. number of parallel queries issued by a consumer group

E. UNDO quota for a consumer group

Correct Answer: C,D,E

Question 4

In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to
'/u01/app/oracle/oradata'.
CDB1 has an application container called REGIONS_APP.
There are no seeds for REGIONS_APP and there are no other application containers.
You plan to execute this command.
CREATE PLUGGABLE DATABASE AS SEED ADMIN USER seed_adm IDENTIFIED BY admin_123; What must you do for the command to execute successfully?

A. Set the current container to CDB1

B. Set the current container to REGIONS_APP

C. Set the PDB_FILE_NAME_CONVERT parameter to '/u01/app/oracle/oradata'

D. Add the FILE_NAME_CONVERT clause to the command

E. Add the CREATE_FILE_DEST clause to the command

Correct Answer: C

Question 5

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

A. for query performance and space saving

B. for query performance and space saving with greater bias toward space saving

C. for parallel query performance only

D. for query performance only

E. for space saving only

Correct Answer: A

Question 6

Which two statements are true about a band join? (Choose two.)

A. The optimizer always uses the smaller of the two row sources to build a hash table on the join key.

B. It returns rows for SQL statements that contain an equijoin.

C. For each row in the first row source, Oracle probes the second row source for matching rows and joins them.

D. It is a non-equijoin in which the key values in one data set must fall within the specified range of the second data set.

E. The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.

Correct Answer: D,E

Question 7

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

A. The same small number of blocks are repeatedly accessed by different sessions simultaneously.

B. Blocks are ageing out of the buffer cache frequently.

C. A large number of connected user sessions are idle.

D. Cursors are closed explicitly after each execution.

E. The buffer cache is undersized.

F. DBWR is not writing the dirty buffers fast enough.

G. Too many sort operations are being performed.

Correct Answer: A,B,F,G

Question 8

You plan to execute this command:

Which statement is true and why?

A. It returns an error because only one set of multiple values can be specified for each partition.

B. It creates partitions P1 and P2 where COUNTRY is a single column partition key and CHANNEL is a subpartition key.

C. It returns an error because only a single column key can be used for a list-partitioned table.

D. It creates partitions P1 and P2 where COUNTRY and CHANNEL are multi-column partition keys.

E. It returns an error because the AUTOMATIC option must be specified.

Correct Answer: D

Welcome to TestSimulate

Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 (1z0-074) Free Practice Test