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 are different Oracle database objects?

1 2682

What is difference between SUBSTR and INSTR?

1 3048

Display the number value in Words?

1 3097

What is difference between SQL and SQL*PLUS?

1 2962

What are various joins used while writing SUBQUERIES?

2 4022

What a SELECT FOR UPDATE cursor represent.?

1 2926

Display the records between two range?

2 3642

Select the Nth lowest value from a table?

4 5504

What is difference between Rename and Alias?

1 4492

Difference between an implicit & an explicit cursor.?

2 7440

What is a OUTER JOIN?

1 2814

What is the purpose of a cluster?

1 3365

What is OCI. What are its uses?

1 3231

How you open and close a cursor variable.Why it is required?

2 3803

Display Odd/ Even number of records?

3 6587

Un-Answered Questions { Oracle }

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

693

How to test null values?

1113

How to start instance with a minimal initialization parameter file?

1048

What is format trigger?

2077

How to use "in" parameter properly?

1077

What is a connect identifier?

1045

Which flexfields you have customized?

What is system global area (sga) in oracle?

996

Explain compound trigger in oracle?

1047

How to select an oracle system id (sid)?

1065

How to create a new table by selecting rows from another table?

1103

How to apply filtering criteria at group level in oracle?

1045

How to get last row id?

1001

State and explain about oracle instance?

1001

When do you get a .pll extension in oracle?

1147

For More Un-Answered { Oracle } Questions Click Here