Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Oracle General Interview Questions
Questions Answers Views Company eMail

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 ?

Goldman Sachs,

1600

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

Goldman Sachs,

1 4474

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1138

WHT ARE THE AGGREATE FUNCTIONS?

GEITC, TCS,

7 5277

what is candidate key & super key

1 2375

when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 2534

How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.

2 3154

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 2789

How to display the hierarchy of employee and managers without using connect by prior.

1 2599

find the second highest salary of the emp table

6 4939

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

Cognizant, IBM,

7 5636

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 3059

can u plz provide me oca sql dumps please i need them

992

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

Sierra Atlantica,

1104

what is the difference between data migration and production migration.

1373


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

How to create id with auto_increment on oracle?

131


How to define an anonymous block?

149


What is oracle data type?

111


What is a table in oracle?

111


How can you merge two tables in oracle?

120






Explain the use of rows option in imp command.

144


Is oracle the best database?

110


What is data block in Oracle?

157


What is an oracle user account?

151


How to apply filtering criteria at group level in oracle?

143


What is materialized view in Oracle?

163


What are the most common interview questions on ETL Testing for experience?

182


What is Java Pool in Oracle?

169


What is a sub query? Describe its types?

136


Is postgres faster than oracle?

111