Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

what r routers?

1 4346

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 7423

Explain the family trees and connection by clause

2272

can a table has a column that has only view data and in other columns we can change data?

Secon,

2 5098

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 3658

What are main difference between Stored Procedure and Functions.

CA, Metric Stream,

6 26705

HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

3 10595

what diffrence between function and procedure?

4 7931

Who i will insert 1 lacks record in a Database table

TCS,

4 12856

what is IDE,DMV in sql server?

2819

What is STATSPACK tool?

Wipro,

3 9252

what are the differen between key flexifild and discriptive fiexifild.

1 3863

Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.

2 6173

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to shutdown your 10g xe server?

1149

How to convert a date to char in oracle? Give one example.

1068

How to connect the oracle server as sysdba?

1077

What is an oracle transaction?

1146

How to change user password in oracle?

1029

Can you drop an index associated with a unique or primary key constraint?

1019

Differentiate between pre-select and pre-query?

1106

What are ddl statements in oracle?

1075

How to create an initialization parameter file?

1049

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2322

Explain how are indexes update?

1064

how to make an oracle object

2359

What happens in oracle commit?

1026

What are the different types of database objects?

1062

ABOUT IDENTITY?

2057

For More Un-Answered { Oracle General } Questions Click Here