Oracle Interview Questions
Questions Answers Views Company eMail

What are different Oracle database objects?

1 1956

What is difference between SUBSTR and INSTR?

1 2207

Display the number value in Words?

1 2382

What is difference between SQL and SQL*PLUS?

1 2127

What are various joins used while writing SUBQUERIES?

2 3089

What a SELECT FOR UPDATE cursor represent.?

1 2210

Display the records between two range?

2 2704

Select the Nth lowest value from a table?

4 3788

What is difference between Rename and Alias?

1 3704

Difference between an implicit & an explicit cursor.?

2 6257

What is a OUTER JOIN?

1 2100

What is the purpose of a cluster?

1 2586

What is OCI. What are its uses?

1 2386

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

2 2764

Display Odd/ Even number of records?

3 5414


Un-Answered Questions { Oracle }

What are the four Oracle system processes that must always be up and running for the database to be useable?

591


Difference between varchar and varchar2 data types?

662


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

1497


What is oracle dba role?

276


What happens to indexes if you drop a table?

698






How to move objects from DEV to QA and QA to PROD Environments?

398


How do you run ms_batch file in forms?

1


How to define a cusotmer as a supplier in ORACLE R12

1726


What is save point in oracle database?

725


Explain compound trigger in oracle?

548


Mention how oracle flex asm works?

1


where the dff data will be stored

1803


How do you use automatic pga memory management with oracle 9i and above?

281


What is the minimum client footprint required to connect c# to an oracle database?

563


If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1731