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

Oracle General Interview Questions

Questions Answers Views Company eMail

What are triggers?Where are they used?

3 6446

What are cursor?where are they used?

2 6449

Please explain the difference between outer join and inner join? With examples would be appreciable..!

IBM,

6 19161

how can db_files > maxdatafiles since db_files is for instance and the later is for database

CTS,

2623

What are the composite date types in oracle?

HCL,

6 18007

Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

3 6547

how to use sequence and what use of sequence cache

1 4480

what is difference between where clause and having clause?

13 36470

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

8 11505

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

5 7505

what is view?

Accenture,

7 10944

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

5 9777

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

IMS Health, NIIT,

8 19289

defination of bitmap index

NIIT,

2125

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22634

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to loop through a cursor variable?

1085

How to view the tablespaces in the current database?

978

What is dual table oracle?

984

How to update values on multiple rows in oracle?

1034

Is oracle the best database?

963

How to rollback the current transaction in oracle?

1054

What are transaction isolation levels supported by oracle?

1072

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1661

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2233

What is a cursor variable?

1129

What are the uses of a database trigger?

994

What are the differences between number and binary_float in oracle?

1100

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690

Explain about integrity constraint?

1122

How to insert a new row into a table in oracle?

1165

For More Un-Answered { Oracle General } Questions Click Here