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

Oracle General Interview Questions

Questions Answers Views Company eMail

find out first highest salary?

Verinon Technology Solutions,

10 16375

find out the third highest salary?

CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,

92 150562

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

3 6126

what is the syntax of update command?

Semantic Space,

3 6530

which clause we are not used in where clause?

Semantic Space,

3 7677

waht is referencial integrity?

Semantic Space,

2 7530

what is the syntax of SELECT command?

6 8308

what is the syntax of INSERT command?

7 10516

what is the syntax of UPDATE command?

8 12334

what is the syntax of DELETE command?

8 11846

what is the syntax of CREATE command?

8 10402

what is the syntax of DROP command?

10 13507

what is the syntax of ALTER command?

8 14079

which sql command we can use to get a print out from oracle?

iFlex, INDUS,

2 11255

what is index?

4 7972

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Oracle

2373

Can multiple columns be used in group by in oracle?

983

What is a table in oracle?

974

How to commit the current transaction in oracle?

1114

What are the benefits of ordbms?

1083

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1018

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2003

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1986

Explain about your project and its relation to the current job position you are applying to?

1004

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2024

How to pass parameters to procedures in oracle?

1040

How to define a specific record type?

1084

What is an oracle recycle bin?

1007

Can we commit inside a function in oracle?

962

Is oracle a relational database?

914

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