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?

513

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?)

763

What is oracle partial backup?

577

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

575

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

541

Do you need a commit after ddl statements?

558

Explain the wait events in statspack report 'enqueue'?

574

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

582

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

644

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

580

What are bind variables and why are they important?

537

Explain force logging feature in 9i.

603

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

590

What operator tests column for the absence of data?

590

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

552

Un-Answered Questions { Oracle }

How to set a transaction to be read only in oracle?

1090

What is data store? How to create data store?

630

11. Display the client number and name and the client number and name of the person who referred that client.

2330

What are the various constraints used in oracle?

1038

How to define a record variable to store a table row?

1049

What is Trigger in Oracle?

1158

Is Odi used in oracle products?

666

What are the steps involved in instance recovery in oracle?

545

Explain the purpose of forms_ddl.

What is oracle latest version?

1092

What is an oracle cursor variable?

1067

How many types of dba are there?

559

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2492

Which is faster join or subquery in oracle?

983

What happens if you set the sga too low in oracle?

1136

For More Un-Answered { Oracle } Questions Click Here