1、Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and
A)Space is only reclaimed when there is space pressure in the Fast Recovery Area(FRA)
B)Space is always reclaimed automatically when the retention period for Flashback logs is
C)Space might be reclaimed proactively before space pressure occurs
D)Space is always reclaimed proactively before space pressure occurs
E) Space might be reclaimed automatically when the retention period for Flashback logs is
2、Which two are true about server-generated alerts?
A)Stateless alerts can be cleared manually
B)Stateless alerts are automatically cleared after one day.
C)Stateful alerts are purged automatically from the alert history after one day
D)Stateless alerts can be purged manually from the alert history.
E) Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.
3、Which three are true about upgrading Oracle Grid Infrastructure?
A)The newer version is installed in a separate Oracle Grid Infrastructure home on the same server
as the existing version
B)A direct upgrade can be performed only from the immediately preceding Oracle Grid
C) The upgrade process will automatically install all mandatory patches for the current version of
Oracle Grid Infrastructure
D) Only the grid user can perform the upgrade
E) Existing Oracle Database instances must be shut down before starting the upgrade
F）An existing Oracle base can be used.
4、Which two are true about the Program Global Area(PGA)and its management in an Oracle
A)PGA AGGREGATE LIMII is a hard limit on the PGA size for any one session
B)The entire PGA is located in the System Global Area(SGA)when using shared servers
C)The private SQL area(UGA)is located in the System Global Area(SGA)when using shared
D)Sorts and Hash Joins use PGA memory.
E) The private SQL area(UGA)is located in the System Global Area(SGA)when using dedicated
5、You plan to perform cross-platform PDB transport using XTTS.
Which two are true?
A)A backup of the PDB must exist, taken using the BACKUP command with the ro PLATFORM
B) The source PDB can be in MOUNT or OPEN state
C)The source PDB must be in MOUNT state.
D) The source PDB must not be an application root.
E) Automatic conversion of endianess occurs.
F) The source and target platforms must have the same endianess
6、Which two are true about the automatic execution of operating system scripts when performing
silent mode installation starting from Oracle Database 19c?
A) The installer will prompt for the root or sudo password
B)Silent install always runs operating scripts automatically.
C) The response file can specify the root or sudo password
D)The response file must contain the root or sudo password
E) The response file can specify the path of the sudo program
7 、Which three actions will add a resource to an Oracle Restart configuration?
A)creating a database service using Oracle Database Configuration Assistant(DBCA)
B)creating a disk group using the CREATE DISKGROUP SQL statement
C) creating a database using the CREATE DATABASE SQL statement
D)creating an Oracle Database service by modifying the SERVICE NAMES parameter
E)creating an Oracle Automatic Storage Management(AM)instance with ASM Configuration
F ) creating a database service using DBMS SERVICE CREATE SERVICE
8、How do you configure a CDB for local undo mode?
A)Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace Execute AI TER DAMBASE LOCAL UNDO ON in each PDB. and then restart the CDB instance
B)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.
C) Open the CDB instance in upgrade mode. In CDB&ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance
D) 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
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.
9 、Which three activities are possible for PDBS?
A) converting an application PDB to a regular PDB
B) converting an application PDB to an application seed
C) converting a regular PDB to an application PDB
D) copying an application container into another application container in the same CDB
E) converting an application seed to an application PDB
F) converting an application PDB to an application root
G) copying an application container into another application container in a different CDB
10、A user complains about poor database performance
You want to verify if the user's session has waited for certain types of I/O activity
Which view displays all waits waited on by a session at least once?
B) V$SESSION WAIT
C) V$SESSION EVENT
E) V$SESSION WAIT CLASS
11、 Which two are true about RMAN duplexed backup sets?
A) They can be written to media
B They can be created only by using the copies option of a BACKUP command
C) They can be created by using the RMAN CONFIGURE command to specify duplexing before
taking a backup
D) They can be written only to disk.
E) They must be written to media
12 、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. STARUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABASE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABASE OPEN
10. ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database
13、A schema owner truncated a table in error and must recover the data
Which Oracle Flashback feature could be used to recover the data?
A)FLASHBACK VERSION QUERY
B) FLASHBACK TABLE
D) FLASHBACK DATABASE
E) FLASHBACK DATA ARCHIVE
14、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?
A) Disable FORCE LOGGING for the database
B) Enable asynchronous disk I/O
C) Increase the size of the database buffer cache.
D)Increase the level of RMAN multiplexing
E) Increase the size of tape I/O buffers
15、 Which two are true about Oracle instance recovery?
A) Recovery begins from the beginning of the CURRENT redo log group.
B) Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT
log group if no other group is ACTIVE
C) Recovery begins from the last checkpoint position that was recorded in the control file by the
checkpoint process (ckpt)
D) Recovery begins from the last checkpoint position that was calculated by the Database Writer
before instance failure
E) Recovery reads redo until the end of the redo thread, and then opens the database. SMON then
rolls back any dead transactions
F) Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions,
and then the database is opened
16、Which three are true about recovering tables using RMAN?
A) RMAN can recover tables in the SYSAUX tablespace
B) RMAN always uses an auxiliary instance
C) RMAN can recover a table after a DDL operation has altered the table structure.
D) RMAN can recover tables owned by the sys user.
E) RMAN can recover tables in the SYSTEM tablespace
F) RMAN can recover tables in a standby database
G) RMAN can recover tables owned by the SYSTEM user.
17、Which two are true about creating RMAN backups for an Oracle container database?
A) Control file backups can be created while connected to cdb$root
B) The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is
connected to CDB$ROOT
C) Online Redo Log backups can be created while connected to CDB$ROOT.
D) Control file backups can not be created while connected to a PPB.
E) Archived Redo Log backups can be created while connected to PDB
18、Which two are true about creating pluggable databases(PDBS)in Oracle 19c and later releases?
A) A PDB snapshot depends on an existing storage snapshot of the source PDB
B) A PDB snapshot can be a full copy of a source PDB
C) A PDB snapshot can be a sparse copy of a source PDB
D) A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB
E) A snapshot copy PDB can be a full copy of a source PDB
19、In which two situations can you use Database Upgrade Assistant?
A) when the operating system(OS)needs to be changed as part of the upgrade
B) when multiple pluggable databases in a container database have to be upgraded in a specific
C)when the hardware platform needs to be changed as part of the upgrade
D) when a character set conversion is required during the upgrade
E) when the target and source database are on the same platform
20、Which three are true in Oracle 19c and later releases?
A) Simultaneous data pump jobs can be limited at the pluggable database(PDB) level
B) An ordinary data pump export of a table with encrypted columns will always encrypt the same
columns when imported
C) Tablespaces always remain in read/write mode during transportable tablespace operations
D) A transportable data pump import can leave a plugged-in tablespace in read/write mode.
E) Tablespaces never remain in read/write mode during transportable tablespace operations
F) A transportable data pump import can leave a plugged-in tablespace in read-only mode
21、Which three are true about patchsets?
A) They are only released quarterly
B) They are installed via Opatch or Opatchauto.
C) A base release is not needed to install patchsets.
D) They can introduce new features
E) They can be applied in a rolling fashion for Clusterware and the databases
F) Installing a patchset is considered an upgrade.
22 、 Which three are true about recovery operations done without using Recovery
A) A lost SPFILE can be recovered from memory using SQL*PLUS
B) A lost password file can be re-created with SQL*PLUS.
C) A lost password file can be manually re-created with the orapwd utility
D) A lost index tablespace can be re-created without performing any recovery
E) A lost TEMPFILE must always be re-created manually.
F) A lost PFILE can be re-created from alert log using SOL*PLUS
23、Which two are true about Optimizer Statistics?
A) They are ignored by Optimizer if they are stale.
B) They provide real-time data about schema objects
C) By default, they are automatically gathered by a maintenance job
D) They are gathered by the SQL Tuning Advisor
E) They can be gathered by the DBMS_STATS package
24、Which three are true about interpreting Recovery Manager(RMAN)error stacks returned to
A) If an RMAN command fails, the output will only identify the command that failed
B) If an RMAN command fails, the output will identify the channel ID where the failure occurred.
C) Media Management errors appear as a line with"sbtio
D) Some messages in the error stack are not errors
E) Media Management errors appear as a line with"Additional information and a number.
F) Media Management errors appear as a line with"sbtio and a number.
25、In performance management, which two factors might reduce the ability of an application to
scale to a larger number of users?
A) the number of data files containing extents belonging to tables updated by a transaction
B) issuing multiple savepoints during a transaction
C) poorly written SQL
D) poorly trained users who do not commit transactions
E) the number of tablespaces containing tables updated by a transaction
26、Which three are true about block media recovery?
A) The target database for which one or more blocks are to be recovered must be in the OPEN
B) The data file containing the block being recovered remains online
C) It cannot repair logical corruption
D) It can be performed on noncorrupt blocks
E) A block being recovered is not accessible
F) To use it, Flashback Database must be enabled
27、You issued this command
RMAN> BACKUP RECOVERY AREA FORCE
Which three are true?
A) All Oracle recovery files normally written to the FRA and which have been backed up already
to the current FRA are backed up
B) All files in any previous FRA that have not yet been backed up, are backed up
C) All Oracle recovery files normally written to the FRA and which have not yet been backed, are backed up
D) All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up
E) All files in the current fast recovery area(FRA)that have not yet been backed up, are backed up
F) All files in the current FRA that have been backed up already, are backed up
G) All files in any previous FRA that have been backed up already, are backed up.
28、 Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor(ADDM), and the Manageability Monitor(MMON)background process?
A) AWR snapshots must be deleted when no longer required by ADDM
B) By default, MMON creates an AWR snapshot every 30 minutes.
C) ADDM can recommend extending the buffer cache
D) ADDM can recommend shrinking the buffer cache
E) By default, AWR snapshots are automatically purged after eight days
F ADDM performs its analysis only when a DBA requests it.
29、Which three are true about Automatic Workload Repository (AR)and Automatic Database Diagnostic Monitor(ADDM)in an Oracle multitenant environment?
A) AWR snapshots can be created in CDB$ROOT
B) No AWR data is stored in the CDBSROOT SYSAUX tablespace
C) ADDM can run in a nonroot container
D) All AWR data is stored in the CDBSROOR SYSAUX tablespace
E) AWR snapshots can be created in a PDB
F) AWR reports can be generated while connected to any container
30、Which four are true about duplicating a database using Recovery Manager(RMAN)
A) A connection to an auxiliary instance is always required
B) A connection to the target database 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) Duplication can be done by having the auxiliary database instance pull backup sets from the
target database instance
F) Duplication can be done by having the target database instance push copies to the auxiliary
G)A connection to the recovery catalog instance is always required
H)A backup of the target database is always required.
31、Which are three of the steps taken by Database Configuration Assistant(DBCA )to clone a
remote pluggable database(PDB)starting from Oracle 19c?
A) leaving the cloned PDB in mount state
B) creating a database link from CDBSROOR in the local database to the PDB in the remote
system that is to be cloned
C) creating a database link from CDBSROOR in the local database to CDBSROOR in the remote
system that is to be cloned
D) opening the cloned PDB
E) backing up the cloned PDB
32、Which two are true about the character sets used in an Oracle database?
A) Unicode enables information from any language to be stored using a single character set
B) Unicode is the only supported character set for Oracle databases created using
DatabaseConfiguration Assistant (DBCA)
C) Single-byte character sets provide better performance than multibyte character sets
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.
33、Which three are true about using Database Upgrade Assistant(DBUA)to upgrade a database?
A) Multiple databases with the same ORACLE HOME can be upgraded simultaneously
B) All pluggable databases are automatically upgraded as part of a container database upgrade.
C) DBUA must be launched from the target Oracle Home
D) The Pre-upgrade Information Tool script is executed by DBUA
E) A whole database backup must exist before upgrade
F) The database must be opened in read-only mode.
34、PDB1 and PDB2 are pluggable databases in CDB1
Examine these commands
CDB1 is then restarted
Which three are true?
A) PDB2 will be opened READ WRITE
B）PDB2 will be MOUNTED
C) PDB$SEED will be opened READ ONLY
D) PDB1 will be opened READ WRITE
E) PDB$SEED will be MOUNTED
F)PDB1 will be MOUNED.
35、Which three are true about using Database Resource Manager in an Oracle multitenant
A) A Pdb-level resource plan can limit session PGA memory
B) A Cdb-level resource plan is mandatory when using Pdb-level resource plans
C) A Cdb-level resource plan can limit session CPU utilization.
D) A Cdb-level resource plan can limit PDB UNDO use
E) Pdb-level resource plans can limit uncommitted UNDO per consumer group
F) A Cdb-level resource plan can limit PDB CPU utilization.
36、Which three are true about the FLASHBACK DATABASE feature?
A) It always generates REDO and UNDO
B) It requires that the target database be in ARCHIVELOG mode
C) FLASHBACK DATABASE only uses FLASHBACK Logs to get the database to the desired
D) FLASHBACK LOGS are archived after a log switch
E) A database can be flashedback using SQL*PLUS
F) Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for
37、Which should be tuned first when doing a performance tuning exercise for an Oracle Database
A) log writer performance
B) SQL statements
C) database instance memory management and sizes
D) general operating system health
E) database writer performance
38、Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?
A) It can be used to deploy Grid Infrastructure homes, including Oracle Restart.
B) It is an Oracle Grid Infrastructure service
C) It is an Oracle Database service
D) It cannot be used to provision middleware.
E) It cannot be used to provision applications
F) It can be used to deploy Oracle Database homes.
39、You want to transport the UNIVERSIRY tablespace from one database to another.
The universiry tablespace is currently open read/write
The source and destination platforms have the same endian format.
Examine this list of steps:
1. Make the UNIVERSIRY tablespace read-only on the source system
2. Export the UNIVERSIRY tablespace metadata using EXPDP
3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DAMAPUMP clause
4. Copy the cross-platform backup sets to the destination system
5. Copy the Data Pump dump set from the source to the destination system
6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the pamapump clause
7. Import the UNIVERSIRY tablespace metadata using IMPDP
8. Make the UNIVERSIRY tablespace read/write on the destination system Which are the minimum number of steps required, in the correct order, to transport the UNIVERSIRY tablespace?
40、A database is configured in ARCHIVELOG mode
A full RMAN backup exists but no control file backup to trace has been taken
A media failure has occurred
In which two scenarios is incomplete recovery required?
A) after losing all copies of the control file
B) after losing a sysaux tablespace data file
C) after losing all members of the CURRENT online redo log group
D) after losing all members of an INACTIVE online redo log group
E) after losing an UNDO tablespace that is in use
41、Which three are true about an application container?
A) It can contain a single application
B) It can contain multiple applications
C) Two application containers can share an application seed PDB
D) An application PDB can belong to multiple application containers
E) It must have an application root PDB
F) It must have an application seed PDB
42、Which two are true about backup set compression using RMAN default compression?
A) Compressed backups cannot have a section size defined
B) Unused blocks below the high water mark are backed up
C) Binary compression adds CPU overhead to backup operations
D) Compressed backups can be written only to media
E) Compression can be done only for locally managed tablespaces
43、Which three are true about Automatic Workload Repository (AWR)snapshots?
A) They can be retained forever
B) They are generated if statistics LEVEL is set to ALL.
C) They are always created manual
D) They are generated if statistics LEVEL is set to BASIC.
E) They are always created automatically.
F) They are generated if statistics LEVEL is set to TYPICAL
44、Which two are true about duplicating pluggable databases(PDBS) with RMAN?
A) CDB$ROOT and PDBSSEED are automatically duplicated if a PDB is duplicated
B) A user with SYSDBA or SYSBKUP must use RMAN logged in to a PDB in order to duplicate it.
C) Two or more PDBS can be duplicated with the same RMAN DUPLICATE command
D)The auxiliary instance is automatically created with ENABLE PLUGGABLE DATABASE TRUE
E) All tablespaces belonging to a PDB must be duplicated when duplicating the PDB
45、Examine this configuration
Which table or set of tables will exist after the Flashback operation has completed?
A) none of the tables, because all three tables will be dropped
B) CDB1_TAB and APP_PDB1_TAB
C) CDB1_TAB and APP ROOT_TAB
D) CDB1_TAB only
E) CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
Which two are true?
A) PDB1 C2 SRY will be created and started automatically
B) PDB1 C2 SRV will be created but not started
C) PDB1 will be created in CDB2 and automatically opened.
D) PDB1 C1 SRV in CDBL will be renamed PDB1 C2 SRV
E) PDB1 will be created in CDB2 and left in MOUNT state.
47、Which three capabilities require the use of the RMAN recovery catalog?
A) using the REPORT SCHEMA command to list a databases current data files and tablespaces
B) using the KEEP FOREVER clause with the BACKUP command
C) creating encrypted backups
D) creating customized reports about a single databases backups
E) using the REPORT SCHEMA command to list a databases data files and tablespaces at times in the past
F) using RMAN stored scripts
48、Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:
Which three are true about PDB1?
A) It has no local users
B) It has only local roles
C) It has the same number of roles as CDB1.
D It has the same common users defined as does CDB1
E) It is in mount state after creation
F) Service PDB1 is created for remote logins to PDB1
49、Which two are true about various Oracle security and auditing capabilities
A) Application-common Transparent Security Data Protection(TSDP)policies can be created only
if all the PDBS in the application container are closed
B) Unified auditing can be automatically synchronized to all application PDBS in an application container
C) Application-common OLS policies can be created only if all the PDBS in the application container are closed
D) Fine-grained auditing (FGA )policies in an application root are automatically synchronized to all application PDBS contained in the application container when they are updated
E) Application-common TSDP policies are always container specific.
50、Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?
A) It is a set of recommendations by the optimizer to create new indexes
B) It is a set of recommendations by the optimizer to change the access methods used
C) It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders
D) It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans
E) It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error
51、Which three are true about performing an Oracle Database install on Linux?
A) It can be done after installing Grid Infrastructure for a Standalone Server
B) It allows you to select the languages supported by the Oracle database server.
C) The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner the Oracle Inventory group, and an Oracle administrative privileges group.
D) It can be done before installing Grid Infrastructure for a Standalone Server
E) The runfixup. sh script can install missing RPMS
F) The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
G) The Oracle database administrator must be granted access to the root operating system account to run root privileged scripts
52、Which three are true about a whole database backup?
A) It can be created only by using RMAN
B) It is the only possible backup type for a database in NOARCHIVELOG mode
C) It can be consistent.
D) It can consist of either backup sets or image copies.
E) It can be inconsistent
F) It always includes all data files, the current control file, the server parameter file, and archived redo logs.
53 、 Which three resources are always shared among CDB$ROOT and pluggable databases( PDBS)?
A) the log writer process(LGWR)
B) Undo tablespaces
C) temporary tablespaces
D) the data dictionary in CDB$ROOT
E) the Process Monitor Process(PMON)
F) SYSAUX tablespaces
54、which three are true about the tools for diagnosing Oracle Database failure situations?
A)The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it
B) The ADR command-line utility (ADRCI)can package incident information to send to Oracle Support.
C) The ADR can store metadata in an Oracle Database repository.
D) Flashback commands help with repairing physical errors.
E) The Data Recovery Advisor uses the ADR
F RMAN can always repair corrupt blocks
55、Which three are true about RMAN archival backups with the RESTORE POINT clause?
A) Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored
B) The SPFILE is included in the archival backup.
C) The ARCHIVAI attribute for a backup overrides the RMAN retention policy
D) They are never considered obsolete by RMAN
E) They can optionally be written to a fast recovery area(FRA).
F) All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database
G)Use of a recovery catalog is always required to support the creation and use of archival backups
56、Which three are true about backing up the control file?
A) It gets backed up automatically by RMAN when the BACKUP SPFILE command is used
B) It gets backed up automatically by RMAN as a trace file containing SQL statements for control file re-creation when a database backup occurs
C) It can get backed up automatically as a binary copy.
D) It can be backed up manually as a binary copy.
E) It cannot be backed up manually as a binary copy.
F) It can be backed up manually as a trace file containing SQL statements for control file re-creation
57、You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer （OUI)
There is no existing Oracle installation on the server.
Which two are prerequisites?
A) the Oracle Inventory group oinstall
B) the installation of Oracle ASMLIB
C) an operating system user to own this installation
D) a group called dba
E) an operating system account called grid
58、RMAN has just been connected to a target database and the recovery catalog database
In which two cases would an automatic full resynchronization occur between this target databases control file and the RMAN recovery catalog?
A) when control file metadata for archive log backups or image copies has been overwritten in the target databases control file due to being older than CONTROL FILE RECORD KEEP TIME
B) when control file metadata for data file backups or image copies has been overwritten in the target databases control file due to being older than CONTROL FILE RECORD KEEP TIME
C) when a backup of the current control file is created
D) when the target is first registered
E) when a new tablespace is added to a registered target database
59、Which three are true about post-upgrade activities when upgrading an Oracle database using
Database Upgrade Assistant?
A) After a manual upgrade, TNSNAMES. ORA entries must be updated to reflect the new ORACLE HOME
B) The new extended data type capabity must be enabled by running the utlrp. sql script
C) The Oracle Application Express configuration should be updated after upgrading Oracle Database
D) Any Recovery Manager(RMAN)recovery catalog must be upgraded manually
E) Time zone files must be upgraded manually using the DBMS DST PL/SQL package.
60、A container database, CDB1, contains a pluggable database PDB1 Another container database is called CDB2
You want to relocate PPB1 from CDB1 to CDB2 with near-zero down time
Which three are required?
A) CDB1 must be in shared UNDO mode only
B) CDB2 must be in archivelog mode.
C) CDB1 must be in archivelog mode
D) CDB2 must be in shared UNDO mode only
E) CDB1 and CDB2 must both be in local UNDO mode
F) CDB1 and CDB2 must be in shared UNDO mode
61、Which two are true about an Rpm-based Oracle Database installation?
A) It requires an Unbreakable Linux Network(ULN)subscription
B) It uses a service configuration script to create a single-instance database as part of the installation
C) It performs a software-only Oracle Database installation
D) It includes the Oracle Preinstallation RPM
E) From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance
62、Which three are true about cloning databases into an existing CDB with RMAN?
A) The target and auxiliary instance passwords must be the same.
B) Only one PDB can be cloned at a time
C) Two or more PDBS can be cloned with the same command
A NON-CDB can be cloned into a PDB
E) A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB
F) A user with SYSDBA or SYSBKUP must be logged in with RMAN to the NON-CDB being
cloned when cloning a NON-CDB
63、Which two are true about Lockdown profiles in a container database(CDB)and its pluggable databases(PDBS)?
A) A PDB Lockdown profile can be created in an application root
B) A PDB Lockdown profile can be created in a regular PDB
C) A Lockdown profile created from a base Lockdown profile is never automatically modified if
the profile on which it is based is modified
D) A PDB Lockdown profile can be created in CDB$ROOT
E) A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified
64、Which three are true about the Oracle Optimizer?
A) It can re-optimize execution plans after previous executions detect suboptimal plans
B) It considers the filters in WHERE clauses when generating execution plans for SQL statements
C) It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated
D) It considers object statistics when generating execution plans for SQL statements
E) It updates stale object statistics in the Data Dictionary
F) It obeys all hints.
65、The HR_Root application container must support the execution of a query on a table shared by application local PDBS PDB1 and PDB2, and remote PDB PDB3
Which three are true?
A) A proxy PDB must exist in the application root in the remote CDB
B) A database link must exist in the remote CDB referring to the local CDB
C) A database link must exist in the local CDB root referring to the remote CDB
D) The HR_Root replica must exist in the remote CDB
E) A proxy PDB must exist in the application root in the local CDB
F) PDB3'S application root replica must exist in the local CDB
66、Which two are true about RMAN Multisection backups when a very large data file is divided into four sections?
A) Each of the file sections must be processed serially.
B) The four sections must be image copies
C) The four sections can be created serially
D) The four sections can be created in parallel
E) The four sections must be contained in backup sets
67、Which three are true about Rapid Home Provisioning of Oracle software?
A) It can be used only on nodes with Oracle Grid Infrastructure installed
B) It can be used to patch existing Oracle software installations
C) It can be used to deploy new homes without disrupting active databases.
D) It can be used to upgrade only single-instance databases running on Oracle Restart.
E) It can be used to create templates of Oracle homes as gold images of only Oracle databases
F) It can be used to create a single-instance Oracle Database in an already-installed Oracle home.
68 、 Which three are true about using an RMAN Recovery Catalog with a pluggable
database(PDB)target connection in Oracle Database 19c and later releases?
A) The target PDB must be registered in a Virtual Private Catalog
B) The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog
C) The target PDB must be registered in both the base catalog and the Virtual Private Catalog
D) The target PDB must be registered in a base catalog
E) The base catalog owner must give the Virtual Private Catalog access to metadata for one or
F)The base catalog must be enabled for Virtual Private Catalog use
69、Examine this configuration:
Which is true?
A) It will return an error because creation of a local role is not allowed in CDB$ROOT
B) ROLE1 will be created only in CDBSROOR and App1_ROOT.
C) ROLE1 will be created only in CDBSROOR
D) It will return an error because common roles must start with c##
E) ROLE1 will be created in CDBSROOR, PDB1, App1_ Root, and APP1 PDB1
70、A database is configured in ARCHIVELOG mode
Full RMAN backups are taken daily 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?
A) after losing an archived log from after the most recent backup
B) after losing all copies of the control file
C) after losing the SYSTEM tablespace
D) after losing an archived log from before the most recent backup
E) when any archived log from, before, or after the most recent backup is corrupt
71、Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases?
A) It does not require the setup wizard
B) It can be used to install and upgrade Oracle Database for single-instance and cluster configurations
C) It can be used for both Oracle Database and Oracle Grid Infrastructure installation
D) It uses a single RPM that automatically extracts and installs the Oracle Database software
E) It can only install and configure Oracle Database software. The database has to be create
72、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) Application PDBS in the application container must be unplugged before the application root is unplugged.
C) The application root of an application container should be plugged into the other CDB before its application PDBS are plugged in.
D) Unplugging the application root from a CDB unplugs all its application PDBS.
E) Plugging the application root into a different CDB plugs in all its application PDBS.
F) IT requires only local UNDO mode in the database where the application container will be
73、Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?
A) They can view data from any user-defined tables.
B) They can drop any tablespace
C) They can create any table.
D) They cannot drop tablespaces
E) They can view data from any data dictionary view or dynamic performance view.
F) They cannot create restore points
74、Which two are true about RMAN backups when using a media manager?
A) A media manager is required to create RMAN proxy copies.
B) A media manager always writes RMAN requested backups to tape
C) The media manager layer(MML) routines provided by Oracle support any vendors media management products
D) A media manager is required to create RMAN image copies
E) By default, a request for a proxy copy may result in a backup set being created
75、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?
A) Data file 24 can be restored and recovered while connected to CDB$ROOT
B) Data file 24 can be restored only while connected to PDB2
C) Data file 24 can be recovered only while connected to PDB2
D) Data file 24 can be restored only while connected to CDB$ROOT
E) Data file 24 can be recovered while connected to PDB2
F) Data file 24 can be recovered while connected to CDB$root.
76 Which three are performed by Oracle Automatic Storage Management(ASM)instances?
A) mounting disk groups
B) managing Allocation Units (AUS)for disk group content
C) managing extent allocation for Oracle database segments
D) acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes
E) acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes(DBWR)
F) managing space allocation for Oracle ASM files
77、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 backup
Today is the 26th of August
Which backups will be obsolete?
A) all backups prior to 24th of August
B) all backups prior to 17th of August
C) all backups prior to 10th of August
D) all backups prior to 22nd of August
E) all backups prior to 20th of August
78、Which two are true about Oracle Grid Infrastructure for a Standalone Server?
A) It requires Oracle Automatic Storage Management(ASM)components to be installed separately
B) The CSS daemon runs from the Grid Infrastructure home
C) It can manage database resources on the server where it is installed or on a different server.
D) It supports volume management, file system, and automatic restart capabilities
E) It must be installed before the Oracle database software is installed
79、HR_Root is an application container with the HR App application installed
No application PDBS and no application seed have yet been created in HR_ROOT
An application PDB, PDB1, must be created so that the HR App applications common objects are accessible to it
Which two methods can be used?
A) Create an application seed, synchronize it with HR Root, and then create the PDB1 application PDB
B) Create the PDB1 application PDB and synchronize it with HR ROOT
C) Create an application seed, and install HR APP in it.
D) Create the PDB1 application PDB and synchronize it with PDBSSEED
E) Create the PPB1 application PDB and install HR App in it.
80、Which two are true about instance recovery?
A) It is not possible if an archived log is missing
B)Setting Fasr START Mrrr TARGER to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery
C)It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered
D)Setting FAST START MTTR TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
E) It is performed automatically while the database remains in MOUNT state. Then the database is opened
F) It is performed by the Recovery Writer (RVWR)background process
81、Examine this configuration
1. CDB1 is a container database
2. App1_Root is an application container contained in CDBL
3. App1_Root $SEED is the applcation seed conained in App Root and synchonized with APP1
4. App1_PDB1 and App1_PDB2 are application PDBS contained in App1 ROOT
5. App1_USER App is an application installed in App1_Root at version 1.0
6. USER1 is a common user in App1_Root and all its application PDBS, created when version 1.0
of App1_USER_App was installed
You execute these commands:
A) USER1 can connect to App1 ROOT and APP1 PDB1
B) USER1 can connect only to App1 ROOT
C) USER1 is defined in APP1 PDB2
D) USER1 can connect to APP1 ROOT, App1 ROOTSSEED, and Appl_PDB1
E) USER1 can connect only to App1 PDB1
F) USER1 can connect to CDB1
82、Which two are true about RMAN virtual private catalogs(VPCS)?
A) Each VPC is owned by the recovery catalog schema owner.
B) VPC functionality is enabled by default.
C) Only one target database can be registered in a VPC
D) The RMAN catalog owner can grant access for an already registered database to a new virtual catalog owner
E) RMAN uses Oracle Virtual Private Database(VPD) to implement VPCS
83、Examine this configuration
What is the outcome?
A) It fails because PDBSSEED is in MIGRATE state
B) It fails because PDB2 is not in UPGRADE state
C) Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
D) Only CDB$ROOT and PDB$SEED are upgraded.
E) CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded
F) Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded
84、Which two are true about memory advisors?
A) If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components
B) If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available
C）If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
D) If Automatic Memory Management is enabled, no memory advisors are available.
E) All memory advisors use data from Automatic Workload Repository
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?
A) Data file 24 can be recovered while PDB2 is opened.
B) Data file 24 cannot be recovered while the CDB is opened
C) Data file 24 must be recovered while PDB2 is closed.
D) Data file 24 must be recovered while the CDB is opened.
E) Data file 24 can be recovered while CDB$ROOR and PDB$SEED are opened
86、Which two are prerequisites for using FLASHBACK TABLE?
A) Row Movement must be enabled on the table being flashed back
B) A tables indexes must be set to unusable before issuing the flashback
C) A tables constraints must be disabled before issuing the flashback.
D) The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must
be granted to the user performing the flashback
E) The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must
be granted to the table owner
87、Which two are true about a read-only Oracle home?
A) It contains an image that can be distributed across multiple servers
B) It is enabled by performing a software-only Oracle Database installation and then running the roohctl-enable script
C) It is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script.
D) It requires the Rapid Home Provisioning service.
E) It’s configuration data and log files reside in subdirectories under the Oracle home
88、Which three are true about upgrading an application in an application container?
A) The upgrade can be performed when connected either to cdb$root or to PDB$SEED
B) An application name and version number must be specified to upgrade the application
C) After an application upgrade, the application containers pdbs remain synchronized with the existing application root
D) The upgrade must be performed when connected to CDB$ROOT
E) An application root clone gets created automatically
F) After an application upgrade, the application containers PDBS are automatically synchronized
with the application root clone
89、Examine this output of an export from the current release of an Oracle multitenant database
What is the outcome?
A) It creates a full export of the root container and PDB1
B) It creates a full export of the root container and all open PDBS.
C) It creates a full export of the root container and all PDBS
D) It fails because Data Pump cannot be used while connected to the root container
E) It creates a full export of only the root container
90、Which two are true about SQL Performance Analyzer(SPA)?
A) It offers fine-grained analysis of all the SQL statements in the analysis task as a group
B) It provides before and after execution statistics for each SQL statement in the analysis task.
C) It is integrated with the SQL Access Advisor.
D) SQL statements that were originally run concurrently are run concurrently by SPA
E) It predicts the impact of system changes on SQL workload response time
91、Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies?
A) A new DBID is automatically created for the transported database
B) By default, the transported database will use Oracle Managed Files(OMF)
C) Data files can be converted on the source system
D) Databases can be transported between systems with different endian formats
E) Data files can be converted on the destination system
F) The password file is automatically converted by RMAN.
92、Application PDBS, SALES_App1 and SALES_App2, must be created and they must access common tables of the SALES_App application
Examine these steps:
Which are the minimum required steps in the correct sequence?
93、Which three are true about Oracle Restart?
A) You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) commands
B) It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances
C) It runs from the Oracle Grid Infrastructure home
D) It is used in both clustered and non-clustered environments
E) If you shut down a database instance with sol*plus, Oracle Restart interprets this as a database failure and attempts to restart the instance
F) The Server Control (SRVCTL)utility can be used to start and stop Oracle Restart
94、Some archived log backups have been accidentally deleted from storage
Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups?
A) LIST ARCHIVELOG ALL
B) RESYNC CATALOG
C) CROSSCHECK BACKUP OF ARCHIVELOG ALL
D) LIST ARCHIVELOG
E) REPORT OBSOLETE
95、Examine this configuration
1. cdb1 is a container database
2. There are several pluggable databases(PDBS)in CDB1
5. Each PDB has several tables with referential integrity constraints
6. FLASHBACK DAABASE is ON
7. UNDO RETENTION GUARANTEE is enabled
Multiple undesired multitable changes were made in all the PDBS
Which method can be used to undo the changes using a single command
A) flashback database
B) flashback table and transaction
C) flashback transaction
D) flashback table
E) restore and recover database
96、You must migrate a NON-CDB Oracle 11g Database to a CDB without first performing an upgrade to the NON-CDB User-defined objects are stored in several tablespaces in the NON-CDB
Which three methods can you use?
A) Data Pump transportable tablespaces
B) Data Pump full database export and import
C) Data Pump full transportable database
D) replication using Goldengate
E) cloning the NON-CDB as a PDB
F) the DBMS PDB package
97、Examine this configuration:
In which order will the upgrade occur?
A) CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3
B) CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4
C) CDB$ROOT PDB$SEED, PDB:, PDB3, PDB2, and PDB4
D) CDB$ROOT, PDB2, PDB1, and PDB3
E) CDB$ROOT, PDB1, PDB2, PDB3, and PDB4
98、Which three actions are mandatory post database upgrade?
A) Resetting passwords to enforce case-sensitivity
B) Setting threshold values for tablespace alerts
C) Upgrading user tables that depend on Oracle-maintained abstract data types.
D) Migration to unified auditing
E) Run Patch commands from the new Oracle home
F) Updating client scripts with the new Oracle home.
99、In a single-instance, multitenant container database(CDB), which three are only ever defined in or part of CDB$ROOT?
A) undo tablespaces
B) temporary tablespaces
C) redo logs
D) all data dictionary metadata
E) User-defined PL/SQL packages
F) control files
G) mandatory Oracle-supplied PU/SQL packages
100、Which two are true about backup encryption?
A) The BACKUP BACKUPSET command can encrypt and decrypt backup sets
B) Image copies can be encrypted
C) Backup encryption can be enabled selectively for specific tablespaces
D) The Transparent Data Encryption (TDE) keystore is backed up using RMAN
E) Vendor-specific media management software can be used for making encrypted RMAN
backups to media
F) Keystore-based encryption is the default mode for RMAN backup encryption
101、Your database is in ARCHIVELOG mode and you plan to use Flashback Database.
Which two features or parameters manage space availability in the fast recovery area?
A) the backup retention policy
B) the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
C) the archived log deletion policy
D) the backup optimization policy
E) using guaranteed UNDO retention
F) the DB RECOVERY FILE DEST parameter setting
102、Which operating system group is NOT needed to perform an Oracle Database installation?
E ) OSOPER
103、Which two are true about PDB archive files?
A) DBMS_PDB_ CHECK.PLUG_COMPATIBILITY can be run against a PDB archive
B) They contain a PDB manifest file and all the data files in uncompressed form for a PDB
C) They contain all the data files only in uncompressed form for a PDB.
D） They contain a PDB manifest file and all the data files in compressed form for a PDB.
E) They must be created using the DBMS PDB package
F) They contain all the data files only in compressed form for a PDB
104 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?
105 in which two scenarios is incomplete recovery required?
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
tablespace in CDB&ROOT.
B) Any new PDB and existing PDBs are automatically configured to use the default undo
tablespace in CDB$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
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.
106 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 pdb1USING '/u01/app/oracle/oradata/pdb1.xml'
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.
107 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 REVENUE table.
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.
108 which are three of the steps taken by Database Configuration Assistant(DBCA) to clone a
remote pluggable database(PDB) starting from Oracle 19c?
A) create a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned.
B) leaving the cloned PDB in mount state
C) opening the cloned PDB.
D) backing up the cloned PDB.
E) create a database link from CDB$ROOT in the local database to the PDB in the remote system
that is to be cloned.
答案: AC(选 2 个)
109 Which three are true about Oracle pluggable database(PDBs)?
A) A PDB can be plugged into a CDB only if both are of the same Oracle Database release.
B) A PDB created from PDB$SEED must be set to READ WRITE after loading data.
C) A non-CDB can be converted into a PDB.
D) A PDB created from PDB$SEED must be set to READ ONLY after loading data.
E) An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.
F) A PDB unplugged from a container database(CDBs) can be plugged into a different CDB without altering any of schemas.
G) A PDB in a remote CDB can be accessed transparently thereby aggregating results from local
and remote PDBs.
110 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 before installation.
D) It requires Oracle ASMLib to manage Automatic Storge Management(ASM) disks.
E) It requires Oracle ASM Filter Driver(ASMFD) to manage Automatic Storge Management(ASM) disks.
F) Automatic Storge Management(ASM) requires that O/S groups OSASM and OSDBA be
assigned as secondary groups for its installation owner.