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

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

596

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

1208

How do I learn what codesets are available in oracle?

1080

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

1100

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

1124

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

1130

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

1127

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

1053

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

1150

Explain implicit cursor.

1075

Explain mutating triggers.

1091

Give the different types of rollback segments.

1084

How can you use check constraints for self referential integrity?

1022

How many types of database triggers exist?

1197

Give the various exception types.

1040

Un-Answered Questions { Oracle }

How to increment dates by 1 in oracle?

1140

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2065

Why do we need integrity constraints in a database?

1080

How to use subqueries with the in operator using oracle?

1140

How is incremental backup different from differential backup?

You have taken a manual backup of a datafile using os. How rman will know about it?

599

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2213

What is Memos?

634

Is oracle dba in demand?

646

Tell me about standby database? What are some of the configurations of it?

616

What is Data Dictionary Cache in Oracle?

1249

What is rac?

What is the data quality in odi?

710

How to download oracle database 10g xe?

1072

What is an Oracle database Partial Backup?

1208

For More Un-Answered { Oracle } Questions Click Here