Oracle Interview Questions and Answers - DoAnswers.com

The First Database Designed for Grid Computing Oracle Database 10g delivers record-breaking performance and scalability on Windows, Linux, and UNIX servers and provides fast ROI by moving from a single server to Grid Computing without changing a single line of code. Oracle Database 10g delivers better results by automating administrative tasks, providing industry-leading security and regulatory compliance features, and enabling the highest availability with Real Application Clusters. With a range of editions and lower operating cost versus IBM DB2 and Microsoft SQL Server, it's the ideal choice for large enterprises and small and medium businesses alike. Compare editions to find the one that's right for you.

ORACLE Interviews are getting tough these days as the technology grows faster. To get through the ORACLE interview one needs to update him/herself in a regular manner. Having said that, just before the interview, it is very important to have a quick glance of the reputed ORACLE questions and answers to make yourself comfortable during the interview process. This is where DoAnswers.com helps you in renewing yourself on ORACLE and various other technologies interview preparation.

11. Is it possible to use relational operatior in decode function. I want display the detials of salary from the emp table. If salary < 2000 it is low and if salary > 2000 it is high. How to incorporate this.

12. Is there a way/tool to automatically export data via forms. Kinda like Dataloader that is used to import data via forms?

Toad Tool exist in not only importing or exporting the data but also creating the database objectthe object etc

13. Need to generate an 6 digit sequence number automatically for employee number

in front end (Oracle Applications) Module HRMS eg - 000001,000002. select max(nvl(empno,000000))+1 from emp U have to wrie this in pre_text_item trigger of the empno item.

14. Rownum is used to get tha top-N values. What if I want to know the value at specific position?

EX: A table emp has two columns e_name and e_salary. How can I list the e_name of the employee who is getting the third highest salary? You can use this:- select e_name from emp where salary= (select min(e_salary) from (select e_salary from emp order by e_salary desc) Tab1 where rownum < 4) The inner query gives the 3rd highest salary and the outermost query gives the name of the empoyee.

for that i need output like this.. countof female countofmale totalcount foreg 5 3 8 Select Male,Female,Other,(Male+Female+Other) total from ( select count(*) Male from voters where gender = 1 ) A, ( select count(*) Female from voters where gender = 0 ) B, ( select count(*) Other from voters where gender is null ) C ; or Select Male,Female,Other,(Male+Female+Other) total from ( select count(*) Male from voters where gender = 1 ) A, ( select count(*) Female from voters where gender = 0 ) B, ( select count(*) Other from voters where gender is null ) C

Report Customization means taking the orginal oracle report and modifing ( changing layout, query- by adding some more field....) according the user requirement. There are 5 types of report triggers 1)Before parameter form 2)After parameter form 3)Before Report 4)Between Pages 5)After Report They are executed in above sequence; i.e if you want to assign some value or execute dynamic query(we modify query at run time based on input parameters) we right After parameter form or Before Report and any deletion is done at after report.

sql is a standard language to access relational databases whereas sql*plus is a tool (has a command line interface) to implement sql.

18. What types of D&B information will be available within Oracle Applications?

Business identification, demographic data, socioeconomic data, linkage, financial statement, risk and payment data will be offered through various data packages and full text reports.