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

Oracle General Interview Questions

Questions Answers Views Company eMail

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

1 2823

Give the Types of modules in a form?

1 2869

What is PL/SQL ?

3 2210

What are advantages fo Stored Procedures?

1 3307

What are the uses of Database Trigger ?

1784

What is Database Trigger ?

1 3119

Can the default values be assigned to actual parameters?

1 2774

Can a primary key contain more than one columns?

2 3849

What is an UTL_FILE.What are different procedures and functions associated with it?

1 3493

Differentiate between TRUNCATE and DELETE?

2 3126

What is difference between a formal and an actual parameter?

1 2749

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 2730

What are different Oracle database objects?

1 2746

What is difference between SUBSTR and INSTR?

1 3129

Display the number value in Words?

1 3168

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create a new table in oracle?

1231

How to count groups returned with the group by clause in oracle?

1122

List out the types of joins.

1236

What is procedure overloading in oracle?

1113

What is a dead lock in oracle?

1175

What are the differences between blob and clob in oracle?

1135

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2396

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2305

what is dynamic SGA and static SGA

4485

How to use subqueries in the from clause in oracle?

1165

What is set operator oracle?

1034

What is enter substitution variable in oracle?

1094

How to retrieve data from an explicit cursor?

1105

How to get execution path reports on query statements?

1043

How to call a stored function with parameters?

1092

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