Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What does LGWR do?

2 5455

What is the function of Dispatcher (Dnnn)?

4 13644

What is the maximum number of Lock Processes used?

1 4085

What are functions of PMON?

5 14195

What is the function of Lock (LCKn) Process?

1 6910

What are the two types of Server Configurations?

3 5889

What is Shared Pool?

3 5921

What are the components of SGA?

5 6330

What is hit ratio ?

Indiabulls, RGPV,

13 129686

How to implement the multiple control files for an existing database ?

2 5981

How will you swap objects into a different table space for an existing database?

2 4901

How will you estimate the space required by a non-clustered tables?

2 4673

How the space utilisation takes place within rollback segments?

2 4591

What is a Control file ?

4 6602

How will you force database to use particular rollback segment?

1 4295

Un-Answered Questions { Oracle }

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

617

what is the use of system.effective.date variable in oracle?

1062

Give syntax for SQL and ORACLE joins.

1050

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1952

What is transport network substrate (tns) in oracle?

999

does the query needs a hint to access a materialized view?

1823

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2017

What are the goals of dba?

514

how to remove the duplicate in odi?

583

Components of Oracle Data Integrator?

507

What are the constraints in odi?

575

How to convert csv to table in oracle?

929

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

2316

What does an oracle dba do?

550

What is the difference between postgresql and oracle?

989

For More Un-Answered { Oracle } Questions Click Here