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?

570

What is the meaning of database backup?

626

What do you understand by the term 'normalization'?

673

Explain the various modes of normalization?

540

What is the relation between database and instance?

644

What is the difference between sga and pga?

618

What do you mean by oracle database?

572

What are the important tasks of common oracle dba?

560

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

589

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

569

What is the difference between cold backup and hot backup?

583

What are the various ingredients of sga?

572

What do you understand by the oracle?

551

Explain the term 'oracle grid architecture'?

587

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

586

Un-Answered Questions { Oracle }

What is package and main advantages?

606

What are the differences between primary key and unique key?

1010

How to update values on multiple rows in oracle?

1034

State the difference between a primary key and foreign key?

935

What is bulk collect in oracle?

996

How to start your 10g xe server from command line?

1073

What is the load plans in odi?

633

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

2265

How to define an anonymous procedure without variables?

1107

What is the dba role in oracle?

577

How a database is related to tablespaces?

1031

Mention what are the benefits of oracle rac?

What is Trigger in Oracle?

1171

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1195

Explain integrity constraint?

1161

For More Un-Answered { Oracle } Questions Click Here