Author Archives: Tran Anh

Q152. Which three are true about monitoring waits for sessions and services?

Q152. Which three are true about monitoring waits for sessions and services? (Choose three.) A....

Q151. For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?

Q151. For which two tasks can you use the DBMS_PDB.DESCRIBE procedure? A. to generate an...

Q150. Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed

Q150. Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully...

Q149. Which two are true about SQL Performance Analyzer (SPA)?

Q149. Which two are true about SQL Performance Analyzer (SPA)? (Choose two.) A. It is...

Q148. Which two are true about common objects?

Q148. Which two are true about common objects? (Choose two.) A. They can be created...

Q147. Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)?

Q147. Which three are true about backup, restore, and recovery operations done without using Recovery...

Q146. Which three are true about Database Point-in-Time Recovery?

Q146. Which three are true about Database Point-in-Time Recovery? (Choose three.) A. The database must...

Q145. Which two are true about Oracle Optimizer Statistics, their use, and their collection?

Q145. Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose...

Q144. Your SALES_ROOT application container has two application PDBs

Q144. Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common...

Q143. Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

Q143. Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection?...

Q142 For which databases will fixup scripts be created?

Q142. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing...

Q141. Which three actions are performed by Database Upgrade Assistant (DBUA)?

Q141. Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.) A. It...

Q140. Which two are true about unplugging an application container from a container database and plugging it into a different container database?

Q140. Which two are true about unplugging an application container from a container database and...

Q139. While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck

Q139. While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup...

Q138. Which three are true about an application seed pluggable database (PDB)?

Q138. Which three are true about an application seed pluggable database (PDB)? (Choose three.) A....

Q137. You are managing this configuration: CDB1 user SYS executes these commands after connecting successfully to PDB2

Q137. You are managing this configuration: 1. CDB1 is a container database. 2. PDB1 and...

Q136. Examine this configuration: PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully

Q136. Examine this configuration: CDB1 is a container database. PDB1 and PDB2 are pluggable databases...

Q135. Which two are true about RMAN encryption?

Q135. Which two are true about RMAN encryption? (Choose two.) A. RMAN encryption keys are...

Q134. Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment?

Q134. Which two are facets of performance planning that should always be considered or implemented...

Q133. Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases?

Q133. Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c...