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?

1068

How to generate query output in html format?

1118

Can sub procedure/function be called recursively?

1003

What happens if recursive calls get out of control?

1082

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

993

How to get execution statistics reports on query statements?

1094

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

1086

How to export your connection information to a file?

1129

How to shutdown your 10g xe server?

1149

How a tablespace is related to data files?

1109

Where is the export dump file located?

1158

What are the original export and import utilities?

1170

What is a connect identifier?

1039

How to view all columns in an existing table?

936

What is an anonymous block?

1249

Un-Answered Questions { Oracle }

Where do we use connected and un connected lookups?

How to retrieve the count of updated rows?

1127

What is the normalization?

594

Can we store pictures in the database and if so, how it can be done?

1043

What is responsibility and how u attach How to create user and how u attach with responsibility.

2041

Give the various exception types.

993

What is backup in Oracle?

1004

What privilege is needed for a user to insert rows to tables in another schema?

1015

how the indexes are stored in the Oracle Database?

2271

Why do we need integrity constraints in a database?

1019

What is difference between cartesian join and cross join?

1088

What is the difference between a primary key & a unique key?

1090

Give the constructs of a package, function or a procedure.

1040

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2509

How to establish administrator authentication to the server?

1041

For More Un-Answered { Oracle } Questions Click Here