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,

2345

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 8351

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

1 4637

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

iGate,

1 6682

What are advantages of dateset in datastage?

iGate,

2260

what is difference between DBMS and RDBMS?

Metric Stream,

2 6455

how to get second highest sal of emp table

6 9974

How to remove a row in a database table?

IBM,

5 8823

How to retrieve 5th highest sal from emp table?

8 11650

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

5 14564

what is the uses of cusor

Perot Systems,

3 5734

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

Cognizant,

2 6117

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

GTL,

2305

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,

2457

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

3049

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to see free space of each tablespace?

1032

What happens to the current transaction if a ddl statement is executed?

1006

How to delete a column in an existing table?

1072

What is pragma autonomous transaction in oracle?

1064

What is an oracle table?

985

What are the ways tablespaces can be managed and how do they differ?

2364

What is a snapshot in oracle database?

1021

What is control file used for?

1199

What is the usage of save points in oracle database?

962

what are the default admin accounts in Oracle 10g ?

964

Explain the use of owner option in exp command.

1041

What is blob data type in oracle?

1117

Calculate difference between 2 date / times in oracle sql?

1040

What is the usage of synonyms?

1138

What is Java Pool in Oracle?

1164

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