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 4422

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

1 4016

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 10475

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 7550

Explain the family trees and connection by clause

2325

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

Secon,

2 5203

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 3745

What are main difference between Stored Procedure and Functions.

CA, Metric Stream,

6 26908

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

3 10703

what diffrence between function and procedure?

4 8082

Who i will insert 1 lacks record in a Database table

TCS,

4 13004

what is IDE,DMV in sql server?

2878

What is STATSPACK tool?

Wipro,

3 9384

what are the differen between key flexifild and discriptive fiexifild.

1 3929

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

2 6259

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to call a stored function in oracle?

1064

What is difference between cartesian join and cross join?

1155

What is clustered table in Oracle?

1258

How to turn on or off recycle bin for the instance?

1123

How do I manually uninstall oracle client?

1148

what is reindexing?

1729

How to use "out" parameter properly?

1123

Difference between the “verify” and “feedback” command?

1426

What are the parameters that we can pass through a stored procedure?

1117

Why use resource manager in Oracle?

1172

What is a cursor in oracle?

1228

What is flashback in Oracle?

1063

Why is oracle so popular?

1053

Explain integrity constraints?

1157

Give syntax for SQL and ORACLE joins.

1144

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