Interview Questions

07
May

Oracle 12c DBA Interview Questions

If you're looking for Oracle DBA Interview Questions for Experienced or Freshers, you are at right place. There are a lot of opportunities from many reputed companies in the world. According to research, Oracle DBA has a market share of about 2%. So, You still have an opportunity to move ahead in your career in Oracle DBA Development. Akswave offers Advanced Oracle DBA Interview Questions that helps you in cracking your interview & acquire dream career as Oracle DBA.

Related Course : ORACLE 12C DBA


Q1) How to check opatch applied or not in our Oracle home?

Answer:  ./opatch lsinventory 100 GB of database size while applying opatch it will take 30 mins, so 500 GB of database size how much time it will take to apply opatch. Same 30 Mins, We will apply the opatch for oracle binary only not for data.


Q2) What is sqlnet.ora ?

Answer:  It is used to security of our database, Privileged IP address only able to access the database.


Q3) what are the different components of physical and logical database structure?

Answer:

physical: Datafile,Controlfiles, redologfiles.

Logical: Database buffer cache, Redo log buffer cache,Shared pool,large pool


Q4) What is Database Writer (DBWR)?

Answer:  It is responsible to writing data from database buffer cache into datafiles.


Q5) What is a listener process?

Answer:  It is network connectivity, Application and sql developer tool to access database. Lietener.ora and Tnsnames.ora files are used.

Q6) What is the difference between SPFILE and PFILE?

Answer:  Spfile: Server parameter file of binary file, It contains all the information for setting the database initialization parameters. SPFILE permits dynamic changes without requiring you to restart that instance. Pfile: It is text parameter file, information for setting the database initialization parameters.


Q7) What is the purpose of collecting statistics?

Answer:  It will help optimizer to generate best execution plan


Q8) What is an Oracle index?

Answer:  It is an database object used to increase the performance for retrieval data.


Q9) If the table is fragmented, how would you rebuild it?

Answer:  Alter table tablename move, We can analyze the table.


Q10) What are the different tools that are provided by Oracle to assist performance monitoring?

Answer:  AWR,ADDM,Trace,TKPROF,OEM


Q11) What is an explain plan and how does it help in optimizing the SQL Query?

Answer:  We will check if query is using proper indexes are not. If not we will either create new indexes or can use hints to specify which indexes to use.


Akal Singh
Oracle Certified Master | Founder – AKSWAVE Solutions Pvt. Ltd. | Senior Ex. Oracle University Instructor
Akal Singh is a seasoned Oracle Database Administrator (DBA) and a distinguished Oracle Certified Master (OCM) — Oracle’s highest level of certification. With over 24+ years of industry experience, he brings a deep understanding of database architecture, performance tuning, high availability, and real-time enterprise implementations.
As a Senior Ex. Oracle University Instructor, Akal Singh has successfully delivered 600+ Batches, mentoring 6,000+ IT professionals worldwide, including teams from Fortune 500 companies. His unique training approach blends hands-on labs, real-world scenarios, and expert insights, making him a sought-after mentor in the Oracle DBA community.

Related Course

Oracle 12C DBA

5
Reviews : 2,567

Classroom

 10,000

 14,000

29% Off

Online

 20,000

 22,000

9% Off

Demo Video

No Records Found

Other Courses

0 Comments

Post a Comment