Question No. 1

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

AOracle Data Pump

BOracle Recovery Manager (RMAN)

COracle Label Security

DOracle Database Vault

EOracle Real Application Security

Show Answer

Correct Answer: B

Question No. 2

In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command:

Which statement is true?

AThe command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.

BThe command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the pluggable databases (PDBs).

CThe command fails because the CONTAINER clause is not used.

DThe command fails because system privileges cannot be granted to a common user.

Show Answer

Correct Answer: A

Question No. 3

Which two statements are true about making RMAN image copies of a database? (Choose two.)

AThe can only be written to disk.

BThe can be made only when the database is running in NOARCHIVELOG mode.

CThey can be made only when the database is in MOUNT state.

DThey consist of all used an unused blocks in the data files.

EThey can be made only when the database is running in ARCHIVELOG mode.

Show Answer

Correct Answer: A, D

An image copy can be written only to disk.

An image copy is the same as datafiles. The disadvantage of image copy backup mode is that it occupies much space and does not skip unused data blocks.

References: http://www.dba-oracle.com/t_rman_10_image_copies.htm

Question No. 4

You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).

You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.

What is the easiest way to perform capacity planning for consolidation?

Acapturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

Bcapturing the workload on the production system and replaying the workload for one PDB at a time on the test system

Ccapturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

Dcapturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system

Show Answer

Correct Answer: C

Question No. 5

Examine the initialization parameter that is set in the PFILE:

DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'

You execute the following command to create CDB1 container database (CDB):

SQL>CREATE DATABASE CDB1

DEFAULT TABLESPACE users

DEFAULT TEMPORARY TABLESPACE

temp

UNDO TABLESPACE

Undotbsl ENABLE

PLUGGABLE DATABASE SEED

SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE

UNLIMITED SYSAUX DATAFILES SIZE 100M;

Which three statements are true? (Choose three.)

AIt creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.

BThe files created for both the root and seed databases use Oracle Managed Files (OMF).

CIt creates a multitenant container database with the root and seed databases opened and one PDB mounted.

DIt sets the users tablespace as the default for both the root and seed databases.

Eundotbs1 is used as the undo tablespace for both the root and seed databases.

FIt creates a multitenant container database with the root database opened and the seed database mounted.

Show Answer

Correct Answer: A, B, E

Free Oracle 1Z0-063 Exam Actual Questions

The questions for 1Z0-063 were last updated On Nov 3, 2024