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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How can you Enforce Referential Integrity in snapshots ?

1 2912

What is a SNAPSHOT ?

1 2777

What is a shared pool?

1 2474

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

1 2754

Give the Types of modules in a form?

1 2755

What is PL/SQL ?

3 2063

What are advantages fo Stored Procedures?

1 3234

What are the uses of Database Trigger ?

1720

What is Database Trigger ?

1 3018

Can the default values be assigned to actual parameters?

1 2708

Can a primary key contain more than one columns?

2 3757

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

1 3400

Differentiate between TRUNCATE and DELETE?

2 3049

What is difference between a formal and an actual parameter?

1 2680

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

1 2663

Un-Answered Questions { Oracle }

What is rowid and rownum in oracle?

1011

What are some indications that you need to increase the shared_pool_size parameter?

569

What is the difference between formal parameters and actual parameters?

1088

In topology manager where the data are stored?

677

How to get execution path reports on query statements?

987

How to create a table in a specific tablespace?

976

What are the five main functions of a database administrator?

635

What are the various ingredients of sga?

572

How to define a record variable to store a table row?

1058

What is data store? How to create data store?

638

What is the data quality in odi?

645

What is not equal to in oracle?

1003

What is the use of oracle?

1030

What is save point in oracle database?

1296

Where in the Oracle directory tree structure are audit traces placed?

2638

For More Un-Answered { Oracle } Questions Click Here