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,

2023

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 5199

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....

1570

WHT ARE THE AGGREATE FUNCTIONS?

GEITC, TCS,

7 7484

what is candidate key & super key

1 2992

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 3308

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 4039

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 3620

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

1 3212

find the second highest salary of the emp table

6 6598

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 7565

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

2 3947

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

1439

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,

1506

what is the difference between data migration and production migration.

1785


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

types of indexes and the rationale behind choosing a particular index for a situation.

1953


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

2227


What is Library Cache in Oracle?

625


What is tns entry?

597


How many memory layers are in the oracle shared pool?

613






Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1847


How to run create database statement again?

604


How do I reset a sequence in oracle?

569


How to sort output in descending order in oracle?

558


Are truncate and delete commands same? If so why?

629


What is a named program unit?

558


Explain the use of grant option in exp command.

558


What are the different oracle database objects?

560


Is truncate autocommit in oracle?

607


What is the relationship among database, tablespace and data file?

514