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

Oracle General (1803)
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 6791

What are advantages of dateset in datastage?

iGate,

2313

what is difference between DBMS and RDBMS?

Metric Stream,

2 6574

how to get second highest sal of emp table

6 10226

What is the mandatory setup in cyclecount ?

Oracle,

2810

How many segment are present in Oracle Manufacturing

Oracle,

2376

Olap tools

2189

What is $FLEX$ and $PROFILES$?

2 7704

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

4 10981

How to remove a row in a database table?

IBM,

5 9019

How to retrieve 5th highest sal from emp table?

8 11911

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

5 14779

what is the uses of cusor

Perot Systems,

3 5873

what is difference between sqlserver and oracle?

CMC,

5 12499

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

Cognizant,

2 6274

Un-Answered Questions { Oracle }

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2675

How to resolve the ORA-39133 error in Oracle?

1187

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

What are parameter files? Where do we use them?

How to check database size in Oracle?

1259

What are the uses of Database Trigger ?

1792

how to do daily transactions with out sql* loader control file regesterd in apps?

1733

What is a named program unit?

1140

What kinds of responsibilities does a dba have in a database environment?

649

How to test null values?

1159

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2458

how to remove the duplicate in odi?

668

How to calculate date and time differences in oracle?

1099

What skills do you need to be an administrator?

614

What happens if you lost a data file?

1088

For More Un-Answered { Oracle } Questions Click Here