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 2669

What is difference between SUBSTR and INSTR?

1 3032

Display the number value in Words?

1 3093

What is difference between SQL and SQL*PLUS?

1 2948

What are various joins used while writing SUBQUERIES?

2 4016

What a SELECT FOR UPDATE cursor represent.?

1 2910

Display the records between two range?

2 3635

Select the Nth lowest value from a table?

4 5484

What is difference between Rename and Alias?

1 4481

Difference between an implicit & an explicit cursor.?

2 7424

What is a OUTER JOIN?

1 2804

What is the purpose of a cluster?

1 3354

What is OCI. What are its uses?

1 3227

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

2 3787

Display Odd/ Even number of records?

3 6577

Un-Answered Questions { Oracle }

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

State the various uses of dbcc command?

1060

How to call a stored function with parameters?

1042

Explain the importance of .pll extension in oracle?

1009

What are the oracle built-in data types?

1062

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690

What are the different types of partitions in oracle?

977

What are the differences between char and nchar in oracle?

1095

Which is better Oracle or MS SQL? Why?

4940

How to define a procedure inside another procedure?

1023

Why does for update in oracle 8 cause an ora-01002 error?

1003

Explain how can you use the same lov for 2 columns?

1128

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2327

How to start a specific oracle instance?

1037

What is an explain plan and how does it help in optimizing the sql query?

For More Un-Answered { Oracle } Questions Click Here