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

List the parts of a database trigger.

997

Explain oracle’s server parameter file.

955

Explain overloading. Can functions be overloaded?

946

Give the advantages and disadvantages of clusters.

1004

Define oracle database

1000

Explain oracle instance.

1120

What is ceil and floor in oracle?

1020

Can a parameter be passed to a cursor?

1060

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1022

Explain user account with reference to oracle.

937

Explain constraining triggers.

1050

What is the maximum limit on the number of columns in a table?

1024

Why do you create or replace procedures rather that drop and recreate.

958

How would you change old and new values in an insert, delete and update triggers?

964

Explain oracle’s system global area (sga).

1090

Un-Answered Questions { Oracle }

How to retrieve values from data fields in record variables?

1050

What is oracle analytical function?

1047

What command is used to type files to the screen?

553

How to define an anonymous block?

1089

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

What is the difference between truncate and delete? How would a full table scan behave after?

517

Does dba need to know programming?

524

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

993

What are the original export and import utilities?

1075

What are the common oracle dba tasks?

1080

What do you understand by anchoring in reports?

Difference between negative and positive adjustments : oracle accounts receivable

1022

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

2038

What is a junior dba?

571

What is an Oracle SYSTEM tablespace and when is it Created?

1076

For More Un-Answered { Oracle } Questions Click Here