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

How do you analyze table partition using oracle provided package?

520

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

765

What is oracle partial backup?

584

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

577

How do you put database is archivelog mode, explain procedure?

549

Do you need a commit after ddl statements?

561

Explain the wait events in statspack report 'enqueue'?

577

What is the difference between raid 5 and raid 10? Which is better for oracle?

589

What is the difference between truncate and delete? Why is one faster?

648

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

587

What are bind variables and why are they important?

543

Explain force logging feature in 9i.

608

Which rman command is used to create an exact replica of a database innew host?

593

What operator tests column for the absence of data?

599

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

555

Un-Answered Questions { Oracle }

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3050

Explain view?

1031

What is iapxtb structure? Explain its importance

What is oracle d2k?

What is a database instance?

589

How to run create database statement again?

1154

How to establish administrator authentication to the server?

1040

What are record groups ?

What are joins, explain all types of joins?

2299

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1391

What is catalog in Oracle?

1364

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4587

What are bind variables and why are they important?

543

How do I know if oracle is installed on windows?

931

What is key.next.item trigger?

For More Un-Answered { Oracle } Questions Click Here