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 is Server Process?

2 5865

What is Cursor?

Virtusa,

2 5879

How many Dispatcher Processes are created?

1 4264

What constitute an ORACLE Instance?

2 6245

What is the function of checkpoint(CKPT)?

4 9125

What is function of RECO?

1 4444

Name the ORACLE Background Process?

3 14452

What do Redo Log Buffers contain?

2 5230

What Does DBWR do?

Honeywell,

2 6956

When Does DBWR write to the database?

6 22415

What is SGA?

3 6327

What is PGA?

5 8007

When does LGWR write to the database?

3 10470

What is a Parallel Server option in ORACLE?

1 4001

What is User Process?

1 4270

Un-Answered Questions { Oracle }

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

547

How do I connect to oracle database?

1023

What do we mean by record group in oracle forms?

1025

How to initialize variables with default values?

1157

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1982

Differentiate between pre-select and pre-query?

1052

What is the sql query to find the employee who has Nth maximum salary?

5216

What is catalog in Oracle?

1264

How to define default values for formal parameters?

981

How to delete a column in an existing table?

1018

how can we store any pdf file in oracle

2093

When you used JKM ?

554

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2173

Why oracle is used?

994

How to define a data source name (dsn) in odbc manager?

965

For More Un-Answered { Oracle } Questions Click Here