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

How to create a single index for multiple columns?

1037

How to assign query results to variables?

1050

What is a directory object?

1097

How to call a sub procedure?

1093

How to retrieve values from data fields in record variables?

1113

What are the general rules on data consistency?

1009

How to define a procedure inside another procedure?

1023

What to do if the binary spfile is wrong for the default instance?

1069

How to create a server parameter file?

1135

How to rename an existing table?

1126

What are the execution control statements?

1063

How to run create database statement?

1032

What happens if the update subquery returns multiple rows?

1116

How to use "startup" command to start default instance?

1031

What happens if the imported table already exists?

1033

Un-Answered Questions { Oracle }

What is the difference between a database and instance?

693

What is temporary Interface( Yellow Interface) ?

557

How can you find all the processes on your system?

570

What are the various constraints used in oracle?

1045

How can we collect the statistics of different database objects?

What suggestions do you have to reduce the network traffic?

961

How do you set up tablespaces during an oracle installation?

606

please send me oracle pl/sql exp resume. and also faqs...

2494

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1193

Difference between inner join vs where ?

1033

What are the original export and import utilities?

1168

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

1051

What is the use of the Service Knowledge module?

588

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

794

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2279

For More Un-Answered { Oracle } Questions Click Here