Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

what is a view?

7 10167

what is primary key?

9 13226

what is foreign key?

5 8636

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 27290

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 139195

Can Multiple instances be run on Single Machine???

3 6166

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

eicc,

2390

pls explain connect by prior with example and its real time use

3 14663

What is Index and different types of Indexes?

7 36458

what is the bitmap index?

3 7074

How you find out version of installed workflow?

1 4960

how many triggers we can create on a table

G2 Technology, TCS,

11 52631

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,

2264

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 6004

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

iFlex,

2002

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the minimum client footprint required to connect c# to an oracle database?

1166

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2271

What is BBED in Oracle?

1201

What is a cognitive schema?

1035

What is a tns service name?

1058

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

2011

How to compare dates in oracle sql?

1162

Which is faster join or subquery in oracle?

1050

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1446

Explain what are the advantages of views?

1110

What is connection pool in oracle?

1040

why dont we assign not null constraint as table level constraint.

2800

What is the difference between view and materialized view in Oracle?

1208

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1140

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2523

For More Un-Answered { Oracle General } Questions Click Here