Question No. 1

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

Amaximum undo per consumer group

Bmaximum idle time for a session in a PDB

Cparallel server limit

DCPU

Emaximum number of sessions for a PDB

Show Answer

Correct Answer: C, D

Question No. 2

You created a tablespace with this statement:

CREATE BIGFILE TABLESPACE adtbs

DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;

The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.

Which two alter statements will achieve this? (Choose two.)

AALTER TABLESPACE adtbs RESI2E 20G;

BALTER TABLESPACE adtbs ADD DATAFILE;

CALTER TABLESPACE adtbs AUTOEXTEND ON;

DALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;

EALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Show Answer

Correct Answer: A, C

http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

Question No. 3

Which two are prerequisites for performing Flashback Transaction? (Choose two.)

AA supplemental log must be enabled for the primary key.

BUndo retention guarantee must be configured for the database.

CFast Recovery Area must be enabled for the database.

DThe EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

ERow movement must be enabled.

Show Answer

Correct Answer: A, D

Question No. 4

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

AIf no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.

BTo enable a resource plan for a PDB, a CDB resource plan must be created and enabled.

CIf a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.

DIf no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.

EIf a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Show Answer

Correct Answer: A, E

A: A CDB resource plan determines the amount of resources allocated to each PDB. A PDB resource plan determines how the resources allocated to a specific PDB are allocated to consumer groups within that PDB.

Resource Manager allocates the resources in two steps:

E: A PDB resource plan allocates resource among the consumer groups within a PDB.

References: https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm

Question No. 5

Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.

Examine the commands executed and their output:

Why is it that only one update is listed by the Flashback Version Query?

ASupplemental logging is not enabled for the database.

BThe undo data that existed for versions of rows before the change to the table structure is invalidated.

CThe DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.

DUndo retention guarantee is not enabled.

EFlashback Data Archive is full after the first update statement.

Show Answer

Correct Answer: B

Free Oracle 1Z0-063 Exam Actual Questions

The questions for 1Z0-063 were last updated On Jan 15, 2025