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 5819

Which Department has MOST NUMBER of employees?

IBM, LeadSquared, Mastek,

8 51434

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 5609

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 5142

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

5 7494

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

1 7263

WHAT IS ecc 6.0

2205

does Oracle has only one table space?

Oracle,

1 4261

how to unbreak sequence numbers during intereptions

Ion Exchange,

1 3756

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

2345

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

Wipro,

3 6241

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 5038

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 6486

i want department wise maxmum salary and empolyee name

9 30122

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How will you differentiate between varchar & varchar2?

1086

How to define a cusotmer as a supplier in ORACLE R12

2305

How to upsert (update or insert into a table)?

1044

What is rich query?

1037

How to download oracle database 10g xe?

1067

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

2955

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4234

How to insert multiple rows with one insert statement in oracle?

1135

What is oracle rowcount?

1147

How to start your 10g xe server from command line?

1129

How to drop a stored function?

1185

What are joins, explain all types of joins?

2364

What is a cursor variable?

1216

How would you change old and new values in an insert, delete and update triggers?

1078

how to clone 9i Database on to 10g Database.

2388

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