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

Oracle General Interview Questions

Questions Answers Views Company eMail

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

Polaris,

3 5810

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 51416

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

Polaris,

2 5607

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 6511

how to store only time in a data base table

2 5137

how to get the no employee in each department including the dept which has 0 employee

5 7487

What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index

1 7260

WHAT IS ecc 6.0

2201

does Oracle has only one table space?

Oracle,

1 4256

how to unbreak sequence numbers during intereptions

Ion Exchange,

1 3753

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2343

can we pass two out parameters at a time in function?please answer to my question

Wipro,

3 6238

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 5029

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 6482

i want department wise maxmum salary and empolyee name

9 30099

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is ordinary table in oracle?

1238

What happens if the update subquery returns multiple rows?

1166

What is a procedure in oracle?

1280

Explain the difference between sql and oracle?

1125

List out the difference between commit, rollback, and savepoint?

1091

How to manage transaction isolation level?

1054

How to define a variable of a specific record type?

1114

How to convert a date to char in oracle? Give one example.

1107

What is the parameter mode that can be passed to a procedure?

1108

How is it different from a normal table?

1083

What is Redo Log Buffer in Oracle?

1278

How to define an anonymous procedure with variables?

1238

How to compare dates in oracle sql?

1159

What is hot backup and logical backup?

1111

How to export data to a csv file?

1385

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