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 5076

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 3643

What are main difference between Stored Procedure and Functions.

CA, Metric Stream,

6 26661

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

3 10571

what diffrence between function and procedure?

4 7914

Who i will insert 1 lacks record in a Database table

TCS,

4 12832

what is IDE,DMV in sql server?

2810

What is STATSPACK tool?

Wipro,

3 9230

what are the differen between key flexifild and discriptive fiexifild.

1 3840

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

2 6155

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

8 12987

How can you hide the report in Apps?

1 4097

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

1 10197

deference between & and &&

Mphasis,

2 15961

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

2 27826

Un-Answered Questions { Oracle }

What are the general rules on data consistency?

1006

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2945

How do we get field details of a table?

977

How to write date and time interval literals in oracle?

1027

What are materialized views & where do we use them? What is a materialized view log?

How can you find all the processes on your system?

566

What suggestions do you have to reduce the network traffic?

954

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2118

What should a dba know?

521

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2256

What is an oracle function?

1150

What do you mean by a deadlock?

1057

What are the Types of repositories in ODI?

583

default triggers available for reports

2205

What is meant by a deadlock situation?

1103

For More Un-Answered { Oracle } Questions Click Here