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?

1094

How to retrieve values from data fields in record variables?

1116

What are the general rules on data consistency?

1009

How to define a procedure inside another procedure?

1024

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?

1129

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?

1033

What happens if the imported table already exists?

1033

Un-Answered Questions { Oracle }

What is an Oracle Data Block?

1062

Explian File steps in ODI?

625

If you are not sure what command does a particular unix function what is the best way to determine the command?

565

how to write the procedures in odi?

727

How to get execution statistics reports on query statements?

1094

Query to retrieve record for a many to many relationship ?

2519

List out the types of joins.

1158

What is bulk copy or bcp in oracle?

1124

what is the scripts in data base?

2154

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

i am writing a query select EmpNo from Emp how can i call in after parameter form

2126

Oracle Data Integrator Interview Questions and answers?

652

What is supporting issues GL AP and AR?

2555

Can we create trigger on materialized view in oracle?

992

While taking hot backup (begin end backup) what will happens back end?

559

For More Un-Answered { Oracle } Questions Click Here