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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

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

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 7930

Who i will insert 1 lacks record in a Database table

TCS,

4 12856

what is IDE,DMV in sql server?

2818

What is STATSPACK tool?

Wipro,

3 9252

what are the differen between key flexifild and discriptive fiexifild.

1 3862

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

2 6173

pl help me, i want oracle HRMS training institute address,in chennai

8 13006

How can you hide the report in Apps?

1 4115

Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 10202

deference between & and &&

Mphasis,

2 15974

When to use Place holder columns in Oracle Reports and what is a place holder column?

2 27848

Un-Answered Questions { Oracle }

Why should I use oracle database?

991

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1424

What is hash cluster in oracle?

1174

How to use attributes of the implicit cursor in oracle?

1008

How to connect ms access to oracle servers?

1006

Describe an oracle table?

1049

What is a sub query and what are the different types of subqueries?

1125

What Are Cross Validation & Adi?

1157

What is the difference between a database and instance?

693

Can a View based on another View in Oracle?

1028

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

550

What is the function of cache fusion in oracle rac?

What happens if you set the sga too low in oracle?

1149

how do u compile a form i.e .fmb file in Unix or in dos

4571

What are types of data model?

551

For More Un-Answered { Oracle } Questions Click Here