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

1117

How to generate query output in html format?

1216

Can sub procedure/function be called recursively?

1053

What happens if recursive calls get out of control?

1144

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

1047

How to get execution statistics reports on query statements?

1156

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

1158

How to export your connection information to a file?

1180

How to shutdown your 10g xe server?

1208

How a tablespace is related to data files?

1168

Where is the export dump file located?

1224

What are the original export and import utilities?

1268

What is a connect identifier?

1086

How to view all columns in an existing table?

986

What is an anonymous block?

1330

Un-Answered Questions { Oracle }

What is the difference between $oracle_base and $oracle_home?

1141

What is a system tablespace?

1137

How to pass a cursor variable to a procedure?

1160

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1072

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1073

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4682

Mention what is cluster?

How does Oracle guarantee data integrity of data changes?

2460

What the is the diff between local index and global index. give some example.

1688

How do you prevent output from coming to the screen?

575

What is current record attribute property?

How many types of km's?

628

How to put more than 1000 values into an oracle in clause?

1090

What is the difference between media recovery & crash recovery?

How to load data from external tables to regular tables?

1108

For More Un-Answered { Oracle } Questions Click Here