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 are data pump export and import modes?

1025

How to generate query output in html format?

1053

Can sub procedure/function be called recursively?

956

What happens if recursive calls get out of control?

1021

How to get a list of all background sessions in the database?

952

How to get execution statistics reports on query statements?

1022

How to shutdown your 10g xe server from command line?

1026

How to export your connection information to a file?

1084

How to shutdown your 10g xe server?

1098

How a tablespace is related to data files?

1072

Where is the export dump file located?

1088

What are the original export and import utilities?

1079

What is a connect identifier?

994

How to view all columns in an existing table?

887

What is an anonymous block?

1175

Un-Answered Questions { Oracle }

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1904

How do I uninstall oracle client from windows?

972

How to write an inner join with the where clause in oracle?

1016

How to run queries on external tables?

998

what is dynamic SGA and static SGA

4347

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1330

Who is a database user?

488

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

995

Differences between package and loadplans?

550

How can we delete duplicate rows in a table?

942

Whether any commands are used for months calculation? If so, what are they?

1049

Could you please let me know the interfaces in OM / FA??

2208

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2068

What are referenced objects? Explain the importance of referencing.

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

2458

For More Un-Answered { Oracle } Questions Click Here