A reader, September 30, 2021 - 4:52 am UTC
Really appreciate your comment on my post.
this is regarding below question,
Your database instance is abnormally terminated because of a power outage. At the next startup, from which
point in the redo log does the recovery start?
But my point is complete checkpoints are not in the online redologs for a instance recovery it check only the redologs I think your answer(A) is bit confusing me do you have any proofs to justify the answer.
September 30, 2021 - 10:21 am UTC
The question is not what is *in* in the redo logs, the question is ... where do we need to *start* in the redo logs. Lets say your database has only 4 data files. At any given point in time, they will look like this:
File1:Complete checkpoint at 9am, no further checkpoints
File2:Complete checkpoint at 9am, Incremental checkpoint at 9:02am
File3:Complete checkpoint at 9am, Incremental checkpoint at 9:06am
File4:Complete checkpoint at 9am, no further checkpoints
So when the instance crashes, we look at those checkpoint marks on the files and decide:
"OK, we need to start at 9am. File 2,3 will be quicker because they'll only need redo information from 9:02 and 9:06 respectively, but we're going to have to *start* from 9am because that is the oldest checkpoint marker"
A reader, September 30, 2021 - 12:22 pm UTC
Yes I agree with you thanks for your explanation really appreciate thanks.
October 04, 2021 - 4:45 am UTC
glad we could help
A reader, October 01, 2021 - 6:04 am UTC
Thanks for your answers really appreciate your comment.
could you please comment on below questions also,
Which four are true about Consolidated Database Replay? (Choose four.)
A. The workload capture and replay servers must run the same operating system (OS).
B. Multiple workload captures from multiple databases can be replayed simultaneously.
C. A subset of the captured workload can be replayed.
D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
E. Multiple replay schedules can be defined for a consolidated replay.
F. A single replay schedule can be defined for a consolidated replay.
G. A superset of the captured workload can be replayed.
my answer is BCEF
Which three are true about Transparent Data Encryption (TDE)? (Choose three.)
A. It stores the current and all past master keys in the keystore.
B. It replaces secure application roles.
C. Master encryption keys are managed by Oracle Database Vault.
D. It can encrypt data at the column level.
E. It uses a single master key for a database.
F. It encrypts only data on the client.
my answer is ACD
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded.
Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?
A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to
fetch data directly from SGA for analysis
B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
C. by using Active Session History (ASH) data and performing hang analysis
D. by running ADDM in diagnostic mode
My answer is A
While performing database backup to tape via the media manager interface, you notice that tape streaming is
not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup? (Choose two.)
A. Configure backup optimization.
B. Configure the channel to increase maxopenfiles.
C. Configure a backup policy by using incremental backups.
D. Configure the channel to increase capacity with the rate parameter.
E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
F. Configure large_pool, if not done already. Alternatively, you can increase the size of large_pool.
My answer is BE
In a database supporting an OLTP workload, tables are frequently updated on both key and non-key columns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?
A. heap table with a primary key index
B. external table
C. hash clustered table
D. global temporary table
E. index clustered table
My answer is A
really appreciate your comment I am going to sit for the exam on monday Please help me to clarify these little questions
A reader, October 01, 2021 - 1:34 pm UTC
Please help me.