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

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 6185

What is the diff between Oracle and SQL Server

1 4582

Maximum how many triggers can be updated in table ?

Accenture, Cap Gemini,

5 16255

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

2130

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

1959

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?

2809

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

IRISA,

1 9461

which statement is running fastly ie insert or delete?

Oracle,

13 18444

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 5352

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 8206

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 8348

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,

2145

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.

2150

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

Logisoft,

2410

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.

2109

Un-Answered Questions { Oracle }

Can we convert a date to char in oracle and if so, what would be the syntax?

960

What are the types of locks in database?

560

What is the easiest method to create a file on unix?

524

Where do we use connected and un connected lookups?

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2950

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

549

How would you determine what sessions are connected and what resources they are waiting for?

2074

What do you mean by redo log file mirroring?

978

Tell me about standby database? What should we watch out for?

501

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1727

Explain the dml?

921

What are oracle functions?

976

What is meant by raw datatype?

1005

What is the Repository and how many types of repository?

534

What is transport network substrate (tns) in oracle?

993

For More Un-Answered { Oracle } Questions Click Here