IBM
C2090-600 · Question #50
The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running…
The correct answer is D. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD. See the full explanation below for the reasoning.
Question
The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time "pit". BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE QUIESCE TABLESPACES FOR TABLE tab1 RESET Which of the following is TRUE?
Options
- AThe QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes.
- BOnce the first QUIESCE completes, there are no running transactions involving tab1, but there
- CAfter application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD
- DAfter application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD
How the community answered
(49 responses)- A8% (4)
- B4% (2)
- C2% (1)
- D86% (42)
Community Discussion
No community discussion yet for this question.