Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

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

iGate,

1 6679

What are advantages of dateset in datastage?

iGate,

2259

what is difference between DBMS and RDBMS?

Metric Stream,

2 6452

how to get second highest sal of emp table

6 9970

What is the mandatory setup in cyclecount ?

Oracle,

2746

How many segment are present in Oracle Manufacturing

Oracle,

2315

Olap tools

2117

What is $FLEX$ and $PROFILES$?

2 7589

Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 10820

How to remove a row in a database table?

IBM,

5 8821

How to retrieve 5th highest sal from emp table?

8 11642

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

5 14563

what is the uses of cusor

Perot Systems,

3 5730

what is difference between sqlserver and oracle?

CMC,

5 12272

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

Cognizant,

2 6115

Un-Answered Questions { Oracle }

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

584

how to reverse engineer views(how to load the data from views)?

550

What is catalog in Oracle?

1354

How to select some rows from a table in oracle?

1073

How can we expand Parameter Form Canvas on Reports 6i?

2417

How do I become a dba?

580

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1688

How to count duplicated values in a column in oracle?

1039

How to list all tables in your schema?

1050

What is an oracle and why it is used?

1143

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1977

What do you mean by Oracle MEDIA RECOVERY?

1217

what is the scenario where you take the database to NoArchivelog mode?

2325

What is oracle rowcount?

1080

What is data type in oracle?

1115

For More Un-Answered { Oracle } Questions Click Here