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##.
Which two are true? (Choose two.)
A.
APP1_USER1 can be created in PDB1.
B. APP1_USER1 can be created in CDB1.
C. APP1_USER1 can have different privileges in each Application PDB
contained in APP1_ROOT.
D. C##_APP_USER1 can be created in CDB1.
E. P1_USER1 can be created in CDB1.
F. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.
Answer: C,F
NO.15 Which four are true about duplicating a database using Recovery
Manager (RMAN)? (Choose four.)
A. Duplication can be done by having the auxiliary database instance
pull backup sets from the targetdatabase instance.
B. A connection to an auxiliary instance is always required.
C. A subset of the target database can be duplicated.
D. A new DBID is always created for the duplicated database.
E. A connection to the recovery catalog instance is always required.
F. A backup of the target database is always required.
G. Duplication can be done by having the target database instance push
copies to the auxiliarydatabase instance.
H. A connection to the target database instance is always required.
Answer: A,B,C,G
Explanation:
A
duplicate database is a copy of your target database. With the FOR STANDBY
clause, it keeps the same unique database identifier(DBID); If FOR STANDBY not
specified it creates a new DBID. The duplicate database can include the same
content or only a subset from the source database. It can be in the same host
or a separate host. The principal work of the duplication is performed by the
auxiliary channels.These channels correspond to a server session on the
auxiliary instance on the destination host for backup based duplication. For
active database duplication the target channels perform the work of pushing
data file copies to the auxiliary instance (if number of allocated target
channels is greater than the number of allocated auxiliary channels).
NO.16 Which three can be done using Oracle Database Configuration
Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
A. cloning a remote container database in interactive mode
B. cloning a remote pluggable database in silent mode
C. relocating a remote pluggable database in interactive mode
D. relocating a remote container database in silent mode
E. cloning a remote container database in silent mode
F. relocating a remote pluggable database in silent mode
G. relocating a remote container database in interactive modeAnswer: B,E,F
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/clone-pdbs-using-dbca-silentmode/index.html?
learningpath=true&appuser=nobody&appsession=170971049395&contentid=26693&activityname=C
lone% 20PDBs%20using%20DBCA%20in%20Silent%20Mode&eventid=6352
NO.17 You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this
command:
Which three are true? (Choose three.)
A. The restore point is a label for the system change number (SCN) that
will be saved two years afterthe archival backup was taken.
B. The data file backups in the self-contained archive backup are not
considered obsolete for twoyears regardless of the retention policy.
C. All archive logs created after this backup are kept for two years.
D. The SPFILE is included in the self-contaied archival backup.
E. The control file is included in the self-contained archival backup.
F. The restore point is a label for the system change number (SCN)
before the archival backup wastaken.
Answer: C,D,E
NO.18 Examine this configuration:
A. It will create
'$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
B. It will create
'/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
C. It will re-create
'/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'D. It
will create
'/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.
E. It will fail because there is no autobackup of the controlfiles.
Answer: C
NO.19 You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)
A. All Oracle recovery files not in the current FRA that have not been
backed up already, are backedup.
B. All non-Oracle files in the current FRA that have not been backed up
already, are backed up.
C. All Oracle recovery files in the current FRA that have not been
backed up already, are backed up.
D. All Oracle recovery files in the current fast recovery area (FRA)
are backed up.
E. These backups can be written to disk or SBT.
Answer: D,E
Explanation:
https://blog.toadworld.com/rman_-_using_the_flash_recovery_area
NO.20
You plan to install Oracle Grid Infrastructure for a Standalone Server and
Oracle Database for the first time on a server.
Examine this command and its outcome:
Which two are true? (Choose two.)
A. oracle will be an owner of the Oracle Inventory.
B. oracle must be the owner of every Oracle Database installation.
C. oracle can own an Oracle Database installation but not an Oracle
Grid Infrastructure installation.
D. oracle will be granted the SYSASM privilege when installing the
Oracle Database software.
E. The user account, oracle, and group, oinstall, can be used for all
Oracle software installations.
Answer: C,D
NO.21 Which two are true about the character sets used in an Oracle
database? (Choose two.) A. Single-byte character sets provide better performance than
multibyte character sets.
B. Unicode enables information from any language to be stored using a
single character set.
C. Unicode is the only supported character set for Oracle databases
created using Database
Configuration Assistant (DBCA).
D. Single-byte character sets always use 7-bit encoding schemes.
E. Multibyte character sets allow more efficient space utilization than
single byte character sets.
F. Single-byte character sets always use 8-bit encoding schemes.Answer: A,B
Reference:
https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG166
NO.22 Examine this output:
In which two scenarios is incomplete recovery required? (Choose two.)
A. after losing a SYSAUX tablespace data file
B. after losing all members of an INACTIVE online redo log group
C. after losing all members of the CURRENT online redo log group
D. after losing all copies of the control file
E. after losing an UNDO tablespace that is in useAnswer: B,D
NO.24 Which three are true about Optimizer Statistics Advisor? (Choose
three.) A. It can be run only manually.
B. It is part of the DBMS_ADVISOR package.
C. It can recommend changes to improve the statistics gathering
process.
D. It always analyzes all schemas in the database.
E. It runs automatically every night by default.
F. It is part of the DBMS_STATS package.Answer: A,C,F
Explanation:
https://mikedietrichde.com/2017/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-
0-1/
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c5324205.pdf
Reference: https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2
NO.25 While backing up to an SBT channel, you determine that the read
phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is
a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read
performance? (Choose two.) A. Increase the size of tape I/O buffers.
B. Disable FORCE LOGGING for the database.
C. Increase the size of the database buffer cache.
D. Enable asynchronous disk I/O.
E. Increase the level of RMAN multiplexing.Answer: D,E
NO.26 You must transport the UNIVERSITY tablespace from one database to
another.
The UNIVERSITY tablespace is currently
open read/write.
The source and destination platforms have
different endian formats. Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Convert the UNIVERSITY tablespace data fies to the destination
platform format using RMAN onthe source system.
4. Copy the UNIVERSITY tablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITY tablespace data files to the destination
platform format using RMAN onthe destination system.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions
required, in the correct order, to transport the UNIVERSITY tablespace?
A. 1, 2, 4, 5, 7, 8
B. 1, 2, 4, 6, 7, 8
C. 1, 2, 3, 4, 5, 7, 8
D. 1, 2, 3, 4, 5, 6, 7, 8
E. 2, 4, 5, 6, 7
Answer: B
NO.27 Which two are true about the execution of operating system scripts
starting from Oracle
Database 19c? (Choose two.)
A. orainstRoot.sh can be executed automatically by the Database
installer by using sudo or rootcredentials.
B. root.sh can be executed automatically by the Database Installer only
if it is provided with rootcredentials.
C. The sudo password can be specified in a response file.
D. root.sh can be executed automatically by the Database installer only
by using sudo credentials.
E. The sudo password must be specified in a response file.
F. The root password cannot be specified in a response file.Answer: A,F
NO.28 Which two are true about diagnosing Oracle Database failure
situations using Data Recovery Advisor? (Choose two.)
A. Using the Data Recovery Advisor LIST FAILURE command always requires
that the database forwhich failures are to be listed is in MOUNT state.
B. A failure can be closed only when it has been repaired.
C. Data Recovery Advisor can be used if a database is closed.
D. The Data Recovery Advisor CHANGE FAILURE command can be used only to
change failurepriorities.
E. Data Recovery Advisor can proactively check for failures.Answer: D,E
NO.29 Which three are true about
performing an Oracle Database install on Linux? (Choose three.) A. The
runfixup.sh script can install missing RPMs.
B. The Oracle Preinstallation RPM must be used to configure the Oracle
database installation owner,the Oracle Inventory group, and an Oracle
administrative privileges group.
C. It allows you to select the languages supported by the Oracle
database server.
D. It can be done before installing Grid Infrastructure for a
Standalone Server.
E. The Oracle Preinstallation RPM can be used to configure the Oracle
database installation owner,the Oracle Inventory group, and an Oracle
administrative privileges group. F. It can be done after installing Grid Infrastructure for a
Standalone Server.
G. The Oracle database administrator must be granted access to the
root operating system account to tun root privileged scripts. Answer: C,E,G
NO.30 Examine this configuration:
CDB1 is a container database.
PDB1 and PDB2 are pluggable databases in
CDB1.
PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully:
criterion.
E. Oracle DBCA templates can be used to create new databases and
duplicate existing databases. Answer: A,E
Reference:
https://docs.oracle.com/database/121/ADMQS/GUID-2B8A3B5E-D319-4377-8B228BB67DCC9885.htm#ADMQS0235
NO.32 Which two are true about Oracle Flashback features? (Choose two.)
A. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED
REDO LOG files.
B. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and
ARCHIVED REDO LOGfiles.
C. FLASHBACK TABLE can undrop a column.
D. FLASHBACK DROP can undrop an index when undropping a table.
E. After a database is restored from flashback logs using the FLASHBACK
DATABASE command, it issometimes rolled forward using redo logs. Answer: D,E
NO.33 Which two are true about gathering optimizer statistics? (Choose two.)
A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to
CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB
opened inread/write mode gathers object statistics for that PDB.
C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to
CDB$ROOT gathers object statistics only in CDB$ROOT.
D. System statistics can be gathered only while connected to CDB$ROOT.
E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to
CDB$ROOT gathers object statistics in all open pluggable databases (PDBs) Answer: B,E
Explanation:
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-
well/#:~:text=Yes%2C%20you'll%20have%20to,independently%20from%20the%20CDB%24ROOT.&te
xt=Oracle%20Database%20automatically%20gathers%20fixed,Automatic%20Optimizer%20Statistics
%20Collection%E2%80%9C) .
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/20/arpls/DBMS_STATS.html
NO.34 Which three are true about thresholds, metrics, and
server-generated alerts? (Choose three.) A. All metrics are instance
related.
B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
C. A space usage management alert is automatically cleared after the
underlying problem is resolved.
D. They are generated by SMON when a tablespace is 97% full.
E. Metrics are statistical counts for a specific unit.
F. STATISTICS_LEVEL must be set to ALL to generate alerts.Answer: B,C,E
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027
https://blogs.oracle.com/oem/how-to-clear-an-alert-v2
NO.35 Which three are true about transporting databases across platforms
using Recovery Manager (RMAN) image copies? (Choose three.)
A. By default, the transported database will use Oracle Managed Files
(OMF)
B. Data files can be converted on the destination system.
C. Data files can be converted on the source system.
D. A new DBID is automatically created for the transported database.
E. Databases can be transported between systems with different endian
formats.
F. The password file is automatically converted by RMAN.Answer: B,C,E
Explanation:
Password file is automatically converted
by RMAN.
NO.36 Examine this configuration:
1. CDB1 is a container database running in archivelog mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are inactive.
4. Redo log group 3 is the current group.
All members of redo log group 3 are lost
before it is archived. Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABASE
6. RECOVER DATABASE NOREDO
A. 1, 3, 5, 6, 10
B. 1, 3, 5, 8, 6, 10
C. 1, 3, 5, 6, 9
D. 1, 3, 5, 6, 10
E. 1, 2, 5, 7, 4, 10
F. 1, 3, 5, 7, 10
Answer:
D
(Choose three.)
B.
With Automatic Memory
Management, the database instance can increase the System GlobalArea size by
reducing the Program Global Area size.
C.
Automatically tuned and
resized System Global Area components will always revert to their initialsizes
after an instance restart.
D.
Automatic Memory Management
must be used together with locking the System Global Area intophysical memory.
E.
With Automatic Shared
Memory Management, the database instance can increase the ProgramGlobal Area
size by reducing the System Global Area size.
F.
On Line Transaction
Processing systems often use less Program Global Area than Decision
SupportSystems. Answer: A,E,F
Reference:
https://docs.oracle.com/database/121/TGDBA/tune_shared_pool.htm
NO.38 Examine this configuration:
1. The ORCL database data files are in Automatic Storage Management
(Oracle ASM) disk group+DATA.
2. ORCL uses disk group +FRA for the Fast Recovery Area.
3. LISTENER is the listener for ORCL.
4. The database, listener, ASM instance, and ASM disk groups are
managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:
What is the outcome?
A. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk
groups, and the LISTENERare started.
B. Only the ORCL database instance is started.
C. Only the ORCL database and the ASM instances are started.
D. Only the ORCL database instance, the Oracle ASM instance, and the
+DATA and +FRA disk groupsare started.
E.
Only the
ORCL database instance and the +DATA and +FRA disk groups are started.
Answer: D
NO.39 Which two are true about Recovery Manager (RMAN) diagnostic message
output? (Choose two.)
A. Media Management messages for SBT devices are always written to
sbtio.log.
B. RMAN error stacks should be read from the bottom up as that is the
order in which errors aregenerated.
C. RMAN error stacks should be read from the top down as that is the
order in which errors aregenerated.
D. The RMAN LOG command line clause causes output issued during RMAN
command compilation tobe written to a log file and to standard output.
E. The RMAN LOG command line clause causes output issued during RMAN
command compilation tobe written to a log file only.
F. Media Management messages for SBT devices are written to an Oracle trace file.
Answer: E,F
NO.40 Your container database, CDB1, has an application container,
HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone
HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)
A. CDB1 and CDB2 must be in shared undo mode.
B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE
privilege.
C. All transactions in HR_PDB1 of CDB1 must commit before the cloning
process starts.
D. Cloning HR_ROOT automatically clones HR_PDB1.
E. The HR_PDB1 clone created in CDB2 will be in mount state when
cloning ends.Answer: B,D
NO.41 Which two are true about RMAN backups when using a media manager to
write backups to tape when there are only two tape drives? (Choose two.)
A. SBT tape compression can be used even if no RMAN compression is
configured.
B. Any backup set written to the SBT device in this configuration can
contain a maximum of twobackup pieces.
C. Any backup written to the SBT device in this configuration can
contain a maximum of two backupsets.
D. SBT tape compression and RMAN backup compression should be used in
parallel.
E. The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be usedsimultaneously.
Answer: D,E
NO.42 How do you configure a CDB for local undo mode?
A.
Open the CDB instance in
upgrade mode. In cdb$root, execute alter database local undo on, and then
restart the CDB instance.
B.
Open the CDB in read-only
mode. In cdb$root, execute alter database local undo on, and then change the
CDB to read/write mode.
C.
Open the CDB instance in
restricted mode. In cdb$root, execute alter database local undo on. create an
undo tablespace in each PDB, and then restart the CDB instance
D.
Open the CDB instance in
restricted mode. In cdb$root, drop the undo tablespace. Execute alter database
local undo on in each PDB, and then restart the CDB instance.
E.
Open the
CDB instance in upgrade mode. In each PDB, execute alter database local undo
on,create an undo tablespace, and then restart the CDB instance. Answer: D
NO.43 Which three are true about the SQL Tuning Advisor? (Choose three.)
A. It checks each query being analyzed for stale statistics.
B. It checks each query being analyzed for missing statistics.
C. It only recommends syntactic changes to SQL statements.
D. It can recommend semantic changes to SQL statements.
E. It considers all SQL statements being analyzed by the advisor task
as a group.
F. It builds SQL profiles for each poorly performing SQL statement to prevent regressions.
Answer: A,B,F
Reference:
https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL540
NO.44 Which four are true about performing Tablespace Point -In-Time
Recovery (TSPITR) using Recovery Manager (RMAN)?
A. It can be performed using an auxiliary instance managed by a DBA.
B. It can be used to recover a truncated table.
C. RMAN automatically adds any required tablespaces to the recovery set
to make it self-contained.
D. RMAN always includes tablespaces containing undo segments in the
recovery set.
E. It can be performed repeatedly until the correct time is found
without using an RMAN catalog.
F. flashback database must be enabled for it to work.
G. It can be used to recover a dropped tablespace.
H. It can be performed using an auxiliary instance managed by RMAN
Answer: A,E,F,H
NO.45 Which three are true? (Choose three.)
A. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
B. Application-common TSDP policies are always container specific.
C.
Application-common
Transparent Security Data Protection (TSDP) policies can be created onlywithin
an application install/patch BEGIN-END block.
D.
Application-common Oracle
Label Security (OLS) policies cannot be created in an application rootoutside
an install/patch BEGIN-END block.
E.
Fine-grained auditing (FGA)
policies in an application root are automatically synchronized to
allapplication PDBs contained in the application container.
F.
Application-common OLS
policies can be created in an application root inside an install/patchBEGIN-END
block.
G.
Unified auditing can be
automatically synchronized to all application PDBs in an applicationcontainer.
Answer: A,D,G
A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by
using RMAN whileconnected to PDB1.
B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by
using SQL whileconnected to PDB1.
C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by
using SQL whileconnected to CDB$ROOT.
D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by
using RMAN whileconnected to CDB$ROOT.
E. This cannot be done due to the lack of a clean restore point.
Answer: B
NO.47 Which two are true about OS groups and users for Oracle Grid
Infrastructure and the Oracle
Relational Database Management System
(RDBMS)? (Choose two.)
A. By default, members of the OSASM group can access Automatic Storage
Management and RDBMSinstances.
B. The primary group for the Oracle Grid Infrastructure and Oracle
Database owners must be theOracle Inventory group.
C. The Oracle Grid Infrastructure installation must be owned by the
grid user.
D. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle
Automatic StorageManagement binaries.
E. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA,
and OSKMDBA assecondary groups.
F.
The same
OSDBA group must be used for Automatic Storage Management and the
OracleDatabase. Answer: E,F
Reference:
https://docs.oracle.com/database/121/CWWIN/usrgrps.htm#CWWIN-GUID-6FD3C6AE-5A99-
4C6D -85D6-868CBA6F5DAE
NO.48 Which two are true about Rapid Home Provisioning (RHP), which has
been available since Orcale 18c? (Choose two.)
A. It is an Oracle Database service
B. It cannot be used to upgrade Oracle Database homes.
C. It can be used to provision applications.
D. It can be used to patch Grid Infrastructure homes containing Oracle
Restart.
E. It can be used to provision middleware.
Answer: D,E
Reference:
https://www.oracle.com/assets/rapid-home-provisioning-2405191.pdf
NO.49 Which three are true about requirements for various FLASHBACK
operations? (Choose three.) A. FLASHBACK transaction query requires undo to retrieve all versions
of a row that existed between two points in time.
B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
C. FLASHBACK version query requires that the RECYCLEBIN parameter be
set to ON.
D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all
rows of a table being tracked.
E. FLASHBACK drop requires undo to retrieve all versions of a row that
existed between two points intime.
F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between twopoints in time.
Answer: A,B,F
Reference:
https://books.google.com.pk/books?id=0iwrL9P25Z0C&pg=PA35&lpg=PA35&dq=FLASHBACK+transa
ction
+query+requires+undo+to+retrieve+all+versions+of+a+row+that+existed+between+two+points+in
+time&source=bl&ots=MJnYl5CZ1u&sig=ACfU3U0dWP-NPd-
U8uu3zbaoi3YZzT0FTQ&hl=en&sa=X&ved=2ahUKEwigi5_Jl9joAhXzUBUIHUh4DksQ6AEwAnoECAsQJg
#v=
onepage&q=FLASHBACK%20transaction%20query%20requires%20undo%20to%20retrieve%20all%
20versions%20of%20a%20row%20that%20existed%20between%20two%20points%20in%20time&f=f
alse https://docs.oracle.com/cd/E18283_01/server.112/e17120/tables011.htm
NO.50 Application PDBs, SALES_APP1 and SALES_APP2, must be created and
they must access common tables of the SALES_APP application.
Examine these steps:
1. Install the SALES_APP application, including the common tables, in
the application root.
2.
Install
the SALES_APP application in the application root and the common tables in both
the CDBroot and the application root. 3. Create an application seed.
4. Install the SALES_APP application in the application seed.
5. Create the SALES_APP1 and SALES_APP2 application PDBs.
6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the
application root.
7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the
application seed.
8. Sync the application seed with the application root.
Which are the minimum required steps in
the correct sequence?
A. 3,4,1,6,8
B. 1,5,6
C. 1,3,5,6,7
D. 1,3,5,7
E. 2,5,6
Answer: B
NO.51 Which two are true about creating pluggable databases (PDBs) using
snapshots in Oracle 19c and later releases? (Choose two.)
A. A PDB snapshot is always a full copy of the source PDB.
B. A PDB snapshot is always a sparse copy of the source PDB.
C. A snapshot copy PDB depends on a storage snapshot which can only be
stored on specific filesystems.
D. A PDB snapshot depends on a storage snapshot which can be stored on
any file system.
E. A PDB snapshot depends on a storage snapshot which can only be
stored on specific file systems.
F. A snapshot copy PDB depends on a storage snapshot which can be
stored on any file system.
G. A snapshot copy PDB can be created from a stand-alone clone PDB.
Answer: A,E
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-pdbsnapshots.html#GUID-35B03C37-00BA-4945-BF20-9A7C4C541955
NO.52 Which two are true about duplicating pluggable databases (PDBs)
with RMAN? (Choose two.) A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE
command.
B. All tablespaces belonging to a PDB must be duplicated when
duplicating the PDB.
C. The auxiliary instance is automatically created with
ENABLE_PLUGGABLE_DATABASE = TRUE.
D. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the
PDB to duplicate it.
E. CDB$ROOT and PDB$SEED are automatically duplicated. Answer: C,D
Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV430
NO.53 Which two are facets of performance planning that should always be
considered or implemented for an Oracle Database environment? (Choose two.)
A. defining primary keys for all tables to speed up all queries
B. using check constraints to speed up updates
C. defining foreign keys for all tables to speed up joins
D. the physical data model
E. the configuration of storage arrays
Answer: A,E
NO.54 Which two are true about RMAN encryption? (Choose two.)
A. RMAN encryption keys are stored in a database keystore.
B. RMAN can encrypt the Oracle Database password file.
C. Dual-mode encrypted backups can be restored only if both the
password and the keystore usedfor encryption are available.
D. The SET ENCRYPTION command overrides encryption settings specified
by the CONFIGUREENCRYPTION command.
E.
Password
encryption can be persistently configured using the CONFIGURE ENCRYPTION
command.
Answer: C,D
Reference:
https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#BRADV89476
NO.55 On the 10th of August, you implement an incremental database backup
strategy and configure a recovery window of five days.
Level 0 backups are taken on the 10th,
17th, and 24th of August.
Differential level 1 incremental backups
are taken daily between the level 0 backups.
Today is the 26th of August.
Which backups will be obsolete?
A. all backups prior to 10th of August
B. all backups prior to 22nd of August
C. all backups prior to 24th of August
D. all backups prior to 20th of August
E. all backups prior to 17th of August
Answer: C
NO.56 Examine this configuration:
CDB1 is a container database.
PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully:
Answer: B,E
NO.57 Which two are facets of performance planning that should always be
considered or implemented for an Oracle Database environment? (Choose two.)
A. the physical data model
B. using check constraints to speed up updates
C. the configuration of storage arrays
D. defining foreign keys for all tables to speed up joins
E. defining primary keys for all tables to speed up all queries
Answer: C,E
NO.58 You are managing this configuration:
CDB1 is a container database.
PDB1 and PDB2 are two pluggable databases
in CDB1.
USER1.EMP is a table in PDB1 and
USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:
Answer: G,F
NO.59 Which three are true about an application seed pluggable database (PDB)? (Choose three.)
A. It is automatically synchronized with its application root PDB when an application is upgraded.
B. It cannot be added to an application container after the application
container has already beencreated.
C. A new application PDB created by cloning an application seed PDB can
have an old version of theapplication installed after cloning completes.
D. It is automatically synchronized with its application root PDB when
an application is installed.
E. It cannot be dropped from its application container.
F. A new application PDB created by cloning an application seed PDB can have an up-to-date versionof the application installed after cloning completes.
G. It is not required in an application container.
Answer: D,F,G
NO.60 While backing up to the Oracle Fast Recovery Area (FRA), you
determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and
tuning these problems? (Choose three.)
A.
If an RMAN BACKUP VALIDATE
command takes roughly the same time as an actual backup, thenboth read and
write I/O are likely bottlenecks.
B.
Setting DBWR_IO_SLAVES to a
non zero value can improve backup performance when usingsynchronous I/O.
C.
If an RMAN BACKUP VALIDATE
command takes noticeably less than an actual backup, then writeI/O is a likely
bottleneck.
D.
If an RMAN BACKUP VALIDATE
command takes roughly the same time as an actual backup, thenread I/O is a
likely bottleneck.
E.
Data files with a high value
in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance
bottleneck when synchronous I/O is used.
F.
Setting DBWR_IO_SLAVES to a
non zero value can improve backup performance when usingasynchronous I/O/
G.
Data
files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential
performance bottleneck when asynchronous I/O is used. Answer: B,C,E
Reference:
https://web.stanford.edu/dept/itss/docs/oracle/10gR2/backup.102/b14191/rcmtunin003.htm
NO.61 Which two are true about unplugging an application container from a
container database and plugging it into a different container database?
A. It requires local undo mode in both container databases.
B. It requires only local undo mode in the database where the
application container will beunplugged.
C. Plugging the application root into a different CDB plugs In all its
application PDBs.
D. Application PDBs In the application container must be unplugged
before the application root Isunplugged.
E. Unplugging the application root from a CDB unplugs all its application
PDBs.
F. The application root of an application container should be plugged
Into the other CDB before Itsapplication PDBs are plugged in. Answer: D,E
NO.62 Which three actions are performed by Database Upgrade Assistant
(DBUA)? (Choose three.) A. It recompiles all stored PL/SQL code by using utlrp.sql.
B. It empties the RECYCLE BIN.
C. It performs prerequisite checks to verify if the Oracle database is
ready for upgrade.
D. It sets all user tablespaces to "read-only" before
starting the upgrade.
E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER
roles
F. It increases tablespace size, if required, to meet upgrade requirements.
Answer: A,C,F
Reference:
https://oracle-base.com/articles/12c/upgrading-to-12c
NO.63 Examine this configuration:
CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
PDB$SEED is open READ ONLY PDB1 is open READ WRITE PDB2 is MOUNTED.
ORACLE_HOME is
/u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before
upgrading the database to the current release:
E. RMAN SBT-based backups of the database to be duplicated can be used
by the auxiliary instance. F. The UNDO TABLESPACE clause is always required when no connection
exists to the recovery catalog and the TARGET database is closed.
G.
The UNDO TABLESPACE clause
is always required when no connection exists to the recoverycatalog and the
TARGET database is opened.
H. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
Answer: A,B,G,H Reference:
http://oradb-srv.wlv.ac.uk/ora12c/RCMRF/rcmsynta020.htm
NO.65 A container database (CDB) contains two pluggable databases PDB1
and PDB2.
The LOCAL_UNDO_ENABLED database property
is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to
restore and recover it.
The only RMAN backup that exists was
created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)
A. Data file 24 can be recovered only while connected to PDB2.
B. Data file 24 can be restored and recovered while connected to
CDB$ROOT.
C. Data file 24 can be restored only while connected to CDB$ROOT.
D. Data file 24 can be restored only while connected to PDB2.
E. Data file 24 can be recovered while connected to PDB2.
F. Data file 24 can be recovered while connected to CDB$ROOT.
Answer: B,C,F
NO.66 Which two are true about instance recovery? (Choose two.)
A. It is not possible if an archived log is missing.
B. It is performed automatically after the database is opened; however,
blocks requiring recovery arenot available until they are recovered.
C.
Setting
FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by
causingdirty buffers to be written to disk more frequently, thereby reducing
the number of I/Os needed during instance recovery.
D. It is performed by the Recovery Writer (RVWR) background process.
E. Setting FAST_START_MTTR_TARGET to a higher value reduces instance
recovery time by causingthe log writer to write more frquently, thereby
reducing the number of I/Os needed during instance recovery.
F. It is performed automatically while the database remains in MOUNT
state. Then the database isopened.
Answer: E,F
NO.67 Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output:
Which two are true? (Choose two.)
A. The CONTAINERS clause cannot be used in queries on the REVENUE
table.
B. The REVENUE table must be a list-partitioned table.
C. The MAPTABLE tables defines a logical partition key on a commonly
used column for the REVENUEtable.
D. The MAPTABLE table is a metadata-linked table.
E. A container map exists for the REVENUE table, but is not enabled.
F. The REVENUE table partitions are not pruned across the PDBs automatically.
Answer: C,E
NO.68 Which two are true about Oracle Optimizer Statistics, their use,
and their collection? (Choose two.)
A. The number of table rows is considered when evaluating the cost of
accessing a table using anindex.
B. Index balanced B*Tree height is considered when evaluating the cost
of using an index.
C. The Statistics Advisor can help recommend the best way to gather
statistics.
D. Statistics collected using DBMS_STATS always yield the best
optimizer result.
E. The Statistics Advisor generates actions for all recommendations.Answer: C,D
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-statisticsadvisor.html#GUID-D81A7708-FDA0-45BB-A6E2-103858B047AE
NO.69 Which three are true about Oracle Grid Infrastructure for a
Standalone Server?
A. It includes both Oracle Restart and Oracle Automatic Storage
Management (ASM) software.
B. It creates one disk group during installation.
C. It requires the operating system oracle_base environment variable to
be predefined beforeinstallation.
D. It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic
Storage Management (ASM)disks
E. It requires Oracle ASMLibto manage Automatic Storage Management
(ASM) disks.
F.
Automatic
Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assignedas
secondary groups for its installation owner. Answer: A,B,D
NO.70 Which three are true about Database Point-in-Time Recovery? (Choose
three.)
A. The database must have FLASHBACK DATABASE ON to perform Database
Point-in-Time Recovery.
B. The database must be in MOUNT state when performing Database
Point-in-Time Recovery.C. Database Point-in-Time Recovery is performed by the Managed
Recovery Process (MRP)
D. The Database must be in ARCHIVELOG mode.
E. The target point for the recovery must be specified as a stime or
System Change Number (SCN).
F. The database must be open RESETLOGS after Database Point-in-Time
Recovery.Answer: B,D,F
Explanation:
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%20p
oint%2Din%2Dtime%20recovery%20(DBPITR)%20restores%20the,forward%20to%20the%20target%2
0time.
NO.71 Which three are true about backup, restore, and recovery operations
done without using
Recovery Manager (RMAN)? (Choose three.)
A. Backing up a database in NOARCHIVELOG mode using O/S utilities
requires that the databaseinstance be started and the dataabse be in the MOUNT
state.
B. Backing up a database in ARCHIVELOG mode using O/S utilities
requires that the database instancebe started and the database be in MOUNT
state.
C. An Oracle database can be restored from backup files copied using
O/S utilities.
D. Oracle data file backups, copied using an O/S utility, can be added
to the RMAN catalog as IMAGECOPIES.
E. Backing up a database in NOARCHIVELOG mode using O/S utilities
requires that the databaseinstance be shut down.
F. Oracle archive log backups, copied using an O/S utility, can be
added to the RMAN catalog as abackup set.
G.
Backing
up a database in ARCHIVELOG mode using O/S utilities requires that the
databaseinstance be started and the database be in OPEN state. Answer: B,D,E
NO.72 Which two are true about common objects? (Choose two.)
A. They can be created only in CDB$ROOT.
B. They can be only metadata-linked in an application container.
C. They can exist in user-defined schemas only in application containers.
D. They can exist in CDB$ROOT and an application root.
E. They can be extended data-linked in CDB$ROOT.
F. They can be created only in an application root.
Answer: C,F
Reference: https://blog.toadworld.com/2017/08/01/oracle-multi-tenant-application-containers-part-iii-sharingof-data-in-application-common-objects
NO.73 Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)
A. It is integrated with the SQL Access Advisor.
B. It predicts the impact of system changes on SQL workload response
time.
C. It provides before and after execution statistics for each SQL
statement in the analysis task
D. It offers fine-grained analysis of all the SQL statements in the
analysis task as a group.
E. SQL statements that were originally run concurrently are run concurrently by SPA.
Answer: B,D
Reference:
https://www.oracle.com/technetwork/database/manageability/spa-ow09-131455.pdf
(4)
NO.74 Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:
Which three are true? (Choose three.)
A. Application PDBs that are subsequently created in the APP1
application container will be clonedfrom APP1$SEED.
B. An application seed PDB is created for APP1.
C. An application root PDB is created for APP1.
D. A default service is created for the application root APP1.
E. Application PDBs that are subsequently created in the APP1
application container will be clonedfrom PDB$SEED.
F. APP1 can never be unplugged.Answer: A,B,E
NO.75 Which two are true about the Automatic Database Diasnostic Monitor
(ADDM)? (Choose two.)
A. It analyzes a period of time corresponding to the 12 hours of
activity.
B. It runs automatically after each AWR snapshot.
C. A DBA can run it manually.
D. Results are written to the alert log.
E. It analyzes a period of time corresponding to the last day of
activity.Answer: B,C
NO.76 Which three are true about monitoring waits for sessions and
services? (Choose three.)
A.
V$SESSION_EVENT displays
all waits for all past and existing sessions if the wait has occurred at least
once for a session.
B.
V$SERVICE_EVENT displays
all waits for all services if the wait has occurred at least once for a
service.
C.
V$SESSION_WAIT_CLASS
displays waits broken down by wait class only for waiting sessions.
D.
V$SESSION_WAIT and V$SESSION both contain details of the event on which a
non-waiting session last waited.
E.
V$SESSION_EVENT displays
all waits for all past sessions if the wait has occurred at least once for a
session.
F.
V$SESSION_WAIT and
V$SESSION both contain details of the event on which a session is currently
waiting.
Answer: B,D,E
NO.77 The USERS tablespace consists of data files 3 and 4 and must always
be online in read/write mode.
Which two are true about using RMAN to
perform an open database back up of this tablespace?
(Choose two.)
A. Backups must be done incrementally.
B. Backups must be contained in backup sets.
C. Backups can be taken only if the database is in ARCHIVELOG mode.
D. Backups can be done incrementally.
E. The database must be registered in an RMAN catalog.
F. Only consistent backups can be created.
Answer: C,E
NO.78 Automatic Shared Memory Management is disabled for one of your
database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?
A. Run the SQL Access Advisor.
B. Run the Memory Advisor for the shared pool.
C. Run the SQL Tunning Advisor.
D. Run the Memory Advisor for the Program Global Area.
E. Run the Memory Advisor for the System Global Area.Answer: B
NO.79 Examine this command:
$ rhpctl move database -sourcehome
Oracle_home_path -destinationhome Oracle_home_path For which two purposes can
you use this command? (Choose two.)
A. to switch an existing Oracle Database home to a newer release of
Oracle software on the sameserver
B. to switch to a read-only Oracle home
C. to switch back to the previous Oracle home as part of a rollback
operation
D. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
E. to switch to a patched Oracle Database home Answer: C,E
Explanation:
You can
use rhpctl move gihome command with the same syntax to switch from the current
Oracle Grid Infrastructure home to a patched home. The rhpctl command enables
you to switch from your current Oracle Grid Infrastructure or Oracle Database
home to patched Oracle home so that you can provision the new Oracle home as
gold image. You can also use the rhpctl command to switch back to the old
Oracle home, if you want to roll back the operation.
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/18/cwadd/rapid-homeprovisioning.html#GUID-856C7378-2510-4B3E-8BE1-B4D79DF4FE8B
NO.80 Which three are true about upgrading Oracle Grid Infrastructure?
(Choose three.)
A. A direct upgrade can be performed only from the immediately
preceding Oracle GridInfrastructure version.
B. The newer version is installed in a separate Oracle Grid
Infrastructure home on the same server asthe existing version.
C. An existing Oracle base can be used.
D. The upgrade process will automatically install all mandatory patches
for the current version ofOracle Grid Infrastructure.
E. Existing Oracle Database instances must be shut down before starting
the upgrade.
F. Only the grid user can perform the upgrade
Answer: D,E,F
Reference:
https://docs.oracle.com/database/121/CWLIN/procstop.htm#CEGEDCDB
NO.81 Your CDB has two regular PDBs as well as one application container
with two application PDBs and an application seed No changes have been made to
the standard PDB$SEED.
How many default temporary tablespaces can
be assigned in the CDB?
A. three
B. eight
C. seven
D. six
E. five
Select three options, any one of which is
required for it to execute successfully. (Choose three.)
A. Add the FILE_NAME_CONVERT clause to the statement and set the
PDB_FILE_NAME_CONVERTparameter.
B. Add only the CREATE_FILE_DEST clause to the statement.
C. Set only the PDB_FILE_NAME_CONVERT parameter.
D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
E. Enable only OMF.
F. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
Answer: B,D,E
NO.84 Which two are true about RMAN duplexed backup sets? (Choose two.)
A.
A duplexed backup set uses
the same number of SBT channels as a non-duplexed backup set forthe same number
of files.
B.
A non-duplexed backup set
written to disk can be duplexed to disk by backing up the backup setthat is
already on disk.
C.
A non-duplexed backup set
written to SBT can be duplexed to tape by backing up the backup setthat is
already on tape.
D.
A non-duplexed backup set
written to disk can be duplexed to tape by backing up the backup setthat is
already on disk.
E.
A non-duplexed backup set
written to SBT can be duplexed to disk by backing up the backup setthat is
already on tape.
F.
A duplexed backup set
always uses twice as many SBT channels as a non-duplexed backup set forthe same
number of files. Answer: D,F
NO.85 Examine these queries and their output:
After a system crash, an instance restart
and an attempted opening of the PDBs result in:
Which two are true? (Choose two.)
A. Data file 24 can be recovered while PDB2 is opened.
B. Data file 24 must be recovered while the CDB is opened.
C. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are
opened.
D. Data file 24 cannot be recovered while the CDB is opened.
E. Data
file 24 must be recovered while PDB2 is closed.
19c: PDB
SYSTEM or UNDO Tablespace Recovery: The CDB and all other PDBs can be left
opened. 1. Connect to PDB 2. Shutdown abort the PDB, if its not automatically
done. sqlplus sys@sales_pdb as sysdba sql> SHUTDOWN ABORT; OR ALTER
PLUGGABLE DATABASE CLOSE ABORT; rman target sys@slaes_pdb rman> restore
database; rman> recover database; rman> alter pluggable database
sales_pdb open;
Answer: A,B
NO.86 Which three are true in Oracle 19c and later releases? (Choose
three.)
A. If the password file location changes, then the new location is used
automatically by the OracleServer.
B. Schema Only accounts can be granted administrator privileges.
C. All the Oracle-supplied accounts are Schema Only accounts.
D. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault
E. Unified Auditing can be configured to audit only events that are
issued indirectly by an audited user.
F. Unified Auditing can be configured to audit only events that are
issued directly by an audited user. Answer: B,C,D
Reference:
https://mandysandhu.com/2018/04/30/oracle-database-18c-schema-only-accounts/
NO.87 Which two are true about changing the LOCAL_UNDO_ENABLED property
to false in a CDB? (Choose two.)
A. After the change, only a common user with the required privilege can
create an undo tablespacein CDB&ROOT.
B. Any new PDB and existing PDBs are automatically configured to use
the default undo tablespace inCDB$ROOT.
C. After the change, only one undo tablespace can exist in CDB$ROOT.
D. After the change, any user with the required privilege can create an
undo tablespace in the PDBs.
E. Undo tablespaces existing in PDBs must be dropped before the change.
F. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
Answer: B,C
Explanation:
You can set a CDB in local UNDO mode
either at CDB creation or by altering the CDB property. When the database property
LOCAL_UNDO_ENABLE is FALSE, which is the default, there is only one UNDO
tablespace that is created in the CDB root, and that is shared by all
containers. When
LOCAL_UNDO_ENABLE is TRUE, every container
in the CDB uses local undo and each PDB must have its own local UNDO
tablespace. To maintain ease of management and provisioning, UNDO tablespace
creation happens automatically and does not require any action from the user.
When a PDB is opened and an UNDO tablespace is not available, its automatically
created.
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/creating-and-configuring-acdb.html#GUID-12ADA04D-F81D-4579-A68C-0958CC7D6C2F
NO.88 Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
A. By default, AWR snapshots are taken every 60 minutes.
B. Its collection level is determined by the value of the
STATISTICS_LEVEL database parameter.
C. By default, AWR snapshots are retained for 7 days.
D. The taking of AWR snapshots can be disabled.
E. AWR data is stored in the SYSTEM tablespace.
Answer: A,B,D
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
NO.89 Which three are true about opatchauto? (Choose three.)
A.
It
performs a shutdown and then a restart of all processes in both Oracle Grid
Infrastructure andOracle Database home during the patching process.
B. It must be invoked by a user with root user privileges.
C. Patches are applied via opatchauto.
D. Users must always input patch plans to opatchauto.
E. It requires the Oracle Grid Infrastructure and Oracle Database
instances to be shut down beforebeing invoked.
F. It applies patches in nonrolling mode by default.
G. It is used to apply interim patches to Oracle Grid Infrastructure
and Oracle Database homecombinations.
Answer: A,B,C
NO.90 Which three methods can be used for heap table data migration after
upgrading a database? (Choose three.)
A. using Database Replay
B. using SQL Developer
C. using Oracle Data Pump
D. using operating system file copy utilities
E. using Database Upgrade Assistant
F. using the CREATE TABLE AS SELECT SQL statement
Answer: D,E,F
NO.91 Which three are true about Recovery Manager (RMAN) in Oracle
Database 19c and later releases? (Choose three.)
A. It is only possible for RMAN to connect to a pluggable database as a
target if an RMAN VirtualPrivate Catalog is used.
B. It is always possible for RMAN to connect to a pluggable database as
a target if any RMAN Catalogis used.
C. A Virtual Private Catalog used to register a container database must
be created in a pluggabledatabase.
D. A Virtual Private Catalog used to register a container database can
be created in a pluggabledatabase.
E. It is always possible for RMAN to connect to a pluggable database as
a target.
F.
A
Virtual Private Catalog used to register a container database can be created in
a non-containerdatabase.
Answer: D,E,F
NO.92 Which two are true about Oracle instance recovery? (Choose three.)
A. Recovery begins from the beginning of the CURRENT redo log group.
B.
Recovery begins from the
last checkpoint position that was calculated by the Database Writerbefore
instance failure.
C.
Recovery begins from the
start of any ACTIVE redo log group or the start of the CURRENT loggroup if no
other group is ACTIV
D.
Recovery reads redo until
the end of the redo thread. SMON rolls back any dead transactions, andthen the
datanase is opened.
E.
Recovery reads redo until
the end of the redo thread, and then opens the database. SMON thenrolls back
any dead transactions.
F. Recovery begins from the last checkpoint position that was recorded in the control file by thecheckpoint process (CKPT).
Answer: B,D,E
NO.93 Which three are true about Automatic Workload Repository (AWR),
Automatic Database
Diagnostic Monitor (ADDM), and the
Manageability Monitor (MMON) background process? (Choose three.)
A. ADDM can recommend shrinking the buffer cache.
B. ADDM can recommend extending the buffer cache.
C. By default, MMON creates an AWR snapshot every 30 minutes.
D. ADDM performs its analysis only when a DBA requests it.
E. By default, AWR snapshots are automatically purged after eight days.
F. AWR snapshots must be deleted when no longer required by ADDM.
Answer: A,E,F
B. Stateless alerts can be purged manually from the alert history.
C. Stateless alerts can be cleared manually.
D. Stateless alerts are automatically cleared.
E. Stateful alerts are purged automatically from the alert history.
Answer: B,C
Explanation:
Except for the tablespace space usage
metric, which is database related, the other metrics are instance related.
Threshold alerts are also referred to as stateful alerts which are
automatically cleared when an alert condition clears. Stateful alert appears in
DBA_OUTSTANDING_ALERTS and when cleared go to DBA_ALERT_HISTORY. Other
server-generated alerts correspond to specific database events such as ORA-*
errors, "Snapshot too old" errors, Recovery Area Low on Free Space,
Resumable Session Suspended. These are non threshold based alerts, also
referred to as stateless alerts. Stateless alerts go directly to the History
table. +++ Most alerts (such as "Out of Space") are cleared
automatically when the cause of the problem disappears. However, other alerts
(such as generic alert log errors) are sent to you for notification and must be
acknowledged by you. After taking the corrective measures, you acknowledge an
alert by clearing or purging it. Clearing an alert sends the alert to the Alert
History which is accessible from Monitoring sub menu. Purging an alert removes it
from the Alert History.
Reference:
https://jameshuangsj.wordpress.com/2019/12/01/clears-stateless-alerts-in-oem-by-using-emcli/
NO.95 For which two requirements can you use the USER_TABLESPACE clause
with the CREATE
PLUGGABLE DATABASE command? (Choose two.)
A. to specify a default tablespace in a PDB cloned from another PDB in
the same CDB.
B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when
plugging in a PDB
C. to include specific user tablespaces only when relocating a PDB
D. to specify the list of user tablespaces to include when moving a
non-CDB to a PDB
E. to exclude a temp tablespace when plugging in a PDB
F. to specify the list of tablespaces to include when creating a PDB from the CDB seed
Answer: B,D
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/creating-and-removingpdbs-with-sql-plus.html#GUID-1C47D543-8376-48AE-A1AE-632316731D59
NO.96 Which three are true about an application container?
A. It must have an application root PDB.
B. It can contain multiple applications.
C. An application PDB can belong to multiple application containers.
D. Two application containers can share an application seed PDB.
E. It can contain a single application.
F. It must have an application seed PDB.
Answer: B,D,E
NO.97 Which two are true about Oracle instance recovery? (Choose three.)
A. Recovery begins from the beginning of the CURRENT redo log group.
B.
Recovery begins from the
last checkpoint position that was calculated by the Database Writerbefore
instance failure.
C.
Recovery begins from the
start of any ACTIVE redo log group or the start of the CURRENT loggroup if no
other group is ACTIVE.
D.
Recovery reads redo until
the end of the redo thread. SMON rolls back any dead transactions, andthen the
datanase is opened.
E.
Recovery begins from the
last checkpoint position that was recorded in the control file by thecheckpoint
process (CKPT).
F.
Recovery
reads redo until the end of the redo thread, and then opens the database. SMON
thenrolls back any dead transactions.
Answer: B,D,F
NO.98 Which two are true about automatic block repair? (Choose two.)
A. Automatic block repair can repair blocks with no standby database if
DB_BLOCK_CHECKING =TRUE.
B. Real-Time Query must be enabled on a physical standby database for
automatic block repair to bedone on that physical standby database.
C. Real-Time Query must be enabled on a primary database for automatic
block repair to be done onany of its physical standby databases.
D. It is not possible for media corrupt blocks.
E. Real-Time Query must be enabled on a physical standby database for automatic block repair to bedone on its primary database.
Answer: B,C
Website không bao giờ chứa bất kỳ quảng cáo nào, mọi đóng góp để duy trì phát triển cho website (donation) xin vui lòng gửi về STK 90.2142.8888 - Ngân hàng Vietcombank Thăng Long - TRAN VAN BINH
=============================
Nếu bạn muốn tiết kiệm 3-5 NĂM trên con đường trở thành DBA chuyên nghiệp thì hãy đăng ký ngay KHOÁ HỌC ORACLE DATABASE A-Z ENTERPRISE, được Coaching trực tiếp từ tôi với toàn bộ kinh nghiệm, thủ tục, quy trình, bí kíp thực chiến mà bạn sẽ KHÔNG THỂ tìm kiếm trên Internet/Google giúp bạn dễ dàng quản trị mọi hệ thống Core tại Việt Nam và trên thế giới, đỗ OCP.
- CÁCH ĐĂNG KÝ: Gõ (.) hoặc để lại số điện thoại hoặc inbox https://m.me/tranvanbinh.vn hoặc Hotline/Zalo 090.29.12.888
- Chi tiết tham khảo:
https://bit.ly/oaz_w
=============================
2 khóa học online qua video giúp bạn nhanh chóng có những kiến thức nền tảng về Linux, Oracle, học mọi nơi, chỉ cần có Internet/4G:
- Oracle cơ bản: https://bit.ly/admin1_1200
- Linux: https://bit.ly/linux_1200
=============================
KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH:
📧 Mail: binhoracle@gmail.com
☎️ Mobile/Zalo: 0902912888
👨 Facebook: https://www.facebook.com/BinhOracleMaster
👨 Inbox Messenger: https://m.me/101036604657441 (profile)
👨 Fanpage: https://www.facebook.com/tranvanbinh.vn
👨 Inbox Fanpage: https://m.me/tranvanbinh.vn
👨👩 Group FB: https://www.facebook.com/groups/DBAVietNam
👨 Website: https://www.tranvanbinh.vn
👨 Blogger: https://tranvanbinhmaster.blogspot.com
🎬 Youtube: https://www.youtube.com/@binhguru
👨 Tiktok: https://www.tiktok.com/@binhguru
👨 Linkin: https://www.linkedin.com/in/binhoracle
👨 Twitter: https://twitter.com/binhguru
👨 Podcast: https://www.podbean.com/pu/pbblog-eskre-5f82d6
👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội
=============================
oracle tutorial, học oracle database, Tự học Oracle, Tài liệu Oracle 12c tiếng Việt, Hướng dẫn sử dụng Oracle Database, Oracle SQL cơ bản, Oracle SQL là gì, Khóa học Oracle Hà Nội, Học chứng chỉ Oracle ở đầu, Khóa học Oracle online,sql tutorial, khóa học pl/sql tutorial, học dba, học dba ở việt nam, khóa học dba, khóa học dba sql, tài liệu học dba oracle, Khóa học Oracle online, học oracle sql, học oracle ở đâu tphcm, học oracle bắt đầu từ đâu, học oracle ở hà nội, oracle database tutorial, oracle database 12c, oracle database là gì, oracle database 11g, oracle download, oracle database 19c, oracle dba tutorial, oracle tunning, sql tunning , oracle 12c, oracle multitenant, Container Databases (CDB), Pluggable Databases (PDB), oracle cloud, oracle security, oracle fga, audit_trail,oracle RAC, ASM, oracle dataguard, oracle goldengate, mview, oracle exadata, oracle oca, oracle ocp, oracle ocm , oracle weblogic, postgresql tutorial, mysql tutorial, mariadb tutorial, ms sql server tutorial, nosql, mongodb tutorial, oci, cloud, middleware tutorial, hoc solaris tutorial, hoc linux tutorial, hoc aix tutorial, unix tutorial, securecrt, xshell, mobaxterm, putty
