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 5505

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

1 12765

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 6414

how to store only time in a data base table

2 5033

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

5 7307

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

1 7179

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

1 4103

WHAT IS ecc 6.0

2145

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,

2405

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 6727

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

TCS,

2394

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

Cap Gemini,

1 5848

does Oracle has only one table space?

Oracle,

1 4163

how to unbreak sequence numbers during intereptions

Ion Exchange,

1 3659

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

2261

Un-Answered Questions { Oracle }

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

1127

Explain what are the uses of rollback segment?

1004

Is java required for oracle client?

992

What do database buffers contain?

1023

How is clustered index different from non-clustered index?

What is StandAlone Agent and default port number?

696

How to add another datafile to a tablespace?

1033

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4354

How to generate query output in html format?

1111

What is an anonymous block?

1232

What is the difference between count (*), count (expression), count (distinct expression)?

1002

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1861

What are the various oracle database objects?

1142

How to get a list of all background sessions in the database?

988

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

539

For More Un-Answered { Oracle } Questions Click Here