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?

566

What is the meaning of database backup?

620

What do you understand by the term 'normalization'?

666

Explain the various modes of normalization?

537

What is the relation between database and instance?

638

What is the difference between sga and pga?

606

What do you mean by oracle database?

568

What are the important tasks of common oracle dba?

555

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

578

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

557

What is the difference between cold backup and hot backup?

579

What are the various ingredients of sga?

564

What do you understand by the oracle?

546

Explain the term 'oracle grid architecture'?

584

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

581

Un-Answered Questions { Oracle }

how report can be generated if we have the database designed in oracle 10g?

1876

how may join possible between (requisition with purchase order)

2241

How can we find out the duplicate values in an oracle table?

1037

how to join query for one source type is oracle another source type is sql server ?

2422

What is meant by a deadlock situation?

1103

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2262

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

575

Describe an oracle table?

1047

What is the use of aggregate functions in oracle?

1022

Explain the use of table functions.

2463

Can multiple cursors being opened at the same time?

1056

What are the main functions of dba?

570

What is a Garbage Collection? and what is full recursive Garbage collection?

2896

What are set operators?

1076

What is meant by joins? List out the types of joins.

1022

For More Un-Answered { Oracle } Questions Click Here