1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

How can you Enforce Referential Integrity in snapshots ?

 1 2058

What is a SNAPSHOT ?

 1 2051

What is a shared pool?

 1 1832

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

 1 2010

Give the Types of modules in a form?

 1 1917

What is PL/SQL ?

 1105

What are advantages fo Stored Procedures?

 1 2492

What are the uses of Database Trigger ?

 1092

What is Database Trigger ?

 1 2201

Can the default values be assigned to actual parameters?

 1 2024

Can a primary key contain more than one columns?

 2 2752

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

 1 2650

Differentiate between TRUNCATE and DELETE?

 2 2095

What is difference between a formal and an actual parameter?

 1 1949

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

 1 2058

Un-Answered Questions { Oracle }

ABOUT IDENTITY?

1553

What is table partitioning?

1

How to create a temporary table in oracle?

682

Which files are vital that should be backed up?

297

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

983




How to call a stored function in oracle?

572

What happens if a tablespace clause is left off of a primary key constraint clause?

289

What is oracle analytical function?

520

What is the use of oracle?

541

What is meant by a deadlock situation?

569

Does dba need to know programming?

279

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

289

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1772

How many types of auditing in Oracle?

559

In topology manager where the data are stored?

324

For More Un-Answered { Oracle } Questions Click Here