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 2655

Give the Types of modules in a form?

1 2624

What is PL/SQL ?

3 1912

What are advantages fo Stored Procedures?

1 3135

What are the uses of Database Trigger ?

1628

What is Database Trigger ?

1 2897

Can the default values be assigned to actual parameters?

1 2630

Can a primary key contain more than one columns?

2 3641

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

1 3325

Differentiate between TRUNCATE and DELETE?

2 2903

What is difference between a formal and an actual parameter?

1 2604

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

1 2601

What are different Oracle database objects?

1 2575

What is difference between SUBSTR and INSTR?

1 2925

Display the number value in Words?

1 3019

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are set operators?

1035

what is IDE,DMV in sql server?

2758

Difference between inner join vs where ?

981

Which is better Oracle or MS SQL? Why?

6269

How to build data dictionary view an new database?

961

What is ordinary table in oracle?

1079

What is the relation of a user account and a schema?

1064

Can a formula column referred to columns in higher group ?

2460

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

2685

What is a user account in oracle?

1070

Describe varray?

1009

Can we connect to ORACLE db using Windows Authentication?

1187

When do you get a .pll extension in oracle?

1081

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2004

How do I uninstall oracle 11g?

1046

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