1 .Which four are true about duplicating a database using Recovery Manager (RMAN)?
A. A backup of the target database is always required.
B. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
C. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
D. A connection to the target database instance is always required.
E. A connection to an auxiliary instance is always required.
F. A new DBID is always created for the duplicated database.
G. A connection to the recovery catalog instance is always required.
H. A subset of the target database can be duplicated.
2. Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?
A. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.
B. AWR snapshots can be created in a PDB.
C. AWR snapshots can be created in CDB$ROOT.
D. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
E. ADDM can run in a nonroot container.
F. AWR reports can be generated while connected to any container
3. Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
A. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version
B. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
C. An existing Oracle base can be used.
D. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
E. Existing Oracle Database instances must be shut down before starting the upgrade.
F. Only the grid user can perform the upgrade
4. Which two are true about the Automatic Database Diagnostic Monitor (ADDM)?
A. By default it analyzes a period of time corresponding to the last 24 hours of activity
B. When ADDM reports multiple findings, summing all their impacts can yield to more than 100% of DB time.
C. Results are written to the alert log.
D. By default it analyzes a period of time corresponding to the last 4 hours of activity.
E. It runs automatically after each AWR snapshot
5. Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?
A. Space might be reclaimed proactively before space pressure occurs.
B. Space is only reclaimed when there is space pressure in the Fast Recovery Area (FRA).
C. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.
D. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.
E. Space is always reclaimed proactively before space pressure occurs.
6 . PDB1 and PBD2 are pluggable databases in CDB1.
Examine these commands:
CDB1 is then restarted.
Which three are true? (Choose three.)
A. PDB2 will be MOUNTED.
B. PDB1 will be MOUNTED.
C. PDB$SEED will be opened READ ONLY.
D. PDB2 will be opened READ WRITE.
E. PDB1 will be opened READ WRITE.
F. PDB$SEED will be MOUNTED.
7. 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. Increase the size of the database buffer cache.
B. Enable asynchronous disk I/O.
C. Disable FORCE LOGGING for the database.
D. Increase the level of RMAN multiplexing.
E. Increase the size of tape I/O buffers.
8. Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?
A. redo logs
B. control files
C. all data dictionary metadata
D. user-defined PL/SQL packages
E. temporary tablespaces
F. mandatory Oracle-supplied PL/SQL packages
G. undo tablespaces
9. Which two are true about server-generated alerts? (Choose two.)
A. Stateful alerts must be created by a DBA after resolving the problem.
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
10. Which three activities are possible for PDBs?
A. copying an application container into another application container in a different CDB.
B. converting an application PDB to an application seed.
C. converting an application PDB to a regular PDB
D. converting a regular PDB to an application PDB
E. converting an application seed to an application PDB
F. copying an application container into another application container in the same CDB.
G. converting an application PDB to an application root
11. Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?
A. They can create any table.
B. They can drop any tablespace.
C. They can view data from any user-defined tables.
D. They can view data from any data dictionary view or dynamic performance view.
E. They cannot drop tablespaces. F. They cannot create restore points.
12. Which two are true about creating RMAN backups for an Oracle container database?
A. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
B. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected 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 is connected to a PDB.
E. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT
13. 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. Datafile 24 can be recovered while connected to CDB$ROOT.
B. Datafile 24 can be restored only while connected to CDB$ROOT.
C. Datafile 24 can be restored and recovered while connected to CDB$ROOT.
D. Datafile 24 can be restored only while connected to PDB2.
E. Datafile 24 can be recovered only while connected to PDB2.
F. Datafile 24 can be recovered while connected to PDB2.
14. Which three are true in Oracle 19c in 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. A transportable data pump import can leave a plugged-in tablespace in read/write mode.
D. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
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
15. 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. six
B. seven
C. five
D. eight
E. three
16. How do you configure a CDB for local undo mode?
A. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATBASE LOCAL UNDO ON, and then restart the CDB instance.
B. Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATBASE LOCAL UNDO ON, and then change the CDB to read/write mode.
C. 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.
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 restart the CDB instance.
E. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, create UNDO tablespace in each PDB, then restart CDB instance
17 . Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c? (Choose three.)
A. It cannot be used to provision applications.
B. It is an Oracle Database service.
C. It can be used to deploy Oracle Database homes.
D. It cannot be used to provision middleware.
E. It can be used to deploy Grid Infrastructure homes, including Oracle Restart.
F. It is an Oracle Grid Infrastructure service.
18. Which two are true about Oracle instance recovery?
A. Recovery begins from the beginning of the CURRENT redo log group.
B. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the database is opened.
C. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
D. 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.
E. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
F. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
19. Which two are true about the execution of operating system scripts starting from Oracle Database 19c?
A. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials
B. root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.
C. root.sh can be executed automatically by the Database installer only by using sudo credentials
D. The sudo password must be specified in a response file.
E. The root password cannot be specified in a response file.
20. Which two are true about creating pluggable databases (PDBs) in oracle 19c and later releases?
A. A PDB snapshot depends on n an existing storage snapshot of the source PDB
B. A PDB snapshot can be a sparse copy of a source PDB
C. A PDB snapshot can be a full copy of a source PDB
D. A snapshot copy PDB does not depend on an existing storage snapshot f the source PDB
E. A snapshot copy PDB can be a full copy of a source PDB
21. Examine this configuration:
1. CDB1 is a container database.
2. COMMON_USER_PREFIX is set to an empty string.
3. PDB1 is a pluggable database in CDB1.
4. APP1_ROOT is an application container in CDB1.
5. APP1_PDB1 is an application PDB in APP1_ROOT.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;
What 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 CDB$ROOT and APP1_ROOT.
C. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
D. ROLE1 will be created only in CDB$ROOT.
E. It will return an error because common roles must start with C##.
22. 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 CDB root 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. 2, 5, 6
C. 1, 5, 6
D. 1, 3, 5, 6, 7
E. 1, 3, 5, 7
23. Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?
A. It is a set of recommendations by the optimizer to change the access methods used.
B. It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.
C. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
D. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
E. It is a set of recommendations by the optimizer to create new indexes.
24. xamine this configuration:
1. CDB1 is a container database.
2. There are several pluggable databases (PDBs) in CDB1.
3. Each PDB has several tables with referential integrity constraints.
4. FLASHBACK DATABASE is ON.
5. 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. restore and recover database
B. flashback transaction
C. flashback database
D. flashback table
E. flashback table and transaction
25. Which two are true about duplicating pluggable databases (PDBs) with RMAN?
A. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
C. CDB$ROOT and PDB$SEED are automatically duplicated if a PDB is duplicated.
D. Two or more PDBS can be duplicated with the same RMAN DUPLICATE command.
E. A user with SYSDBA or SYSBKUP must use RMAN logged into a PDB in order to duplicate it.
26. Which two are true about memory advisors?
A. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
B. If Automatic Memory Management is enabled, no memory advisors are available.
C. 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.
D. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
E. All memory advisors use data from Automatic Workload Repository.
27. Which three are true about recovering tables using RMAN?
A. RMAN can recover tables in the SYSAUX tablespace.
B. RMAN can recover tables owned by the SYS user.
C. RMAN can recover tables owned by the SYSTEM user.
D. RMAN can recover tables in a standby database.
E. RMAN always use an auxiliary instance.
F. RMAN can recover a table after a DDL operation has altered the table structure.
G. RMAN can cover tables in the SYSTEM tablespace.
28. Which two are true about Rapid Home Provision of Oracle Software?
A. It can be used for applications and middleware.
B. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.
C. It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.
D. It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.
E. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.
29. Which three at true about patchsets?
A. They can introduce new features.
B. They are installed via OPatch or OPatchAuto.
C. They can be applied in a rolling fashion for Clusterware and the databases.
D. Installing a patchset is considered an "upgrade."
E. A base release is not needed to install patchsets.
F. They are only released quarterly.
30. Which two are true about Optimizer Statistics? (Choose two.)
A. They can be gathered by the DBMS_STATS package.
B. They are gathered by the SQL Tuning Advisor.
C. They provide real-time data about schema objects.
D. They are ignored by Optimizer if they are stale.
E. By default, they are automatically gathered by a maintenance job.
31. 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? (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 tablespace
32. Which two are true about RMAN duplexed backup sets? (Choose two.)
A. They can be written only to disk.
B. They must be written to media.
C. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.
D. They can be created only by using the COPIES option of a BACKUP command.
E. They can be written to media.
33. In which two situations can you use Database Upgrade Assistant? (Choose two.)
A. when the operating system (OS) needs to be changed as part of the upgrade
B. when a character set conversion is required during the upgrade
C. when multiple pluggable databases in a container database have to be upgraded in a specific sequence
D. when the target and source database are on the same platform
E. when the hardware platform needs to be changed as part of the upgrade
34. Which two are true about various Oracle security and auditing capabilities? (Choose two.)
A. Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.
B. Application-common TSDP policies are always container specific
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. Unified auditing can be automatically synchronized to all application PDBs in an application container.
35. You want to transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have the same endian format.
Examine this list of steps:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY 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 DATAPUMP 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 DATAPUMP clause.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?
A. 1, 3, 4, 6, 8
B. 3, 4, 6
C. 1, 2, 3, 4, 5, 6, 7, 8
D. 2, 3, 4, 5, 6, 7
36. Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.)
A. They are generated if STATISTICS_LEVEL is set to TYPICAL.
B. They are generated if STATISTICS_LEVEL is set to ALL.
C. They are always created automatically.
D. They are always created manually.
E. They can be retained forever.
F. They are generated if STATISTICS_LEVEL is set to BASIC.
37. Examine this configuration:
1. CDB1 is an Oracle container database from an older release.
2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1.
A priority list UpgrdList has these entries:
1, pdb2
2, pdb1, pdb3
You execute this command:
$ /u01/app/oracle/product/18.1.0/db_1/rdbms/admin/dbupgrade -L UpgrdList
In which order will the upgrade occur?
A. CDB$ROOT, PDB1, PDB2, PDB3, and PDB4
B. CDB$ROOT, PDB2, PDB1, and PDB3
C. CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4
D. CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4
E. CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3
38. Which three are true about the FLASHBACK DATABASE feature?
A. FLASHBACK LOGS are archived after the log switch.
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 flashback time.
D. It always generates REDO and UNDO.
E. A database can be flashed back using SQL*PLUS.
F. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database
39. Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)
A. All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.
B. The SPFILE is included in the archival backup.
C. They are never considered obsolete by RMAN.
D. 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.
E. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
F. They can optionally be written to a fast recovery area (FRA).
G. Use of a recovery catalog is always required to support the creation and use of archival backups.
40 . Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)
A. The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.
B. The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.
C. Flashback commands help with repairing physical errors.
D. RMAN can always repair corrupt blocks.
E. The ADR can store metadata in an Oracle Database repository.
F. The Data Recovery Advisor uses the ADR.
41. Which three are true about the Oracle Optimizer? (Choose three.)
A. It obeys all hints.
B. It considers the filters in WHERE clauses when generating execution plans for SQL statements.
C. It can re-optimize execution plans after previous executions detect suboptimal plans.
D. It considers object statistics when generating execution plans for SQL statements.
E. It updates stale object statistics in the Data Dictionary.
F. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.
42. You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true? (Choose three.)
A. All files in the current FRA that have been backed up already, are backed up.
B. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
C. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.
D. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.
E. All files in any previous FRA that have not yet been backed up, are backed up.
F. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.
G. All files in any previous FRA that have been backed up already, are backed up.
43. Which three are two about interpreting Recovery Manager (RMAN) error stacks returned to standard output?
A. Media Management errors appear as a line with "sbtio" and a number.
B. Some messages in the error stack are not errors.
C. If an RMAN command fails, the output will only identify the command that failed.
D. Media Management errors appear as a line with "sbtio".
E. Media Management errors appear as a line with "Additional information" and a number.
F. If an RMAN command fails, the output will identify the channel ID where the failure occurred.
44. 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 20th of August
B. All backups prior to 17th of August
C. All backups prior to 24th of August
D. All backups prior to 10th of August
E. All backups prior to 22nd of August
45. Which two are true about RMAN encryption? (Choose two.)
A. Keystore-based encryption is the default mode for RMAN backup encryption.
B. Backup encryption can be enabled selectively for specific tablespaces.
C. The BACKUP BACKUPSET command can encrypt and decrypt backup sets.
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. Image copies can be encrypted.
46. 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? (Choose two.)
A. a group called dba
B. the Oracle Inventory group oinstall
C. an operating system user to own this installation
D. an operating system account called grid
E. the installation of Oracle ASMLIB
47. Which three are true about an application container? (Choose three.)
A. It can contain a single application.
B. It can contain multiple applications.
C. It must have an application seed PDB.
D. It must have an application root PDB.
E. Two application containers can share an application seed PDB.
F. An application PDB can belong to multiple application containers.
48. For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?
A. to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB
B. to generate an XML metadata file from any unplugged PDB
C. to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure
D. to generate a . pdb archive file for any PDB in the current CDB
E. to generate an XML metadata file that describes the current plugged-in PDB
49. 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
50. Which three are located by using environment variables? (Choose three.)
A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
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 instance
51. Which three are true about corrupted data blocks and their recovery in an Oracle Database?
A. If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.
B. DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.
C. A media corrupt block is one where the block is not formatted correctly.
D. The ANALYZE TABLE … VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.
E. If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.
F. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.
52. Examine this configuration:
1. CDB1 is a container database.
2. DEFAULT_SHARING is METADATA.
3. APP_ROOT is an application root contained in CDB1.
4. APP_PDB1 is an application PDB contained in APP_ROOT.
5. COMPANYAPP is an application contained in APP_ROOT.
6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed.
You execute these commands:
What will be the outcome and why?
A. It will return an error because EMP is not empty in APP_ROOT
B. It will return an error because the SYNC operation is not allowed when constraints are added to common objects
C. SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows
D. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows
E. It will return an error because EMP.SAL is empty in APP_ROOT
53. Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)
A. The Pre-Upgrade Information Tool script is executed by DBUA.
B. DBUA must be launched from the target Oracle Home.
C. All pluggable databases are automatically upgraded as part of a container database upgrade.
D. A whole database backup must exist before upgrade
E. The database must be opened in read-only mode.
F. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.
54. Which two are true about RMAN Multisection backups when a very large data file is divided into four sections? (Choose two.)
A. Each of the file sections must be processed serially.
B. The four sections can be created serially.
C. The four sections must be image copies.
D. The four sections can be created in parallel.
E. The four sections must be contained in backup sets.
55. 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 TRANSACTION
B. FLASHBACK VERSION QUERY
C. FLASHBACK DATA ARCHIVE
D. FLASHBACK TABLE
E. FLASHBACK DATABASE
56. Which two are true about RMAN backups when using a media manager? (Choose two.)
A. A media manager always writes RMAN requested backups to tape.
B. By default, a request for a proxy copy may result in a backup set being created.
C. A media manager is required to create RMAN proxy copies.
D. A media manager is required to create RMAN image copies.
E. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.
57. R_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 application's common objects are accessible to it.
Which two methods can be used? (Choose two.)
A. Create an application seed, and install HR_APP in it.
B. Create the PDB1 application PDB and install HR_APP in it.
C. Create an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB.
D. Create the PBD1 application PDB and synchronize it with HR_ROOT.
E. Create the PBD1 application PDB and synchronize it with PDB$SEED.
58. Which three are true about cloning databases into an existing CDB with RMAN? (Choose three.)
A. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.
B. The target and auxiliary instance passwords must be the same.
C. Two or more PDBs can be cloned with the same command.
D. A non-CDB can be cloned into a PDB.
E. Only one PDB can be cloned at a time.
F. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.
59. Which are two of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c? (Choose two.)
A. backing up the cloned PDB
B. opening the cloned PDB
C. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
D. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
E. leaving the cloned PDB in mount state
60.. Examine this output of an export from the current release of an Oracle multitenant database
$ sqlplus system/oracle .
SQL> col name for a10
SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED
SQL> exit Next you execute:
$ expdp system/oracle full=y
What is the outcome?
Options:
A. It fails because Data Pump cannot be used while connected to the root container
B. It creates a full export of only the root container
C. It creates a full export of the root container and all open PDBs
D. It creates a full export of the root container and all PDBs
D. It creates a full export of the root container and PDB1
61. Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
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 TEMPFILE must always be re-created manually.
D. A lost password file can be manually re-created with the orapwd utility.
E. A lost PFILE can be re-created alert.log using SQL*PLUS.
F. A lost index tablespace can be re-created without performing any recovery.
62. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?
(Choose three.)
A. The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs
B. The base catalog must be enabled for Virtual Private Catalog use.
C. The target PDB must be registered in a base catalog
D. The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.
E. The target PDB must be registered in a Virtual Private Catalog.
F. The target PDB must be registered in both the base catalog and the Virtual Private Catalog.
63. 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.
64. 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? (Choose two.)
A. RESYNC CATALOG
B. REPORT OBSOLETE
C. LIST ARCHIVELOG ALL
D. CROSSCHECK BACKUP OF ARCHIVELOG ALL
E. LIST ARCHIVELOG
F. LIST EXPIRED
65. Examine this configuration:
1. CDB1 and CDB2 are two container databases.
2. PDB1 is a pluggable database in CDB1.
3. PDB1_C1_SRV is a service for PDB1.
4. CDB1_LINK is a database link in CDB2 referring to PDB1.
5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service.
You execute these commands successfully:
$ sqlplus sys/oracle_4U@cdb2 as sysdba
SQL> CREATE PLUGGABLE DATABASE PDB1
FROM PDB1@CDB1_LINK -
SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV');
Which two are true? (Choose two.)
A. PDB1 will be created in CDB2 and automatically opened.
B. PDB1 will be created in CDB2 and left in MOUNT state.
C. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
D. PDB1_C2_SRV will be created and started automatically.
E. PDB1_C2_SRV will be created but not started.
66. Which three statements are true about Oracle Restart? (Choose three.)
A. If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.
B. It is used in both clustered and non-clustered environments.
C. You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) Commands.
D. It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances.
E. It runs from the Oracle Grid Infrastrucre home.
F. The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart
67. Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?
A. SQL statements
B. log writer performance
C. general operating system health
D. database writer performance
E. database instance memory management and sizes
68. Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)
A. A PDB-level resource plan can limit session PGA memory
B. A CDB-level resource plan can limit PDB CPU utilization
C. A CDB-level resource plan can limit session CPU utilization.
D. PDB-level resource plans can limit uncommitted UNDO per consumer group
E. A CDB-level resource plan can limit PDB UNDO use.
F. A CDB-level resource plan is mandatory when using PDB-level resource plans.
Website không 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 không muốn bị AI thay thế và tiết kiệm 3-5 NĂM trên con đường trở thành DBA chuyên nghiệp hay làm chủ Database 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ộ bí kíp thực chiến, thủ tục, quy trình của gần 20 năm kinh nghiệm (mà bạn sẽ KHÔNG THỂ tìm kiếm trên Internet/Google) từ đó 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/admin_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
=============================
cơ sở dữ liệu, cơ sở dữ liệu quốc gia, database, AI, trí tuệ nhân tạo, artificial intelligence, machine learning, deep learning, LLM, ChatGPT, DeepSeek, Grok, 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/21c/23c/23ai, 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, docker, k8s, micro service, hoc solaris tutorial, hoc linux tutorial, hoc aix tutorial, unix tutorial, securecrt, xshell, mobaxterm, putty
