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.

1050

Explain oracle’s server parameter file.

992

Explain overloading. Can functions be overloaded?

986

Give the advantages and disadvantages of clusters.

1050

Define oracle database

1044

Explain oracle instance.

1176

What is ceil and floor in oracle?

1069

Can a parameter be passed to a cursor?

1126

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

1068

Explain user account with reference to oracle.

990

Explain constraining triggers.

1094

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

1086

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

1006

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

1022

Explain oracle’s system global area (sga).

1139

Un-Answered Questions { Oracle }

What is connection pool in oracle?

988

Why does oracle 9i treat an empty string as null?

1056

What is oracle instant client?

1024

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

1015

What is a directory object?

1097

Have you attended the client meetings?

602

Explain the use of tables option in exp command.

1116

How to export your own schema?

1007

How to connect ms access to oracle servers?

1006

How do I reset a sequence in oracle?

1098

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

1086

What is rac and what are the various benefits of using rac architecture?

what is the difference between restoring and recovering?

1011

How to bring a tablespace offline?

1064

What are a query and state the different types of queries and their uses?

1015

For More Un-Answered { Oracle } Questions Click Here