1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

What is difference between SQL and SQL*PLUS?

 1 2115

What are various joins used while writing SUBQUERIES?

 2 3071

What a SELECT FOR UPDATE cursor represent.?

 1 2189

Display the records between two range?

 2 2676

Select the Nth lowest value from a table?

 4 3728

What is difference between Rename and Alias?

 1 3682

Difference between an implicit & an explicit cursor.?

 2 6232

What is a OUTER JOIN?

 1 2082

What is the purpose of a cluster?

 1 2564

What is OCI. What are its uses?

 1 2364

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

 2 2740

Display Odd/ Even number of records?

 3 5374

What are various constraints used in SQL?

Polaris,

1 2951

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

 1 3046

Difference between NO DATA FOUND and %NOTFOUND?

 1 3684

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Can a formula column be obtained through a select statement ?

1838

What is the usage of analyze command in oracle?

597

How a database is related to tablespaces?

568

How to write a query with an inner join in oracle?

550

Query to retrieve record for a many to many relationship ?

2069




What is program global area (pga) in oracle?

597

What is the difference between substr & instr functions?

587

What is analyze command used for?

563

How would you best determine why your MVIEW couldnt FAST REFRESH?

1422

How to pass parameters to procedures?

542

How to use "in out" parameter properly?

607

What are the execution control statements in oracle?

587

How does one get the view definition of fixed views/tables?

585

What is oracle database client?

535

Is there a combination of "like" and "in" in sql?

568

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