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

Oracle General (1808)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What does the no logging option do? Why would we use it? Why would we be careful of using it?

390

How do I call oracle stored procedures that take no parameters?

780

How do I learn what codesets are available in oracle?

778

How do I use os authentication with weblogic jdriver for oracle and connection pools?

774

How do I limit the number of oracle database connections generated by weblogic server?

802

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

861

How do I use unicode codesets with the weblogic jdriver for oracle driver?

770

Why does for update in oracle 8 cause an ora-01002 error?

742

How to find the duplicate rows count from employees table in oracle?

826

Explain implicit cursor.

769

Explain mutating triggers.

783

Give the different types of rollback segments.

787

How can you use check constraints for self referential integrity?

723

How many types of database triggers exist?

758

Give the various exception types.

741

Un-Answered Questions { Oracle }

Explain the hardware architecture used in oracle rac?

What are open_form,call_form,new_form?

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7171

What is difference between sid and service name in oracle?

694

Which date function is used to find the difference between two dates?

382

Design database draw er diagram for a certain scenario ?

4314

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1428

What are the types of trigger in oracle?

756

What is the meaning of database backup?

382

Is oracle dba in demand?

412

what is the difference between substr and instr function in oracle?

807

Explain joins in oracle?

763

Why does Oracle not permit the use of PCTUSED with indexes?

2163

Discuss row chaining, how does it happen? How can you reduce it?

391

A scenario for amount correction & how to use amount correction functionality in AP invoices

1874

For More Un-Answered { Oracle } Questions Click Here