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 does the no logging option do? Why would we use it? Why would we be careful of using it?

513

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

1033

How do I learn what codesets are available in oracle?

1007

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

1005

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

1012

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

1049

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

1023

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

943

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

1045

Explain implicit cursor.

969

Explain mutating triggers.

978

Give the different types of rollback segments.

984

How can you use check constraints for self referential integrity?

922

How many types of database triggers exist?

1074

Give the various exception types.

952

Un-Answered Questions { Oracle }

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2273

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2188

What is the purpose of scan?

what is difference between sql plus and sql*plus? (not sql and sql plus).

3832

How to start your 10g xe server?

975

What are the IKM types?

635

What is a dba?

553

When do you analyze the tables?

How to store pictures on to the database?

928

How to add a new column to an existing table with a default value?

974

What is translate in oracle?

1053

What does a dba do all day?

510

How to determine what records to extract?

What is data file?

1056

What is meant by joins?

1023

For More Un-Answered { Oracle } Questions Click Here