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 5674

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 51149

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 5518

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 6422

how to store only time in a data base table

2 5044

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

5 7323

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

1 7187

WHAT IS ecc 6.0

2147

does Oracle has only one table space?

Oracle,

1 4173

how to unbreak sequence numbers during intereptions

Ion Exchange,

1 3669

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

2276

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

Wipro,

3 6122

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 4944

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 6388

i want department wise maxmum salary and empolyee name

9 29802

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Is it possible to split the print reviewer into more than one region ?

2280

What do you understand by a database object?

1063

How are extents allocated to a segment?

1125

Explain alias?

1154

How to use subqueries in the from clause in oracle?

1113

Explain the truncate in oracle?

967

Is truncate autocommit in oracle?

1087

what is a Nested Loop join?

2117

State all possible different index configurations a table can possibly have?

1006

How to rename an index?

1073

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2323

What do you know about normalization? Explain in detail?

951

What is difference between sid and service name in oracle?

956

Why does oracle 9i treat an empty string as null?

1056

Can we call procedure inside function in oracle?

1096

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