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 2953

What are various joins used while writing SUBQUERIES?

2 4017

What a SELECT FOR UPDATE cursor represent.?

1 2912

Display the records between two range?

2 3635

Select the Nth lowest value from a table?

4 5488

What is difference between Rename and Alias?

1 4482

Difference between an implicit & an explicit cursor.?

2 7426

What is a OUTER JOIN?

1 2805

What is the purpose of a cluster?

1 3355

What is OCI. What are its uses?

1 3227

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

2 3790

Display Odd/ Even number of records?

3 6579

What are various constraints used in SQL?

Polaris,

1 3851

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

1 3887

Difference between NO DATA FOUND and %NOTFOUND?

1 4482

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the attributes that are found in a cursor?

1076

How do I connect to oracle?

1030

interview questions with answer for cts

2583

What is varray?

1136

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

1032

What is tns service name?

1126

How do you find current date and time in oracle?

1047

How to import one table back from a dump file?

1025

Explain mutating triggers.

1029

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1933

What are the different types of database objects?

1062

What is oracle in java?

970

What are the different types of trigger and explain its various uses and functions?

1094

What is meant by raw datatype?

1060

What is recovery manager(rman) backup in Oracle?

1185

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