1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


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 4445

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

 1 11980

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 5329

how to store only time in a data base table

 2 4103

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

 5 5431

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

 1 6399

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

1 3350

WHAT IS ecc 6.0

1647

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,

1916

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 5686

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

TCS,

1904

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

Cap Gemini,

1 5019

does Oracle has only one table space?

Oracle,

1 3426

how to unbreak sequence numbers during intereptions

Ion Exchange,

1 2797

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

 1740

Un-Answered Questions { Oracle }

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

637

What is data file?

609

What is iapxtb structure? Explain its importance

1

What are the types of data contol?

316

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1600




What is a sub query? What are its various types?

577

What is null value in oracle?

622

What is an Oracle Data Block?

626

What are the various constraints used in oracle?

546

How to clone the database using RMAN back

1613

What is the difference between substr and instr?

512

what is difference between group above and group left report

3193

What do we mean by record group in oracle forms?

602

What is the data pump import utility?

575

What does dba stand for database?

292

For More Un-Answered { Oracle } Questions Click Here