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,

2347

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 8358

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 6458

how to get second highest sal of emp table

6 9985

How to remove a row in a database table?

IBM,

5 8834

How to retrieve 5th highest sal from emp table?

8 11667

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

5 14578

what is the uses of cusor

Perot Systems,

3 5742

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

Cognizant,

2 6129

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

GTL,

2307

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,

2460

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

3050

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a dynamic performance view in oracle?

991

How to write text literals in oracle?

1067

What is recovery manager in Oracle?

1055

How to turn on or off recycle bin for the session?

1109

Explain integrity constraints?

1103

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

1882

What is a Garbage Collection? and what is full recursive Garbage collection?

2901

Can you have more than one content canvas view attached with a window ?

2333

What is system tablespace?

1095

What are the attributes of the cursor?

1003

Does oracle partitioning improve performance?

992

What are the differences between char and nchar in oracle?

1095

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

How to delete all rows a table in oracle?

1068

How to install oracle database 10g xe?

1018

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