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?

552

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

1116

How do I learn what codesets are available in oracle?

1038

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

1051

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

1070

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

1087

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

1078

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

1003

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

1091

Explain implicit cursor.

1030

Explain mutating triggers.

1029

Give the different types of rollback segments.

1031

How can you use check constraints for self referential integrity?

969

How many types of database triggers exist?

1135

Give the various exception types.

993

Un-Answered Questions { Oracle }

Does facebook use oracle?

1031

What do you understand from cache fusion?

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

Is there an oracle sql query that aggregates multiple rows into one row?

980

what is the odi console?

628

How to execute a stored program unit?

1074

What is oracle partial backup?

585

How to select an oracle system id (sid)?

1064

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

2231

How to resolve the ORA-39133 error in Oracle?

1117

How to use "in" parameter properly?

1071

What are the different oracle database objects?

1091

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4174

what are knowledge modules?

638

For More Un-Answered { Oracle } Questions Click Here