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,

2269

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 8098

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

1 4530

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

iGate,

1 6577

What are advantages of dateset in datastage?

iGate,

2199

what is difference between DBMS and RDBMS?

Metric Stream,

2 6344

how to get second highest sal of emp table

6 9698

How to remove a row in a database table?

IBM,

5 8621

How to retrieve 5th highest sal from emp table?

8 11335

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

5 14311

what is the uses of cusor

Perot Systems,

3 5603

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

Cognizant,

2 5992

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

GTL,

2259

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,

2396

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

2995

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How much memory your 10g xe server is using?

1050

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1289

interview questions with answer for cts

2532

How do I learn what codesets are available in oracle?

997

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1944

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2145

What is the scope of a local variable?

995

Explain the use of log option in exp command.

1046

Difference between oracle's plus (+) notation and ansi join notation?

1031

How index is implemented in oracle database?

943

How to define a cusotmer as a supplier in ORACLE R12

2169

What privilege is needed for a user to create indexes in oracle?

963

How to view existing locks on the database?

994

What is oracle data type?

901

How to pass parameters to procedures?

973

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