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

What is an oracle transaction?

1145

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

1 1512

What are the limitations oracle database 10g xe?

1046

How to start an oracle instance?

1017

How to find out what oracle odbc drivers are installed?

1040

How to empty your oracle recycle bin?

1020

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

1139

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

1052

What is a server parameter file in oracle?

1056

How to use subqueries with the exists operator in oracle?

1027

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

1079

How to recover a dropped table in oracle?

1047

How to convert characters to times in oracle?

1023

Where are the settings stored for each instance in oracle?

1105

What is an oracle cursor variable?

1075

Un-Answered Questions { Oracle }

What is the difference between recovery and restoring of the oracle database?

1221

How do we get field detail of a table?

1078

How to turn on or off recycle bin for the session?

1109

What are the types of partitions in oracle?

1036

if some data is not transfered where it will get stored

1942

How to drop a stored function?

1137

What does the no logging option do? Why would we use it? Why would we be careful of using it?

551

What are the main benefits of using spfile over pfile?

641

What happens to the indexes if a table is recovered?

993

How would you begin to troubleshoot an ORA-3113 error?

2077

What are the execution control statements in oracle?

1093

how do u setup a replication site?

1983

What is transactional trigger property?

Explain how one can iterate through items and records in a specified block?

1125

Are you familiar with user exits in reports?

For More Un-Answered { Oracle } Questions Click Here