Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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?

559

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

828

What is oracle partial backup?

640

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

610

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

583

Do you need a commit after ddl statements?

610

Explain the wait events in statspack report 'enqueue'?

622

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

638

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

702

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

628

What are bind variables and why are they important?

593

Explain force logging feature in 9i.

654

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

631

What operator tests column for the absence of data?

643

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

600

Un-Answered Questions { Oracle }

What are record groups ? Explain the types of record group.

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1231

How do we get field detail of a table?

1134

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1260

How can you find dead processes?

586

Can we commit inside a function in oracle?

1016

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

622

Is oracle an open source?

1128

What are the main benefits of using spfile over pfile?

680

What is the meaning of recursive hints in oracle?

1103

Can we insert data in view oracle?

1122

if u want to delete all these detail block etc what will happen in form

2056

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2441

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

634

What is bulk copy or bcp in oracle?

1186

For More Un-Answered { Oracle } Questions Click Here