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 are data pump export and import modes?

1060

How to generate query output in html format?

1111

Can sub procedure/function be called recursively?

991

What happens if recursive calls get out of control?

1072

How to get a list of all background sessions in the database?

988

How to get execution statistics reports on query statements?

1084

How to shutdown your 10g xe server from command line?

1082

How to export your connection information to a file?

1123

How to shutdown your 10g xe server?

1145

How a tablespace is related to data files?

1104

Where is the export dump file located?

1137

What are the original export and import utilities?

1159

What is a connect identifier?

1035

How to view all columns in an existing table?

932

What is an anonymous block?

1231

Un-Answered Questions { Oracle }

What is a user role in oracle?

1116

Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?

What is the usage of merge statement?

1142

How to create a new table in your schema?

1078

How do we create privileges in oracle?

1040

Explain oracle’s server parameter file.

986

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1009

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

570

How to use existing values in update statements using oracle?

1060

What is a dynamic performance view in oracle?

987

Explain the various types of oracle report?

1068

How to specify default values in insert statement using oracle?

1100

What is the usage of synonyms?

1137

What is logical backup in oracle?

1014

Explain alias?

1125

For More Un-Answered { Oracle } Questions Click Here