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

Oracle General (1789)
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 6001

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

ABB,

1946

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

8 9160

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

5 5849

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 5076

what is view?

Accenture,

7 8922

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

CMC, Yantro Software,

1 8093

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

5 8187

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 22727

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

IMS Health, NIIT,

8 16801

defination of bitmap index

NIIT,

1616

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 17996

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 2968

difference between oracle8i and oracle9i

NIIT,

4 8649

what is the difference b/w oracle8i and oracle9i

iGate,

3 5264

Un-Answered Questions { Oracle }

How to list all tables in your schema?

597

types of receipts and detail desription about recipts and tables effected by receipts?

1623

What are the uses of Database Trigger ?

1092

How to connect the oracle server as sysdba?

621

What is connection pool in oracle?

549

How to use subqueries with the in operator using oracle?

600

How can I introduce multiple conditions in like operator?

545

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

301

How do I learn what codesets are available in oracle?

569

What is the quickest way to export a table to a flat file?

563

What do you understand by format trigger?

suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

477

What are a cluster and non-cluster index?

567

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2879

What is control file used for?

594

For More Un-Answered { Oracle } Questions Click Here