Q67. Which two are true about Oracle instance recovery?
Q67. 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.
Xem thêm:
- Using the Alert Log and Trace Files (Quản trị Alert Log và Trace Files)
- Kinh Nghiệm Xây Dựng Cộng Đồng Pi Network Hiệu Quả
- Managing Different Types of Segments – Quản trị các loại segments trong Oracle Database
- Q126 The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE
- Implicit And Explicit Data Type Conversion – Chuyển đổi kiểu dữ liệu trong SQL
Bài viết cùng chủ đề:
-
Q152. Which three are true about monitoring waits for sessions and services?
-
Q151. For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?
-
Q150. Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed
-
Q149. Which two are true about SQL Performance Analyzer (SPA)?
-
Q148. Which two are true about common objects?
-
Q147. Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)?
-
Q146. Which three are true about Database Point-in-Time Recovery?
-
Q145. Which two are true about Oracle Optimizer Statistics, their use, and their collection?
-
Q144. Your SALES_ROOT application container has two application PDBs
-
Q143. Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection?
-
Q142 For which databases will fixup scripts be created?
-
Q141. Which three actions are performed by Database Upgrade Assistant (DBUA)?
-
Q140. Which two are true about unplugging an application container from a container database and plugging it into a different container database?
-
Q139. While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck
-
Q138. Which three are true about an application seed pluggable database (PDB)?
-
Q137. You are managing this configuration: CDB1 user SYS executes these commands after connecting successfully to PDB2
