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

how to eliminate duplictes in column except group and section?

iFlex, TCS,

2 7225

How can we expand Parameter Form Canvas on Reports 6i?

ABB,

2473

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

8 11759

what is primary key and foreign key when and where have to use

5 7658

can we use a having cluase in groupby clause. if there are 500 records i will give rownumber<250 then how many records does it retrieve. wt is the result of nvl2(null,notnull,null) if there are four tables without using cartesian how many joins can be there. in the sql subqueries wt is the parent ans1)select 2)update,3) delete 4)2&3

i2,

2 6131

what is view?

Accenture,

7 11198

How the Action Trigger works? and what is full syntex of srw.run_report?

CMC, Yantro Software,

1 9074

how to truncate date and get only time part 9:20:00

5 9967

what is the difference between oracle reports 6i and oracle reports 10g? give atleast 10 differences? (plz give the answer vvvvvvvvvvv.urgent)

IBM, Oracle,

1 23764

what is the output of select * from emp where null=null & select * from emp where 1=1

IMS Health, NIIT,

8 19549

defination of bitmap index

NIIT,

2184

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 23134

Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.

1 4229

difference between oracle8i and oracle9i

NIIT,

4 10295

what is the difference b/w oracle8i and oracle9i

iGate,

3 6571

Un-Answered Questions { Oracle }

What is a schema in oracle?

1067

what is the odi console?

689

What happens if variable names collide with table/column names?

1271

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

2391

What is the normalization?

635

Difference between open_form and call_form in oracle.

1224

What does database administrator do?

617

How to define a data source name (dsn) in odbc manager?

1085

What are the tools provided in oracle enterprise manager?

What is auto invoicing? Explain : oracle accounts receivable

1176

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2075

How to load data from file to file and what are the KM's required for this requirement?

665

How to find out what oracle odbc drivers are installed?

1096

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2269

How to update values on multiple rows in oracle?

1082

For More Un-Answered { Oracle } Questions Click Here