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 4341

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

1 3906

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 10381

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 7410

Explain the family trees and connection by clause

2269

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

Secon,

2 5096

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 3649

What are main difference between Stored Procedure and Functions.

CA, Metric Stream,

6 26694

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

3 10584

what diffrence between function and procedure?

4 7924

Who i will insert 1 lacks record in a Database table

TCS,

4 12842

what is IDE,DMV in sql server?

2815

What is STATSPACK tool?

Wipro,

3 9240

what are the differen between key flexifild and discriptive fiexifild.

1 3854

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

2 6161

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a trigger and what are its types?

1221

What is the difference between "as" and "is" in an oracle stored procedure?

987

What privilege is needed for a user to insert rows to tables in another schema?

1013

What is a system tablespace and when it is created?

970

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2019

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030

How to generate query output in html format?

1114

What are data pump export and import modes?

1062

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1985

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1863

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

1017

Can sub procedure/function be called recursively?

995

Are truncate and delete commands same? If so why?

1147

What is oracle data type?

959

How to start an oracle instance?

1016

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