Oracle Interview Questions
Questions Answers Views Company eMail

how to eliminate duplictes in column except group and section?

iFlex, TCS,

2 6034

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

ABB,

1959

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

8 9236

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

5 5893

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 5092

what is view?

Accenture,

7 8980

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

CMC, Yantro Software,

1 8106

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

5 8233

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 22754

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

IMS Health, NIIT,

8 16891

defination of bitmap index

NIIT,

1631

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 18150

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 3012

difference between oracle8i and oracle9i

NIIT,

4 8687

what is the difference b/w oracle8i and oracle9i

iGate,

3 5296


Un-Answered Questions { Oracle }

How to select some columns from a table in oracle?

553


What is a trigger and what are its types?

615


What is open database communication (odbc) in oracle?

548


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1849


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1773






Which data loaded are in target db?

286


How can you determine if an oracle instance is up from the operating system level?

299


What is the difference between raid 5 and raid 10? Which is better for oracle?

306


Write a syntax for update query in oracle?

622


How can you determine the space left in a file system?

349


How to start your 10g xe server?

596


What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

1


How to update a table row with a record?

597


What is dual table oracle?

527


Why do we need a database?

286