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

Oracle General (1803)
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?

2236

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,

2523

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 6192

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

2119

how i build a report

1 3760

WHT ARE THE AGGREATE FUNCTIONS?

GEITC, TCS,

7 10308

what is candidate key & super key

1 3945

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 4399

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 4367

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 5097

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 4982

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

1 4064

find the second highest salary of the emp table

6 8706

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 10110

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

Ericsson,

2 7374

Un-Answered Questions { Oracle }

How is incremental backup different from differential backup?

How to create a single index for multiple columns?

1088

how can you pass values to-and-fro from foreign function?

What is transactional trigger property?

What is a trigger and what are its types in oracle?

1159

Teradata: How can we know the indexed column in a table?

1949

Explain about party and customer in ar : oracle accounts receivable

1272

What are transaction isolation levels supported by oracle?

1119

What do you mean by redo log file mirroring?

1073

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2968

What are the steps involved in instance recovery in oracle?

594

Where in the Oracle directory tree structure are audit traces placed?

2707

What are the provisions and resources provided in the oracle’s cloud server?

What privilege is needed for a user to create views in oracle?

1100

Mention what is the difference between single instance environment and rac environment?

For More Un-Answered { Oracle } Questions Click Here