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 6456

What are cursor?where are they used?

2 6454

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

IBM,

6 19182

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

CTS,

2629

What are the composite date types in oracle?

HCL,

6 18023

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

3 6559

how to use sequence and what use of sequence cache

1 4485

what is difference between where clause and having clause?

13 36515

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

8 11530

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

5 7521

what is view?

Accenture,

7 10972

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

5 9788

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

IMS Health, NIIT,

8 19308

defination of bitmap index

NIIT,

2132

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22681

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are a query and state the different types of queries and their uses?

1019

Explain the truncate in oracle?

971

In the oracle version 9.3.0.5.0, what does each number shows?

1305

Where do we use decode and case statements?

1019

How a database is related to tablespaces?

1039

How many types of synonyms in Oracle?

1128

What is the difference between alert log file and tarce file ?

2173

How to export your own schema?

1011

What is coalesce function?

1078

What is the difference between $oracle_base and $oracle_home?

1091

What is oracle join syntax?

1006

can u plz provide me oca sql dumps please i need them

1955

What is a data lock in oracle?

1134

State the difference between a primary key and foreign key?

941

Why use resource manager in Oracle?

1110

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