Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Hasitha.

Asked: September 29, 2021 - 5:55 am UTC

Last updated: October 04, 2021 - 4:45 am UTC

Version: 12.1.0.1

Viewed 100+ times

You Asked

I want to verify that for below question my answer is correct please kindly help me.

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?
A. from the last complete checkpoint position
B. from the beginning of the current redo log file until the instance failure
C. from the last committed transaction
D. from the beginning of the current redo log file to the checkpoint position
E. from the most recent incremental checkpoint

I think answer should be B please verify.

Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB
performs RMAN backup or restore requests? (Choose three.)
A. RMAN preauthorization on the host
B. OSB encryption for data in transport and on tape
C. matching the OS user identity of the Oracle instance associated with the database username
D. assigned to a class with rights to back up or restore Oracle database
E. scheduling of the RMAN backup to occur automatically at user-defined intervals
F. assigned to a class with rights to browse all directories and catalogs

I think ADF

Please help me.

and Connor said...

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?


The answer will be A.

The last complete checkpoint will coincide with the "oldest" datafile. Incremental checkpoints might have advanced *some* of the datafiles forward in time, but the last complete checkpoint will be where we need to start.

Which three requirements should be successfully met by an Oracle Secure Backup

I'm not an OSB expert, but I believe you are correct with ADF. I got that from the docs

https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm#OBADM197

Rating

  (4 ratings)

Comments

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.
Connor McDonald
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.
Connor McDonald
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.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database