Oracle Interview Questions
Questions Answers Views Company eMail

can we pass two out parameters at a time in function?please answer to my question

Wipro,

3 4966

types of receipts and detail desription about recipts and tables effected by receipts?

1603

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 3931

Which is better Oracle or MS SQL? Why?

Bally Technologies,

2 5396

i want department wise maxmum salary and empolyee name

9 27081

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

IBM,

1 3146

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 2642

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

Zensar,

2 4465

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

Zensar,

5 7009

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2239

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1848

how to find count rows in table without count function?

Oracle,

3 5608

i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?

Oracle,

5 6044

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

Infosys,

4 6850

What is Tax Categories?

1605


Un-Answered Questions { Oracle }

How to drop an existing view in oracle?

545


How to create a new oracle data file?

534


What is concurrency in oracle?

523


What is memo?

307


How to use group functions in the select clause using oracle?

572






Which environment variables are absolutely critical in order to run the OUI?

1628


What do you mean by oracle dba?

273


Why does for update in oracle 8 cause an ora-01002 error?

522


What is rac?

1


What are the common oracle dba tasks?

594


How to use attributes of the implicit cursor in oracle?

533


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1782


How to compare dates in oracle sql?

631


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1778


List out the difference between commit, rollback, and savepoint?

599