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 6438

What are cursor?where are they used?

2 6445

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

IBM,

6 19133

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

CTS,

2620

What are the composite date types in oracle?

HCL,

6 17994

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

3 6536

how to use sequence and what use of sequence cache

1 4475

what is difference between where clause and having clause?

13 36449

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

8 11477

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

5 7491

what is view?

Accenture,

7 10928

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

5 9764

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

IMS Health, NIIT,

8 19272

defination of bitmap index

NIIT,

2117

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22588

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create a stored program unit?

1221

what is the scripts in data base?

2151

Will you be able to store pictures in the database?

1116

What is a table index in oracle?

1126

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

2263

How to create a testing table in oracle?

988

How to calculate date and time differences in oracle?

1038

How to start your 10g xe server?

1035

Explain the use of parfile option in exp command.

1063

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5327

Why use resource manager in Oracle?

1102

What is a tns file?

990

What is the difference between sharding and replication?

1039

How to list all tables in your schema?

1052

What are advantages of dateset in datastage?

2260

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