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

I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

Icon,

4 9900

as a technical developer in oracle applications which type errors feced in your experience sofar

HCL,

2329

can we use lexical perameter in oracle plsql if yes how

2313

as a technical developer in oracle applications which type errors feced in your experience sofar

HCL,

2181

How you find out version of installed workflow?

1 4898

how many triggers we can create on a table

G2 Technology, TCS,

11 52279

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2071

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

iFlex,

2204

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

Allfon,

2 5879

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

iFlex,

1941

What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?

HDFC,

1 5781

a query to select maxmun 3 salaries of employee table

IBM, Polaris,

12 20334

Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table

5 10669

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

Infosys,

2509

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

EDC,

2136

Un-Answered Questions { Oracle }

What is the meaning of recursive hints in oracle?

1046

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2135

Explain implicit cursor.

1028

How to define an oracle cursor variable?

1027

How to delete multiple rows from a table in oracle?

1060

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1171

How to return top 5 rows in oracle?

1062

How can we tune a sql query to optimize the performance of a database?

How to speed up webrick?

1076

Where do we use decode and case statements?

1011

Can we write insert statement in function in oracle?

1089

How many file formats are supported to export data?

1220

Explain the use of rows option in imp command.

1085

What suggestions do you have to reduce the network traffic?

961

What are the file systems and volume management techniques used in oracle rac?

For More Un-Answered { Oracle } Questions Click Here