Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

Explain implicit cursor.

1027

Explain mutating triggers.

1028

Give the different types of rollback segments.

1031

How can you use check constraints for self referential integrity?

969

How many types of database triggers exist?

1132

Give the various exception types.

991

List the parts of a database trigger.

1049

Explain oracle’s server parameter file.

991

Explain overloading. Can functions be overloaded?

986

Give the advantages and disadvantages of clusters.

1050

Define oracle database

1043

Explain oracle instance.

1174

What is ceil and floor in oracle?

1069

Can a parameter be passed to a cursor?

1124

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

1068

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Why is oracle database so popular?

1001

why dont we assign not null constraint as table level constraint.

2737

What happens to the data files if a tablespace is dropped?

1059

What is meant by joins?

1058

IS it possible to built the oracle database without setting the kernal parameters?

2347

When do we use group by clause in a sql query?

1035

Can sub procedure/function be called recursively?

1001

How to create a single index for multiple columns?

1037

What is ordinary table in oracle?

1156

What are the execution control statements in oracle?

1093

How to view the data files in the current database?

1097

How are extents allocated to a segment?

1125

What are the most common interview questions on ETL Testing for experience?

1143

What privilege is needed for a user to create indexes in oracle?

1026

What is an oracle tablespace?

1043

For More Un-Answered { Oracle General } Questions Click Here