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

can a view be updated?

3 9773

what is pragma?

2 6773

can you write commit in triggers?

4 10874

can u call user defined functions in select statements

2 5339

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

2 6994

After update how do u know how many records got updated

TCS,

4 8396

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

2 5675

how many columns can a plsql table have

NIIT,

13 21482

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

3 6055

what r routers?

1 4346

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

Satyam,

2 6689

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

1 3913

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 10391

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 7422

Explain the family trees and connection by clause

2271

Un-Answered Questions { Oracle }

Step by step explain for the Flat file?

673

can we use lexical perameter in oracle plsql if yes how

2315

What is odi studio?

586

what are basic modules required to implement oracle application in any oraganisation?

2207

What happens if you use a wrong connect identifier?

1065

How can be determining the size of the log files?

583

Can we convert a date to char in oracle and if so, what would be the syntax?

1015

Which function is used to find the largest integer less than or equal to aspecific value?

564

What happens if you set the sga too low in oracle?

1149

How will you identify oracle database software release?

1010

What are the uses of a database trigger?

994

What are record groups ?

How to create a new user account in oracle?

1020

What is the difference between translate and replace?

1060

How to speed up webrick?

1076

For More Un-Answered { Oracle } Questions Click Here