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?

2183

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,

2466

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 6111

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

2062

how i build a report

1 3687

WHT ARE THE AGGREATE FUNCTIONS?

GEITC, TCS,

7 10002

what is candidate key & super key

1 3870

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 4290

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 4294

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 5001

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 4873

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

1 3977

find the second highest salary of the emp table

6 8514

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 9848

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

Ericsson,

2 7258

Un-Answered Questions { Oracle }

What is Trigger in Oracle?

1170

Is java required for oracle client?

997

What is the main function of database?

610

What is the difference between internal & external schema?

757

What is a private synonym?

1588

How many databases should a dba manage?

654

How to get a create statement for an existing table?

969

What are the various oracle database objects?

1144

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2113

What is the function of Redo Log in Oracle?

1216

What is an oracle table?

988

Explain index?

1258

Explain the use of indexes option in exp command.

1149

Explain the various types of canvas in form.

How to establish administrator authentication to the server?

1040

For More Un-Answered { Oracle } Questions Click Here