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

List the parts of a database trigger.

1113

Explain oracle’s server parameter file.

1041

Explain overloading. Can functions be overloaded?

1049

Give the advantages and disadvantages of clusters.

1103

Define oracle database

1102

Explain oracle instance.

1234

What is ceil and floor in oracle?

1124

Can a parameter be passed to a cursor?

1182

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

1142

Explain user account with reference to oracle.

1031

Explain constraining triggers.

1167

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

1159

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

1074

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

1082

Explain oracle’s system global area (sga).

1189

Un-Answered Questions { Oracle }

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

612

What do you mean by cdb and pdb in oracle 12c?

1111

Explain index?

1314

Explain the benefits and uses lexical parameter.

What is different types of joins?

1081

What is oracle latest version?

1153

How to use "if" statements on multiple conditions?

1219

What happens if the update subquery returns multiple rows?

1173

Explain temporal data types in oracle

1135

What is oracle database client?

1082

In what sequence do triggers get fired by oracle forms?

1027

How to define default values for formal parameters?

1096

What are materialized views & where do we use them? What is a materialized view?

What is a read write transaction in oracle?

1136

How to experiment a data lock in oracle?

1116

For More Un-Answered { Oracle } Questions Click Here