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

how to eliminate duplictes in column except group and section?

iFlex, TCS,

2 7096

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

ABB,

2421

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

8 11501

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

5 7502

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 6046

what is view?

Accenture,

7 10936

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

CMC, Yantro Software,

1 9008

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

5 9776

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 23655

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

IMS Health, NIIT,

8 19281

defination of bitmap index

NIIT,

2124

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22624

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 4141

difference between oracle8i and oracle9i

NIIT,

4 10122

what is the difference b/w oracle8i and oracle9i

iGate,

3 6420

Un-Answered Questions { Oracle }

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

575

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1145

What is the use of lockboxes? : oracle accounts receivable

1208

Which profile required to access solution in Designer tool?

586

How to count groups returned with the group by clause in oracle?

1075

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1194

Could you please let me know the interfaces in OM / FA??

2263

What is the use of the Service Knowledge module?

588

Does facebook use oracle?

1031

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2043

What is an Oracle database Partial Backup?

1157

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1970

How to check the server version in oracle?

1092

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1151

Does a dba have to file taxes?

580

For More Un-Answered { Oracle } Questions Click Here