Suggested Answer:BDEF🗳️
B: If a table still does not have any unique index specified on the logical standby database, this may cause UPDATE statements to do full table scans on the logical standby database. You can remedy that by adding a unique index on the a column on the logical standby database. E: SQL Apply uses a collection of background processes to apply changes from the primary database to the logical standby database. During apply processing: * The ANALYZER process identifies dependencies between different transactions. * The COORDINATOR process (LSP) assigns transactions to different appliers and coordinates among them to ensure that dependencies between transactions are honored. * The APPLIER processes applies transactions to the logical standby database under the supervision of the coordinator process. F: The PREPARER process is used during the log mining process, which is part of the SQL apply process. D: The Shared Pool is used by the preparar and Builder proccesses.
Figure: SQL Apply Processing - Incorrect Answers: C: There is only one coordinator process. References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ls.htm
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
JESUSBB
2 years, 5 months ago