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

What is a Public Synonyms ?

1 4750

What are synonyms used for ?

3 6859

What is an Index ?

2 6636

How are Indexes Update ?

1 5207

What are Clusters ?

Amdocs, Infosys,

5 10730

What is cluster Key ?

3 5978

What is Index Cluster ?

2 5800

What is Hash Cluster ?

2 5632

When can Hash Cluster used ?

1 4685

What is Database Link ?

2 5425

What are the types of Database Links ?

2 9368

What is Private Database Link ?

1 4393

What is Public Database Link ?

1 4237

What is Network Database link ?

1 5615

What is Data Block ?

2 10105

Un-Answered Questions { Oracle }

what is the difference between functional dependecy and multilevel dependency?

2429

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2132

How would you find total size of database in os level?

526

When should the default values for oracle initialization parameters be used as is?

623

Where is the multi connections are used in ORACLE DATA INTEGATOR?

601

Explain the benefits and uses lexical parameter.

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

970

Explain how you would restore a database using RMAN to Point in Time?

2113

Give the various exception types.

955

What are group functions in oracle?

992

What is the normalization?

554

What operator tests column for the absence of data?

551

How do you use automatic pga memory management with oracle 9i and above?

542

Explain the use of rows option in exp command.

1044

What is split brain syndrome in rac?

For More Un-Answered { Oracle } Questions Click Here