10 free sample questions from a bank of 258, with the correct answers and explanations. No signup required — start practising right now.
1Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
All metrics are instance related.
Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
A space usage management alert is automatically cleared after the underlying problem is resolved.
They are generated by SMON when a tablespace is 97% full.
Metrics are statistical counts for a specific unit.
STATISTICS_LEVEL must be set to ALL to generate alerts.
Answer:
2Which three are true about opatchauto? (Choose three.)
It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
It must be invoked by a user with root user privileges.
Patches are applied via opatchauto.
Users must always input patch plans to opatchauto.
It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
It applies patches in nonrolling mode by default.
It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
Answer:
3Application 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?
3, 4, 1, 6, 8
2, 5, 6
1, 5, 6
1, 3, 5, 6, 7
1, 3, 5, 7
Answer: C
4Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)
A table's constraints must be disabled before issuing the flashback.
The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
A table's indexes must be set to unusable before issuing the flashback.
Row Movement must be enabled on the table being flashed back.
The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
Answer:
5Which two are true about RMAN Multisection backups when a very large data file is divided into four sections? (Choose two.)
Each of the file sections must be processed serially.
The four sections can be created serially.
The four sections must be image copies.
The four sections can be created in parallel.
The four sections must be contained in backup sets.
Answer:
6Which three are true about the Oracle Optimizer? (Choose three.)
It obeys all hints.
It considers the filters in WHERE clauses when generating execution plans for SQL statements.
It can re-optimize execution plans after previous executions detect suboptimal plans.
It considers object statistics when generating execution plans for SQL statements.
It updates stale object statistics in the Data Dictionary.
It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.
Answer:
7RMAN 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 database's control file and the RMAN recovery catalog? (Choose two.)
when control file metadata for archive log backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME
when control file metadata for data file backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME
when a new tablespace is added to a registered target database
when a backup of the current control file is created
when the target is first registered
Answer:
8You plan to perform cross-platform PDB transport using XTTS.
Which two are true? (Choose two.)
A backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause.
The source PDB must be in MOUNT state.
The source PDB must not be an application root.
The source PDB can be in MOUNT or OPEN state.
The source and target platforms must have the same endianness.
Automatic conversion of endianness occurs.
Answer:
9Which three true about recovering tables using RMAN? (Choose three.)
RMAN can recover tables in the SYSAUX tablespace.
RMAN can recover tables owned by the SYS user.
RMAN can recover tables in the SYSTEM tablespace.
RMAN always uses an auxiliary instance.
RMAN can recover tables in a standby database.
RMAN can recover a table after a DDL operation has altered the table structure.
RMAN can recover tables owed by the SYSTEM user.
Answer:
10Which operating system group is NOT needed to perform an Oracle Database installation?