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 6300

What are cursor?where are they used?

2 6362

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

IBM,

6 18911

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

CTS,

2580

What are the composite date types in oracle?

HCL,

6 17787

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

3 6382

how to use sequence and what use of sequence cache

1 4400

what is difference between where clause and having clause?

13 36038

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

8 11237

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

5 7291

what is view?

Accenture,

7 10711

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

5 9594

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

IMS Health, NIIT,

8 19006

defination of bitmap index

NIIT,

2055

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22103

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the types of partitions in oracle?

980

Explain cascading triggers.

1019

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2055

Respected sir, Please send me technical questions related to oracle apps..

1767

What is the difference between PFILE and SPFILE in Oracle?

1000

How many file formats are supported to export data?

1145

What is difference between cartesian join and cross join?

1026

what is dynamic SGA and static SGA

4339

What is define in oracle?

1016

What happens if the imported table already exists?

976

How to enter a new row into a table interactively?

968

Will you be able to store pictures in the database?explain.

935

How to assign data of the deleted row to variables?

1017

How to convert numbers to characters in oracle?

976

What is a table index in oracle?

1077

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