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

can a view be updated?

3 9910

what is pragma?

2 6874

can you write commit in triggers?

4 11039

can u call user defined functions in select statements

2 5452

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 7091

After update how do u know how many records got updated

TCS,

4 8561

select statement does not retrieve any records. what exception is raised?

2 5783

how many columns can a plsql table have

NIIT,

13 21875

what is load balancing and what u have used to do this?(sql loader)

3 6200

what r routers?

1 4427

what is the exact navigation to create a radio button in form6i? can i create the radio button in report6i?

Satyam,

2 6801

after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 4030

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

AppLabs,

2 10486

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

Philips,

2 7560

Explain the family trees and connection by clause

2334

Un-Answered Questions { Oracle }

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2065

How does oracle handle read consistency?

1153

What is tns name?

1029

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2330

What is Restricted Mode of Instance Startup in Oracle?

1236

What is the data pump export utility?

1137

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1231

How can we view last record added to a table?

1110

How to bring a tablespace online?

1147

What is tns service name?

1182

Hi Can any one tell me what are the API's used in requisition import.

1979

what is the difference between restoring and recovering?

1060

What are the most common interview questions on ETL Testing for experience?

1196

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2764

What are the differences between blob and clob in oracle?

1139

For More Un-Answered { Oracle } Questions Click Here