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 4354

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

1 3921

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 7437

Explain the family trees and connection by clause

2274

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 3659

What are main difference between Stored Procedure and Functions.

CA, Metric Stream,

6 26723

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

3 10603

what diffrence between function and procedure?

4 7944

Who i will insert 1 lacks record in a Database table

TCS,

4 12872

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 6177

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Is there any function in oracle similar like group_concat of mysql?

1057

What is the difference between I and G in Oracle?

1100

What is dual table oracle?

991

What is the meaning of recursive hints in oracle?

1046

What is Segment Advisor in Oracle?

1108

What happens if variable names collide with table/column names?

1197

Can the query output be sorted by multiple columns in oracle?

995

Explain an index segment?

1124

Is truncate autocommit in oracle?

1091

What are the different windows events activated at runtime ?

2903

What is data file?

1110

Explain the use of compress option in exp command.

1022

List the types of joins used in writing subqueries?

998

how to clone 9i Database on to 10g Database.

2344

Explain index?

1265

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