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,

2351

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 8381

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

1 4642

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 6471

how to get second highest sal of emp table

6 9997

How to remove a row in a database table?

IBM,

5 8850

How to retrieve 5th highest sal from emp table?

8 11686

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

5 14593

what is the uses of cusor

Perot Systems,

3 5750

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

Cognizant,

2 6138

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

GTL,

2309

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 load data from external tables to regular tables?

1063

what is the scripts in data base?

2160

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1116

What is the max number of columns in an oracle table?

1001

Explain an exception and its types?

1081

How translate command is different from replace?

1090

How do you bind variables in oracle?

985

What is recovery manager(rman) backup in Oracle?

1187

What is the relation of a user account and a schema?

1134

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4370

1) Does oracle have any table which contain all the exceptions and it's code internally?

1754

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

1159

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2030

How to check the server version in oracle?

1094

How can I combine multiple rows into a comma-delimited list in oracle?

1062

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