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 4353

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

1 3920

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 10394

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 7434

Explain the family trees and connection by clause

2273

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

Secon,

2 5110

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 26721

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

3 10602

what diffrence between function and procedure?

4 7944

Who i will insert 1 lacks record in a Database table

TCS,

4 12871

what is IDE,DMV in sql server?

2829

What is STATSPACK tool?

Wipro,

3 9268

what are the differen between key flexifild and discriptive fiexifild.

1 3867

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

2 6175

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is Java Pool in Oracle?

1175

What is a subquery?

1127

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1111

What are the different types of synonyms?

1140

How to estimate disk space needed for an export job?

1051

How to use "while" statements in oracle?

1330

What is archive log in Oracle?

1134

What is the difference between a user and a schema in oracle?

1034

What is the quickest way to export a table to a flat file?

968

How to define a specific record type?

1088

Is oracle the best database?

970

Point out the difference between user tables and data dictionary?

987

How to revoke create session privilege from a user in oracle?

1020

how the indexes are stored in the Oracle Database?

2271

What are the various oracle database objects?

1148

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