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 5546

What is the function of Dispatcher (Dnnn)?

4 13794

What is the maximum number of Lock Processes used?

1 4165

What are functions of PMON?

5 14410

What is the function of Lock (LCKn) Process?

1 6990

What are the two types of Server Configurations?

3 5999

What is Shared Pool?

3 6057

What are the components of SGA?

5 6496

What is hit ratio ?

Indiabulls, RGPV,

13 130135

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

2 6076

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

2 4995

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

2 4766

How the space utilisation takes place within rollback segments?

2 4683

What is a Control file ?

4 6728

How will you force database to use particular rollback segment?

1 4349

Un-Answered Questions { Oracle }

Explain oracle left join with an example?

1003

How to list all indexes in your schema?

1085

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2299

How to define an anonymous procedure without variables?

1093

how to send file attachment from oracle forms

2544

Explain how to close periods in ar. : oracle accounts receivable

1307

What happens to the current transaction if the session is ended?

1091

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

538

What are the roles of dba?

1064

What is the full form of dba?

597

What is the usage of save points in oracle database?

960

What is difference between logical standby database and physical standby database?

669

How to write date and time literals in oracle?

996

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2250

Teradata: How can we know the indexed column in a table?

1885

For More Un-Answered { Oracle } Questions Click Here