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

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

Oracle Interview Questions

Questions Answers Views Company eMail

What operating systems are supported by oracle database 10g xe?

1092

How data locks are respected in oracle?

1115

What is program global area (pga) in oracle?

1094

How to write an inner join with the where clause in oracle?

1095

How to list all user accounts in oracle?

1070

What are dml statements in oracle?

1135

How to end the current transaction in oracle?

1077

What is the implicit cursor in oracle?

1175

How to use like conditions in oracle?

1117

How to define an explicit cursor in oracle?

1102

What is a recycle bin in oracle?

1 1663

How to select an oracle system id (sid)?

1125

What is a user role in oracle?

1190

How to omit columns with default values in insert statement in oracle?

1099

How to open and close an explicit cursor in oracle?

1103

Un-Answered Questions { Oracle }

What are the different oracle database objects?

1152

What is oracle sid?

1007

what is the difference between call_form, new_form and open_form?

1388

Difference between hot backup vs. Cold backup?

1043

What privilege is needed for a user to create views in oracle?

1099

What is the full form of dba?

661

What is rac and what are the various benefits of using rac architecture?

Which is the best option used to move database from one server to another serve on same network and why?

583

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2568

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

612

What is Library Cache in Oracle?

1195

What is the use of the Service Knowledge module?

640

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2076

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

660

What is the disadvantage of User defind function?

2347

For More Un-Answered { Oracle } Questions Click Here