Oracle Interview Questions
Questions Answers Views Company eMail

I HAVE A REPORT LAYOUT LIKE THIS RUNDATE -FIELD DEPTNO-FIELD ------------------------------------------------------------ ------------------- EMPNO-----ENAME------SAL-----COMM----MGR----- ------------------------------------------------------------ ------------------ ------- ------------ -------- -------- -------- MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE. I WANT LIKE THIS ....

4 5763

What is the diff between Oracle and SQL Server

1 4298

Maximum how many triggers can be updated in table ?

Accenture, Cap Gemini,

5 15426

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

1920

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1758

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2646

what is diff between pre insert,on insert,post insert triggers?

IRISA,

1 9175

which statement is running fastly ie insert or delete?

Oracle,

13 17131

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

Mind Tree,

2 4997

10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables

Mind Tree,

6 7598

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

Infosys,

2 7874

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

Wipro,

1992

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

1944

i want to know about the javaBean.what is its purpose and how it can use in Forms.

Logisoft,

2161

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

1893


Un-Answered Questions { Oracle }

Explain the truncate in oracle?

757


What is snapshot is too old? Give and example for better understand.

1351


what are bitmap indexes? How does they work?

2013


How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

1885


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

1886


How to run the anonymous block again?

862


What is oracle server autotrace in oracle?

883


Is it possible to insert comments into sql statements return in the data model editor ?

2359


What are the various constraints used in oracle?

814


What are the original export and import utilities?

796


If you see contention for library caches how you can fix it?

408


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

868


What is dba in sound level?

400


How to find the duplicate rows count from employees table in oracle?

870


Explain procedure to change characterset of a database.

458