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,

2393

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 8543

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

1 4717

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

iGate,

1 6779

What are advantages of dateset in datastage?

iGate,

2305

what is difference between DBMS and RDBMS?

Metric Stream,

2 6561

how to get second highest sal of emp table

6 10200

How to remove a row in a database table?

IBM,

5 8987

How to retrieve 5th highest sal from emp table?

8 11877

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

5 14759

what is the uses of cusor

Perot Systems,

3 5854

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

Cognizant,

2 6258

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

GTL,

2339

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,

2502

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

3096

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1921

What is coalesce function?

1142

Is there any function in oracle similar like group_concat of mysql?

1103

What is object data modeling?

1015

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

1070

Â How to use an oracle sequence generator in a mapping?

1129

How to write date and time literals in oracle?

1043

What are a cluster and non-cluster index?

1064

How to handle a single quote in oracle sql?

1096

How to add another datafile to a tablespace?

1087

What is the sql query to concatenate column values from multiple rows in oracle?

1100

Is there a function to split a string in plsql?

1105

What is a directory object?

1136

What is a snapshot log?

1047

candidate key is subset of super key but not vice-verse explain

2106

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