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

What is an oracle transaction?

1235

How to find out what privileges a user currently has in oracle?

1 1578

What are the limitations oracle database 10g xe?

1100

How to start an oracle instance?

1078

How to find out what oracle odbc drivers are installed?

1096

How to empty your oracle recycle bin?

1079

How to add a new column to an existing table in oracle?

1192

How to select all columns of all rows from a table in oracle?

1105

What is a server parameter file in oracle?

1103

How to use subqueries with the exists operator in oracle?

1071

How to use values from other tables in update statements using oracle?

1132

How to recover a dropped table in oracle?

1100

How to convert characters to times in oracle?

1081

Where are the settings stored for each instance in oracle?

1158

What is an oracle cursor variable?

1135

Un-Answered Questions { Oracle }

What is a proxy class?

1110

Teradata: How can we know the indexed column in a table?

1949

How to convert characters to dates in oracle?

1153

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2312

what is dynamic SGA and static SGA

4495

What is meant by a deadlock situation?

1157

Describe the types of sub query?

1060

candidate key is subset of super key but not vice-verse explain

2116

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

What are the system variables can be set by users? Explain them

System tablespace cant be exported from one database and imported into another why?

600

How data locks are respected in oracle?

1115

How do you set up tablespaces during an oracle installation?

657

What is object data modeling?

1019

What is a table in oracle?

1025

For More Un-Answered { Oracle } Questions Click Here