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

Oracle General (1803)
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 5212

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 3757

What are main difference between Stored Procedure and Functions.

CA, Metric Stream,

6 26932

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

3 10719

what diffrence between function and procedure?

4 8087

Who i will insert 1 lacks record in a Database table

TCS,

4 13016

what is IDE,DMV in sql server?

2885

What is STATSPACK tool?

Wipro,

3 9401

what are the differen between key flexifild and discriptive fiexifild.

1 3936

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

2 6266

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

8 13228

How can you hide the report in Apps?

1 4191

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

1 10322

deference between & and &&

Mphasis,

2 16096

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

2 27950

Un-Answered Questions { Oracle }

What privilege is needed for a user to create indexes in oracle?

1086

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2176

How to use an explicit cursor without open statements?

1103

Why do we need a database?

638

How to load data through external tables?

1192

What is the mandatory setup in cyclecount ?

2810

Can we save images in a database and if yes, how?

1116

did u received a single file or multiple files

2063

What are privileges and grants?

1111

What do you understand by the oracle?

594

What is Session Tasks?

642

What are the differences between lov and list item?

1149

i am writing a query select EmpNo from Emp how can i call in after parameter form

2194

How to define and use table alias names in oracle?

998

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1398

For More Un-Answered { Oracle } Questions Click Here