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,

2288

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 8160

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

1 4558

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

iGate,

1 6601

What are advantages of dateset in datastage?

iGate,

2210

what is difference between DBMS and RDBMS?

Metric Stream,

2 6367

how to get second highest sal of emp table

6 9756

How to remove a row in a database table?

IBM,

5 8668

How to retrieve 5th highest sal from emp table?

8 11393

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

5 14361

what is the uses of cusor

Perot Systems,

3 5627

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

Cognizant,

2 6017

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

GTL,

2278

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,

2411

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

3006

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the difference between view and materialized view in Oracle?

1101

What is the difference between formal parameters and actual parameters?

1018

What is an oracle and why it is used?

1090

Explain parameter file in oracle.

985

Can group functions be mixed with non-group selection fields?

975

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1904

List the various oracle database objects?

1006

How to rename an index in oracle?

1072

what is the use of system.effective.date variable in oracle?

1068

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2212

Is primary key indexed by default in oracle?

942

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1838

What is the usage of synonyms?

1075

Where do we use decode and case statements?

950

How many anonymous blocks can be defined?

1118

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