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 2002

Give the Types of modules in a form?

1 1909

What is PL/SQL ?

1098

What are advantages fo Stored Procedures?

1 2483

What are the uses of Database Trigger ?

1088

What is Database Trigger ?

1 2199

Can the default values be assigned to actual parameters?

1 2020

Can a primary key contain more than one columns?

2 2745

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

1 2641

Differentiate between TRUNCATE and DELETE?

2 2091

What is difference between a formal and an actual parameter?

1 1943

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

1 2051

What are different Oracle database objects?

1 1938

What is difference between SUBSTR and INSTR?

1 2183

Display the number value in Words?

1 2346


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to install oracle odbc drivers?

612


How to establish administrator authentication to the server?

546


What is a subquery in oracle?

568


How to get last row id?

543


Can group functions be used in the order by clause in oracle?

566






What is pragma autonomous transaction in oracle?

509


what is the difference between functional dependecy and multilevel dependency?

1981


What to do if the startbd.bat failed to start the xe instance?

595


When system tablespace is created?

589


How to create a new table by selecting rows from another table?

539


State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

595


Please explain oracle left join with an example?

571


Is oracle an open source?

625


What is the difference between substr and instr?

511


How to use select statement to count the number of rows in oracle?

540