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

Oracle General (1803)
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 5620

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

1 12846

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 6519

how to store only time in a data base table

2 5144

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

5 7510

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

1 7269

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

1 4177

WHAT IS ecc 6.0

2206

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,

2458

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 6853

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

TCS,

2467

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

Cap Gemini,

1 5935

does Oracle has only one table space?

Oracle,

1 4262

how to unbreak sequence numbers during intereptions

Ion Exchange,

1 3762

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

Un-Answered Questions { Oracle }

How to start instance with a minimal initialization parameter file?

1085

How to insert a record into a table?

1124

How do I manually uninstall oracle client?

1157

How to use "startup" command to start default instance?

1103

How do we create privileges in oracle?

1103

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1170

Does a dba have to file taxes?

632

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

624

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5484

Who developed oracle & when?

1061

How to define an anonymous procedure with variables?

1245

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2233

Difference between cartesian join and cross join?

1094

Explain prerequisites and post activities of oracle database installation

2185

What are a query and state the different types of queries and their uses?

1068

For More Un-Answered { Oracle } Questions Click Here