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 5438

What is the function of Dispatcher (Dnnn)?

4 13617

What is the maximum number of Lock Processes used?

1 4074

What are functions of PMON?

5 14153

What is the function of Lock (LCKn) Process?

1 6901

What are the two types of Server Configurations?

3 5863

What is Shared Pool?

3 5907

What are the components of SGA?

5 6303

What is hit ratio ?

Indiabulls, RGPV,

13 129600

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

2 5962

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

2 4870

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

2 4652

How the space utilisation takes place within rollback segments?

2 4583

What is a Control file ?

4 6566

How will you force database to use particular rollback segment?

1 4285

Un-Answered Questions { Oracle }

What is a production dba?

551

What is data file?

1044

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1624

Explain what are the characteristics of data files?

1029

How to view the data files in the current database?

1042

what is the difference between functional dependecy and multilevel dependency?

2420

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1095

What is data type in oracle?

1040

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

How to generate query output in html format?

1031

How many types of tables supported by oracle?

1018

What is save point in oracle database?

1239

Which dba certification is best?

520

How to calculate date and time differences in oracle?

991

WHAT IS ecc 6.0

2101

For More Un-Answered { Oracle } Questions Click Here