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 16660

find out the third highest salary?

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

92 153765

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

3 6245

what is the syntax of update command?

Semantic Space,

3 6664

which clause we are not used in where clause?

Semantic Space,

3 7795

waht is referencial integrity?

Semantic Space,

2 7661

what is the syntax of SELECT command?

6 8505

what is the syntax of INSERT command?

7 10742

what is the syntax of UPDATE command?

8 12618

what is the syntax of DELETE command?

8 12113

what is the syntax of CREATE command?

8 10650

what is the syntax of DROP command?

10 13820

what is the syntax of ALTER command?

8 14329

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

iFlex, INDUS,

2 11379

what is index?

4 8141

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

what is the use of system.effective.date variable in oracle?

1161

What is a sub query? What are its various types?

1274

What is integrity and what is constraint??Explain with example

2340

Is the After report trigger fired if the report execution fails ?

2952

How to convert character types to numeric types?

1193

Why does for update in oracle 8 cause an ora-01002 error?

1046

How to update a table row with a record?

1065

When system tablespace is created?

1090

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'));

1746

How to convert numbers to characters in oracle?

1077

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2261

What are the extensions used by oracle reports?

1089

Please explain oracle left join with an example?

1095

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1092

How to create a new view in oracle?

1128

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