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 2844

What are various joins used while writing SUBQUERIES?

2 3894

What a SELECT FOR UPDATE cursor represent.?

1 2829

Display the records between two range?

2 3538

Select the Nth lowest value from a table?

4 5316

What is difference between Rename and Alias?

1 4394

Difference between an implicit & an explicit cursor.?

2 7280

What is a OUTER JOIN?

1 2721

What is the purpose of a cluster?

1 3240

What is OCI. What are its uses?

1 3146

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

2 3662

Display Odd/ Even number of records?

3 6453

What are various constraints used in SQL?

Polaris,

1 3754

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

1 3793

Difference between NO DATA FOUND and %NOTFOUND?

1 4390

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do we create privileges in oracle?

995

How to convert characters to times in oracle?

956

What is a static data dictionary in oracle?

1031

How can I introduce multiple conditions in like operator?

926

How do I limit the number of oracle database connections generated by weblogic server?

1010

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1848

Why do you create or replace procedures rather that drop and recreate.

953

What is the difference between translate and replace in oracle?

1119

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1832

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2214

What are the different types of synonyms?

1080

How to convert a date to char in oracle? Give one example.

1006

What are the oracle differences between nvl and coalesce

1074

How to convert numbers to characters in oracle?

972

What is a dead lock in oracle?

1050

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