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

Oracle General Interview Questions

Questions Answers Views Company eMail

IS it possible to built the oracle database without setting the kernal parameters?

EDS,

2348

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 8361

Shall I get Pro*C Compiler in Oracle-10g release ?

1 4638

how to see the data (in unix) using dataset in datastage?

iGate,

1 6687

What are advantages of dateset in datastage?

iGate,

2263

what is difference between DBMS and RDBMS?

Metric Stream,

2 6461

how to get second highest sal of emp table

6 9986

How to remove a row in a database table?

IBM,

5 8837

How to retrieve 5th highest sal from emp table?

8 11670

which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help

5 14582

what is the uses of cusor

Perot Systems,

3 5744

SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.

Cognizant,

2 6130

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

GTL,

2308

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

Mastek,

2461

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3052

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Difference between pre-select and pre-query

1109

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2103

How to rename an existing table?

1129

What is a table index?

1098

11. Display the client number and name and the client number and name of the person who referred that client.

2339

How to sort output in descending order in oracle?

1045

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2292

How to create a table index in oracle?

1134

How to define a procedure inside another procedure?

1024

How to view existing locks on the database?

1053

How to define a sub function?

1130

What are the tools for Oracle ?

1062

What is the difference between $oracle_base and $oracle_home?

1089

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1020

How to pass a cursor variable to a procedure?

1109

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