Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

What is difference between SQL and SQL*PLUS?

1 3033

What are various joins used while writing SUBQUERIES?

2 4101

What a SELECT FOR UPDATE cursor represent.?

1 2972

Display the records between two range?

2 3722

Select the Nth lowest value from a table?

4 5653

What is difference between Rename and Alias?

1 4565

Difference between an implicit & an explicit cursor.?

2 7539

What is a OUTER JOIN?

1 2874

What is the purpose of a cluster?

1 3422

What is OCI. What are its uses?

1 3295

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

2 3870

Display Odd/ Even number of records?

3 6705

What are various constraints used in SQL?

Polaris,

1 3935

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 3987

Difference between NO DATA FOUND and %NOTFOUND?

1 4573

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain what are the uses of rollback segment?

1067

State all possible different index configurations a table can possibly have?

1100

State and explain about oracle instance?

1049

How to unlock the sample user account in oracle?

1076

What is the recommended interval at which to run statspack snapshots, and why?

2962

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

1030

What is max rowid in oracle?

1081

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2077

Is insert autocommit in oracle?

1130

What is the usage of synonyms?

1210

what are steps for interface? where is exchange rate defined in which table?

2235

How to connect ms access to oracle servers?

1056

How can we find out the current date and time in oracle?

1129

How to drop a tablespace?

1084

How to end the current transaction in oracle?

1070

For More Un-Answered { Oracle General } Questions Click Here