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 do you mean by oracle dba?

516

What is the meaning of database backup?

562

What do you understand by the term 'normalization'?

624

Explain the various modes of normalization?

499

What is the relation between database and instance?

589

What is the difference between sga and pga?

554

What do you mean by oracle database?

536

What are the important tasks of common oracle dba?

512

What is the difference between a database and instance? What is the relation between them?

535

What are the possible ways to gain information regarding the control file?

510

What is the difference between cold backup and hot backup?

542

What are the various ingredients of sga?

526

What do you understand by the oracle?

503

Explain the term 'oracle grid architecture'?

540

What are the different types of backup available in the oracle?

541

Un-Answered Questions { Oracle }

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

515

What causes the "snapshot too old" error? How can this be prevented or mitigated?

475

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3157

Oracle Data Integrator Interview Questions and answers?

604

What is the use of lockboxes? : oracle accounts receivable

1158

Mention how oracle flex asm works?

How do we get field details of a table?

936

How to load a large xml file?

1005

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

1987

What is the function of Redo Log in Oracle?

1132

How to create a single index for multiple columns?

981

what are archived logs?

2146

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2903

How many anonymous blocks can be defined?

1106

System tablespace cant be exported from one database and imported into another why?

516

For More Un-Answered { Oracle } Questions Click Here