Oracle 1Z0-067 dumps - 100% Pass Guarantee!

Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?

A. maximum undo per consumer group

B. maximum idle time for a session in a PDB

C. parallel server limit

D. CPU

E. maximum number of sessions for a PDB

Which two statements describe the relationship between a window, a resource plan, and a job class?

A. A window specifies a resource plan that will be activated when that window becomes active.

B. A window specifies a job class that will be activated when that window becomes active.

C. A job class specifies a window that will be open when that job class becomes active.

D. A window in association with a resource plan controls a job class allocation.

E. A window in association with a job class controls a resource allocation.

You set the following parameters in the parameter file and restart the database instance: MEMORY_MAX_TARGET=0 MEMORY__TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M

Which two statements are true?

A. The memory_max_target parameter is automatically set to 500 MB.

B. The pga_aggregate_target and sga_target parameters are automatically set to zero.

C. The value of the memory_max_target parameter remains zero for the database instance.

D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

You administer a database that was created using Oracle Database 10g.

The default tablespace type property was not changed. You execute this statement to create a tablespace,

mytbs:

CREATE TABLESPACE mytbs DATAFILE `/u1/data/mytbs.dbf' SIZE 100M;

Which two statements are correct regarding the mytbs tablespace? (Choose two.)

A. It is a bigfile tablespace

B. It is a locally managed tablespace with uniform size of 8m

C. It is a locally managed tablespace with autoallocate

D. It is a dictionary-managed tablespace

E. It is a smallfile tablespace

Examine the query and its output executed in an RDBMS instance:

Which three statements are true about the users (other than SYS) in the output? (Choose three.)

A. The C##D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM)

B. The C##C_ADMIN user can perform the data guard operation with Data Guard Broker

C. The C##A_ADMIN user can perform wallet operations

D. The C##B_ADMIN user can perform all backup and recovery operations using RMAN or SQL*Plus

E. The C##B_ADMIN user can perform all backup and recovery operations using RMAN only