Oracle DBA Interview Questions for Experienced Professionals - 1
Question: 1
What are online redo log files?
Redo log files are the disk resources to store data changes.
Whenever data is changed, the information about the change is stored in the redo log file. It helps in recovery.
Question: 2
What is archive log file?
Archive log file stores redo log information persistently.
A redo log is overwritten with time; therefore, archive log maintains that lost information.
Question: 3
What is PCTFREE?
PCTUSED is a parameter that is used to specify the percentage required for a block to be considered as used.
The default value of this parameter is 40, which means that a block is considered to be used when it is more than 40% full and cannot be added to a freelist.
Question: 4
What is a log switch?
A log switch is a point when LoG Writer (LGWR) files one online redo log group and starts writing to another.
At every log switch a checkpoint occurs.
Question: 5
What is checkpoint?
A checkpoint is a point when a background process updates the headers of all datafiles and control files to synchronize the files.
At checkpoint, DataBase Writer (DBWR) writes the dirty buffers to the datafile.
Non Verbal Reasoning Questions and Answers for Bank Exams More
tnpsc vao chemistry question paper with answers More
TNPSC Group 2a Study Material in Tamil and English Pdf More
1000+ Classification Non Verbal Reasoning Questions and Answers More
1000+ Non Verbal Reasoning Classification Questions and Answers Pdf More
Internet Multiple Choice Questions and Answers More
1000+ Web Designing Interview Questions and Answers Pdf More
100+ Free online Mock Test for IBPS PO, SO, Clerk Prelims More
Electricity and Magnetism MCQ Questions Answers More
Top 10,000+ Gk Questions and Answers 2022 - 2023 More