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.

1047

Explain oracle’s server parameter file.

984

Explain overloading. Can functions be overloaded?

977

Give the advantages and disadvantages of clusters.

1048

Define oracle database

1039

Explain oracle instance.

1167

What is ceil and floor in oracle?

1067

Can a parameter be passed to a cursor?

1113

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

1062

Explain user account with reference to oracle.

971

Explain constraining triggers.

1083

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

1076

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

1000

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

1012

Explain oracle’s system global area (sga).

1134

Un-Answered Questions { Oracle }

What happens if the constraint name is left out of a constraint clause?

540

How to create a single index for multiple columns?

1028

How to initialize variables with default values?

1228

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

966

List the types of joins used in writing subqueries?

988

Explain about the analyze command in oracle?

1044

What is a proxy object?

1054

Please explain drop constraint oracle?

1089

What is a dba?

583

What is the difference between single instance environment and rac environment?

How to use attributes of the implicit cursor in oracle?

999

How will you write a query to get a 5th rank student from a table student_report?

1857

What is the relationship among database, tablespace and data file?

979

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2106

How to calculate date and time differences in oracle?

1033

For More Un-Answered { Oracle } Questions Click Here