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 10151

what is primary key?

9 13220

what is foreign key?

5 8628

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 27267

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 139113

Can Multiple instances be run on Single Machine???

3 6160

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,

2385

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

3 14656

What is Index and different types of Indexes?

7 36439

what is the bitmap index?

3 7060

How you find out version of installed workflow?

1 4956

how many triggers we can create on a table

G2 Technology, TCS,

11 52593

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,

2262

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 5993

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

iFlex,

2000

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is oracle rownum?

1016

Please explain joins in oracle?

1106

List out the components of logical database structure of oracle database.

1093

Can you have more than one content canvas view attached with a window ?

2370

What is tns entry?

1236

What is a schema in oracle?

1064

How to define an anonymous block?

1245

master table and child table performances and comparisons in Oracle ?

2197

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1708

What is max rowid in oracle?

1081

How to pass a cursor variable to a procedure?

1158

How can you use check constraints for self referential integrity?

1017

How to commit the current transaction in oracle?

1180

How to drop an index in oracle?

1120

How to list all user accounts in oracle?

1066

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