Infosys Oracle Database Administrator Interview Questions Answers - 1
What is the STATSPACK tool?
The STATSPACK tool is an ORACLE supplied tool to monitor database performance.
It can be used to diagnose instance wide problems both proactively and reactively.
Which parameters affect the behavior of merge join?
The behavior of merge join is influenced by the initialization parameters:
sort_area_size and db_file_multiblock_read_count
Why UNION ALL faster than UNION?
The UNION operation removes redundancy while UNION ALL does not; therefore, the UNION operation needs to perform sort.
As a result, UNION ALL performs better as it does not need to perform any sort.
How can you get more details about the blocking session?
You can use the v$session or gv$session view in Real Application Clusters (RAC) environment to get the session information.
Which utility can you use to make trace file more readable?
You can use the TKPROF utility to make user process trace file more readable.
TKPROF converts raw information into formatted output in user process trace file.
1000+ IQ Puzzles Questions and Answers More
1000+ IBPS Puzzles Questions and Answers More
Classes and Objects in C++ Programming Questions and Answers More
100+ MCQ on Constructor and Destructor in C++ More
1000+ Simple Puzzles for Interview with Answer More
Computer Abbreviations and their Meanings Pdf More
Top 100+ Java Multithreading Interview Questions and Answers More
General English Para Jumbles Questions for IBPS Bank Exams More
TNPSC Group 1, 2 Chemistry Question Paper with Answers More
TNPSC General Studies Questions with Answers More