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 5532

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 50776

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 5397

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 6310

how to store only time in a data base table

2 4927

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

5 7114

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

1 7092

WHAT IS ecc 6.0

2106

does Oracle has only one table space?

Oracle,

1 4074

how to unbreak sequence numbers during intereptions

Ion Exchange,

1 3561

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

2206

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

Wipro,

3 5977

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 4832

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 6270

i want department wise maxmum salary and empolyee name

9 29379

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Does oracle charge for java?

1011

Differentiate between post-database commit and post-form commit?

984

Explain oracle instance.

1116

What is a read only transaction in oracle?

975

Explain the use of inctype option in exp command.

981

How to create a new oracle data file?

976

What are the uses of a database trigger?

932

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2005

When do I need to use a semicolon vs a slash in oracle sql?

1031

What is index-organized table in Oracle?

1022

What are oracle functions?

978

What is the relation of a user account and a schema in oracle?

1011

What are the parameters that we can pass through a stored procedure?

1001

What are the four Oracle system processes that must always be up and running for the database to be useable?

957

Explain cascading triggers.

1017

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