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 9738

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

HCL,

2281

can we use lexical perameter in oracle plsql if yes how

2276

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

HCL,

2155

How you find out version of installed workflow?

1 4830

how many triggers we can create on a table

G2 Technology, TCS,

11 51862

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

2024

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,

2154

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 5749

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

iFlex,

1904

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 5686

a query to select maxmun 3 salaries of employee table

IBM, Polaris,

12 19921

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

5 10466

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

Infosys,

2474

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

EDC,

2083

Un-Answered Questions { Oracle }

Explain about functional dependency and its relation with table design?

964

How to open a cursor variable?

985

What is instant client oracle?

979

Any work done in oracle workflow builder. Did you customize or build a new workflow?

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2270

How to export data to a csv file?

1220

What degree do database administrators need?

516

Explain how to convert a report into excel sheet.

What do you mean by dba?

533

What is a tns service name?

955

What command is used to type files to the screen?

553

can you convert or reverse engineer a fmx back to a fmb file?

1100

What is the purpose of save points in oracle database?

1019

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

What is integrity and what is constraint??Explain with example

2224

For More Un-Answered { Oracle } Questions Click Here