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 9774

what is pragma?

2 6773

can you write commit in triggers?

4 10875

can u call user defined functions in select statements

2 5340

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 8398

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

2 5675

how many columns can a plsql table have

NIIT,

13 21483

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

3 6056

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 6692

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

1 3914

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 7424

Explain the family trees and connection by clause

2272

Un-Answered Questions { Oracle }

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2955

What are the variable types?

614

How to assign values to variables?

1102

Mention how oracle flex asm works?

What is a static data dictionary in oracle?

1112

How to pass parameters to procedures in oracle?

1042

How much memory your 10g xe server is using?

1103

If you have an example table, what is the best way to get sizing data for the production table implementation?

554

What are the goals of dba?

558

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4174

What is materialized view in Oracle?

1074

What is oracle rowcount?

1084

Explain the use of indexes option in exp command.

1149

What is raw datatype?

1136

What is the difference between translate and replace in oracle?

1165

For More Un-Answered { Oracle } Questions Click Here