NO.1 Which three are true about Audit policies In container databases
(CDBs)?
A. All audit records are written to the audit trail in CDB$ROOT
B. A common unified audit policy can be created at the application root
level.
C. A common unified audit policy can be created at the CDB level.
D. An application PDB cannot have a local audit policy.
E. Fine-grained auditing policies defined in an application root must
be manually synchronized byeach application PDB contained in the application
root.
F. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.
Answer: D,E,F
NO.2 Which three are located by using environment variables? (Choose
three.)
A. the Optimal Flexible Architecture (OFA) compliant path to store
Oracle software and configurationfiles.
B. the location of Oracle Net Services configuration files
C. the list of a disk group names to be mounted by an Oracle Automatic
Storage Management (ASM)instance at startup
D. default directories for temporary files used by temporary
tablespaces
E. the temporary disk space used by Oracle Installer during
installation
F.
the
maximum number of database files that can be opened by a database instanceAnswer: A,B,E
NO.3 Which three are true about RMAN persistent configuration settings,
administration, and their effects? (Choose three.)
A. A target database's persistent RMAN configuration settings are
always stored in the target'scontrol file
B. Backup older than the recovery window retention policy are always
deleted automatically if thebackup location has insufficient space.
C. Backups written to the fast recovery area (FRA) that are oboslete
based on the redundancyretention policy can be deleted automatically to free
space.
D. The RMAN SHOW ALL command displays only settings with nondefault
values.
E. A target database's persistent RMAN configuration settings are
always synchronized automaticallywith the RMAN catalog.
F. The V$RMAN_CONFIGURATION view displays only settings with values
that have been modified.
G. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
Answer: A,B,F
Reference:
https://books.google.com.pk/books?
id=pUEkAAAAQBAJ&pg=PA114&lpg=PA114&dq=V$RMAN_CONFIGURATION+view+displays+only+set
tings
+with+values+that+have+been+modified&source=bl&ots=fhC9A7ULeX&sig=ACfU3U2-
cGhTjmAOpCZhvlL5R4j6ixLRAw&hl=en&sa=X&ved=2ahUKEwjJzf-
WmtnoAhXT8eAKHQ9uBG8Q6AEwAHoECAwQJg#v=onepage&q=V%24RMAN_CONFIGURATION%20vi
ew
%20displays%20only%20settings%20with%20values%20that%20have%20been%20modified&f=false
NO.4 Which four are true about RMAN backup sets? (Choose four.) A. A
backup piece can belong to only one backup set.
B. A data file can be split into multiple sections stored in different
backup sets.
C. A data file can be split into multiple sections stored in different
backup pieces in the same backupset.
D. Blocks from multiple data files can be contained in one backup
piece,
E. A backup set can contain only one backup piece.
F. A backup set must be written to media.
G. A backup set must be written to disk.
H. Blocks from multiple data files can be contained in one backup set,
Answer: B,E,F,H
NO.5 Which two are true about the Oracle dataabse methodology? (Choose
two.)
A. The Oracle Database time model should be used to find the database
and instance areas most inneed of tuning.
B. Tuning activities should stop once the user is satisfied with
performance.
C. Tuning activities should stop once agreed service levels for
performance have been met.
D. The database instance memory should always be tuned before tuning
any file systems.
E. SQL statements should always be tuned before tuning any file
systems.
F.
The alert
log should be used to find the database and instance areas most in need of
tuning.
Answer: C,F
Reference: https://flylib.com/books/en/4.322.1.9/1/
NO.6 Which three actions are performed by the Oracle Preinstallation
RPM, oracle-database-serverxxxx- preinstall, for Oracle Grid Infrastructure,
where xxxx is the Oracle version and release? (Choose three.)
A. performing checks to ensure minimum configuration requirements for
Oracle Grid Infrastructureare met
B. creating the oracle OS user
C. creating the OSDBA (dba) group
D. creating thte oraInventory (oinstall) group
E. creating the grid OS user
F. configuring the OS for Oracle Automatic Storage Management shared storage access
Answer: B,C,D
Reference:
https://docs.oracle.com/cd/E11882_01/install.112/e41961/prelinux.htm#CWLIN2932
NO.7 Which two are true about creating RMAN backups for an Oracle
container database? (Choose two.)
A. Tablespaces from different PDBs with identical names must be backed
up by connecting RMANseparately to each PDB to back up the tablespaces.
B. The BACKUP DATABASE command will create a pluggable database (PDB)
backup when RMAN isconnected to a PDB.
C. SPFILE backups can be created while connected to an application root
PDB.
D. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive
logs when RMAN isconnected to a PDB.
E.
The
BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT. Answer: A,B
NO.8 Which three are true In Oracle 19c and later releases?
A. Tablespaces always remain In read/write mode during transportable
tablespace operations.
B. Simultaneous data pump jobs can be limited at the pluggable database
(PDB) level.
C. Tablespaces never remain In read/write mode during transportable
tablespace operations.
D. An ordinary data pump export of a table with encrypted columns will
always encrypt the samecolumns when imported.
E. A transportable data pump import can leave a plugged-in tablespace
in read-only mode.
F. A transportable data pump import can leave a plugged-in tablespace
In read/write mode.
Answer: A,D,E
NO.9 Which two are true about data movement between a non-CDB and a PDB
using Data Pump?
(Choose two.)
A. Tablespaces are automatically created as neeed while importing full
exports in either a non-CDB ora PDB.
B. Oracle attempts to convert conventional database users to local
users when moving schemas froma non- CDB to a PDB.
C. A new PDB is automatically created when importing a non-CDB into a
CDB.
D. Oracle attempts to convert common users to conventional users when
moving schemas from aPDB to a non-CDB.
E. Moving data from a PDB to a non-CDB is only possible by using
transportable tablespace exportand import.
F. Moving data from a non-CDB to a PDB is only possible by using
conventional export and import.
Answer: D,E
NO.10 Which two are true about flashback features in Oracle Database 19c
and later releases?
(Choose two.)
A.
Flashback logs are
automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lowerthan the
time they have already been retained.
B.
Flashback logs are
monitored and proactively deleted when beyond the retention period definedin
DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
C.
Flashback logs are
monitored and proactively deleted when beyond the retention period definedin
DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
D.
Flashback logs are
monitored for being older than the retention period defined
inDB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written
event trigger.
E.
Flashback logs are
automatically purged whenever the value ofDB_FLASHBACK_RETENTION_TARGET is
changed. Answer: B,E
NO.11 A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in
CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command,
which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/',
'/u02/app/oracle/oradata/');
Which two are true? (Choose two.)
A. PDB1 data files already exist in the correct location.
B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before
executing the command.
C. PDB_FILE_NAME_CONVERT must be set before executing the command.
D. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations
of data files for PDB1.
E. PDB1 must be dropped from CDB1
Answer: A,E
Reference:
http://anjaniappsdba.blogspot.com/2016/09/oracle-database-12102c-hot-cloning-of.html
NO.12 Examine these actions:
1. Create a new database for a recovery catalog.
2. Create a tablespace with sufficient space in the catalog database
for the recovery catalog.
3. Configure ARCHIVELOG mode for the catalog database.
4. Create a user to own the recovery catalog schema with quota on the
tablespace that will containthe catalog.
5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema
owner.
6. Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be
performed before executing the CREATE CATALOG command?
A. 2, 4, 5, 6
B. 1, 2, 3, 4, 5, 6
C. 1, 2, 4, 5
D. 2, 4, 5
E. 1, 3, 4, 5
Answer: D
NO.13 A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken and no backup
to trace has been taken of the control file. A media failure has occurred.
In which two scenarios is complete
recovery possible? (Choose two.)
A. when any archived log from, before, or after the most recent backup
is corrupt.
B. after losing all copies of the control file
C. after losing an archived log from after the most recent backup
D. after losing an archived log from before the most recent backup
E. after losing the SYSTEM tablespaceAnswer: D,E
NO.14 Examine this configuration:
CDB1 is a container database.
COMMON_USER_PREFIX is C##.