Oracle DBA Structure Interview Questions and Answers Pdf - 1
What is database buffer cache advisor?
Database buffer cache advisor is one of the many advisors, which advise the database administrator about the optimum size of the database buffer.
The buffer cache is part of the memory that holds copies of data blocks for queries and Data Manipulation Language (DML) operations.
What are the advantages of using locally managed tablespace?
Following are the major advantages of locally managed tablespace.
Reduced contention on data dictionary tables
No rollback generated
No coalescing required
Reduced recursive space management
What is PCTFREE?
PCTFREE is used to determine the portion of a block that should be left un-used for future updates.
Define the redo log group and the redo log member?
Redo log group is a set of identical redo log files.
Each log file in the group is referred to as a redo log member.
A database needs to maintain at least two redo log groups.
Can you recover a control file?
No, A backup of control file generates a script to create a new control file.
1000+ GATE Previous Year Papers with Solutions Pdf More
1000+ Maintenance Engineering Question Bank with Answers Pdf More
1000+ Business Management Questions and Answers Pdf More
1000+ Business Management Objective Questions and Answers Pdf More
1000+ Business Management Quiz Questions with Answers Pdf More
1000+ Logic Sequence Puzzles Questions and Answers More
Synonyms & Antonyms Quiz with Answers Pdf More
200+ World Most Important Currency, Countries & Capitals Pdf More
Oracle Streams 11g Interview Questions and Answers More
1000+ Multiple Choice Questions in English Grammar with Answers More