Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2179

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,

2464

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 6109

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

2057

how i build a report

1 3683

WHT ARE THE AGGREATE FUNCTIONS?

GEITC, TCS,

7 9980

what is candidate key & super key

1 3861

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 4282

I have table that has student names in it.If I query on the names my result set should return as 'VALUE NOT ENTERED' for null entries.

1 4292

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 4999

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 4869

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

1 3973

find the second highest salary of the emp table

6 8506

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 9830

What is the Query Optimizer. How you optimize your qeury.

Ericsson,

2 7247

Un-Answered Questions { Oracle }

What is bind variables in oracle reports?

What are the main functions of dba?

575

Can group functions be mixed with non-group selection fields?

1018

What is background process in Oracle?

1099

You see multiple extents in the temporary tablespace. Is this a problem?

586

How to change system global area (sga) in oracle?

1004

What is index-organized table in Oracle?

1067

1. What is PO rate variance gain and loss?

2910

Give the different types of rollback segments.

1026

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

2344

Why does Oracle not permit the use of PCTUSED with indexes?

2417

What is the use of Oracle Control File?

1068

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2521

Can a Tablespace hold objects from different Schemes in Oracle?

1037

How to uncatalog backup?

557

For More Un-Answered { Oracle } Questions Click Here