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?

522

What is the meaning of database backup?

573

What do you understand by the term 'normalization'?

633

Explain the various modes of normalization?

502

What is the relation between database and instance?

597

What is the difference between sga and pga?

567

What do you mean by oracle database?

538

What are the important tasks of common oracle dba?

520

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

541

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

515

What is the difference between cold backup and hot backup?

550

What are the various ingredients of sga?

528

What do you understand by the oracle?

515

Explain the term 'oracle grid architecture'?

546

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

546

Un-Answered Questions { Oracle }

How to create a new oracle data file?

981

What are dml statements in oracle?

1050

What is Java Pool in Oracle?

1101

When should you increase copy latches? What parameters control copy latches?

534

How to rename a column in an existing table?

983

Which data loaded are in target db?

531

How do I uninstall oracle client from windows?

968

Mention what are the key characteristics of rac or why to use rac?

Why we use bulk collect in oracle?

980

What is the most common database language that a db administrator needs to know?

529

Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?

594

What is key.next.item trigger?

Name the different triggers supported by oracle reports and their firing order.

1031

Where in the Oracle directory tree structure are audit traces placed?

2584

What to do if the startbd.bat failed to start the xe instance?

1025

For More Un-Answered { Oracle } Questions Click Here