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 8545

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,

2307

what is difference between DBMS and RDBMS?

Metric Stream,

2 6565

how to get second highest sal of emp table

6 10205

How to remove a row in a database table?

IBM,

5 8998

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 14763

what is the uses of cusor

Perot Systems,

3 5857

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,

2342

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 }

Is insert autocommit in oracle?

1130

What are the roles of dba?

1136

What is a data lock in oracle?

1180

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1975

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1967

What is the maximum number of triggers that can be applied to a single table?

1067

Explain parameter file in oracle.

1080

Use of an integrity constraint is better to validate data. Explain

1088

What are the different editions of oracle?

1177

How remove data files before opening a database?

1133

Give the advantages and disadvantages of clusters.

1096

What is the difference between translate and replace in oracle?

1216

How to rename an index?

1122

In what script is snap$ created? In what script is the scott/tiger schema created?

2759

what is port in oracle? how is it related to database application.

1991

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