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,

2352

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 8383

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

1 4643

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

iGate,

1 6695

What are advantages of dateset in datastage?

iGate,

2264

what is difference between DBMS and RDBMS?

Metric Stream,

2 6472

how to get second highest sal of emp table

6 9999

How to remove a row in a database table?

IBM,

5 8853

How to retrieve 5th highest sal from emp table?

8 11687

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

5 14595

what is the uses of cusor

Perot Systems,

3 5754

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

Cognizant,

2 6139

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

GTL,

2310

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,

2468

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

3053

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create a new table by selecting rows from another table?

1103

How to list all tables in your schema?

1056

What is varray?

1146

Can you assign multiple query result rows to a variable?

993

What are data pump export and import modes?

1073

Which are the five query types available in oracle?

954

What are named parameters?

1097

How do we get field detail of a table?

1082

What is dynamic proxy?

1012

What is the usage of analyze command in oracle?

1096

Explain the use of file option in exp command.

1134

Whether any commands are used for months calculation? If so, what are they?

1099

Explain the use of rows option in imp command.

1088

How do you store pictures in a database?

1009

Explain the function of optimizer in oracle?

1149

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