Oracle General Interview Questions
Questions Answers Views Company eMail

what is a view?

7 7845

what is primary key?

9 10279

what is foreign key?

5 6763

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 22652

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 121656

Can Multiple instances be run on Single Machine???

3 4895

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,

1785

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

3 13214

What is Index and different types of Indexes?

7 33944

what is the bitmap index?

3 5066

How you find out version of installed workflow?

1 4114

how many triggers we can create on a table

G2 Technology, TCS,

11 48460

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,

1718

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 4804

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

iFlex,

1536


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is oracle update statement with inner join ?

559


How to define default values for formal parameters?

566


How to use "out" parameter properly?

605


How to insert a new row into a table in oracle?

562


IS it possible to built the oracle database without setting the kernal parameters?

1741






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 ?

2023


What is tns service name?

592


Can a formula column referred to columns in higher group ?

2058


Can we store pictures in the database and if so, how it can be done?

564


Explain about integrity constraint?

582


What is the database name in oracle?

503


How to bring a tablespace offline?

520


Can we create trigger on materialized view in oracle?

536


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1340


What is a table in oracle?

521