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 9757

what is pragma?

2 6764

can you write commit in triggers?

4 10858

can u call user defined functions in select statements

2 5328

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

2 6988

After update how do u know how many records got updated

TCS,

4 8369

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

2 5668

how many columns can a plsql table have

NIIT,

13 21436

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

3 6045

what r routers?

1 4339

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

Satyam,

2 6685

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

1 3901

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 10379

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 7397

Explain the family trees and connection by clause

2269

Un-Answered Questions { Oracle }

Explain the designer?

622

How do you use automatic pga memory management with oracle 9i and above?

575

How to view the data files in the current database?

1094

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2290

What is set operator oracle?

971

what are the advantages of running a database in archive log mode?

2197

How many knowledge modules you used?

592

What are active transformation / passive transformations?

What is recycle bin in Oracle?

1143

How does the on-delete-cascade statement work?

1100

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2094

How to initialize variables with default values?

1231

What is supporting issues GL AP and AR?

2532

what is difference between inner join & nested query or subqueries

3029

What is temporary Interface( Yellow Interface) ?

552

For More Un-Answered { Oracle } Questions Click Here