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 5517

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

1 12775

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 6421

how to store only time in a data base table

2 5041

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

5 7322

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

1 7185

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

1 4110

WHAT IS ecc 6.0

2147

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,

2411

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 6740

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

TCS,

2399

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

Cap Gemini,

1 5852

does Oracle has only one table space?

Oracle,

1 4173

how to unbreak sequence numbers during intereptions

Ion Exchange,

1 3667

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

2273

Un-Answered Questions { Oracle }

How to convert a date to char in oracle? Give one example.

1068

Whether any commands are used for months calculation? If so, what are they?

1097

What suggestions do you have to reduce the network traffic?

961

Name the three major set of files on disk that compose a database in Oracle?

1123

How do you set up your tablespace on installation level: low?

570

did u p prepared complex report

2001

Difference between Row Id and Row Num?

686

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

How to sort output in descending order in oracle?

1045

You have taken a manual backup of a datafile using os. How rman will know about it?

552

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2103

What is the difference between "as" and "is" in an oracle stored procedure?

991

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

604

What is the parameter mode that can be passed to a procedure?

1047

what is the difference between functional dependecy and multilevel dependency?

2462

For More Un-Answered { Oracle } Questions Click Here