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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

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 5529

Can we use bulk collect in oracle forms if yes then how?

1 12780

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 6432

how to store only time in a data base table

2 5057

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

5 7338

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

1 7199

REGULAR CLASSES for Informatica 8.6 is starting from Monday, 07th Nov, 8:00 AM IST .

1 4115

WHAT IS ecc 6.0

2151

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

Cap Gemini,

2418

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

Cap Gemini, Syntel,

2 6754

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

TCS,

2406

how can we send a concurrent program output to the clients through mail or fax give me example.

Cap Gemini,

1 5862

does Oracle has only one table space?

Oracle,

1 4184

how to unbreak sequence numbers during intereptions

Ion Exchange,

1 3675

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

2294

Un-Answered Questions { Oracle }

What is an oracle report?

1086

What are the various types of snapshots ?

1032

How to convert raw data type into text in oracle? Explain

997

what is difference between group above and group left report

3827

What is a junior dba?

636

Where does the clusterware write when there is a network or storage issue?

Can we store pictures in the database and if so, how it can be done?

1047

What is the finger command?

592

What is connection pool in oracle?

993

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2233

What are the types of trigger in oracle?

987

Mention how can you determine what protocol is being used for interconnect traffic?

What is the disadvantage of User defind function?

2301

Explain the use of rows option in imp command.

1091

What do you mean by merge in oracle and how can you merge two tables?

951

For More Un-Answered { Oracle } Questions Click Here