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 9929

what is primary key?

9 12928

what is foreign key?

5 8456

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 26822

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 137156

Can Multiple instances be run on Single Machine???

3 6046

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,

2318

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

3 14529

What is Index and different types of Indexes?

7 36210

what is the bitmap index?

3 6934

How you find out version of installed workflow?

1 4895

how many triggers we can create on a table

G2 Technology, TCS,

11 52242

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 5877

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

iFlex,

1938

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a named program unit?

1069

What is oracle used for?

1022

Which is better Oracle or MS SQL? Why?

6381

What is Data Dictionary Cache in Oracle?

1162

What is an oracle recycle bin?

1007

What is a subquery in oracle?

1108

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030

What is a sub query? What are its various types?

1170

Explain an index segment?

1115

What is columnar storage what is the advantage?

1057

Explain what are the uses of rollback segment?

1004

Can we use bind variables in oracle stored procedure?

948

What is the dynamic sql in oracle?

1069

How to find the duplicate rows count from employees table in oracle?

1084

What is ordinary table in oracle?

1151

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