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.

2. What is difference between View and materialisedView? 3. New features in Oracle9i SQL? No., We cannot perform DML operations on Dual table. because we dont have the access permissions on that table. For security reasons,we hide data from the database then we use Views.If there are more transactions on the base table then we use materialized views. New features of Oracle 9i are: i)Merge statement ii) Flashback query iii) Functionbased indexes iv) Materialised View enhancement and......

We can not use trigger in procedure, but can call procedure in trigger. When u r trigger code is too lengthy then write procedure and call in trigger. e.g create trigger as On Begin CALL End

D&B and Oracle have formed a strategic alliance to offer a solution that combines the specific strengths of both parties, D&B's global data content and Oracle Financials. The joint offering, D&B for Oracle Applications, seamlessly integrates D&B business information into Oracle Financials, enabling users to store up-to-date identification, demographic, risk/financial, and socioeconomic information on their vendors and customers. D&B information, which may be updated via batch and online access, is used for both strategic and tactical analyses and decision support.

5. How do I find out the time taken by oracle to execute the sql statement or a procedure? Is it possible by firing a select?

For ORACLE to display the amount of time it takes to execute a statement or procedure in the SQL window you need to set some environmental,in this case you have to execute the following statement SQL> set timing on after doing this execute a simple satement like SQL> select sysdate from dual; You will get the output as follows with the elapsed time below it as follows... SYSDATE --------- 17-AUG-06 Elapsed: 00:00:00.62

6. How specifically will D&B data be accessed from within the Oracle Applications?

Currently, users with authorized access to Oracle's A/P and A/R modules will be able to access D&B's information base via the Internet.

D&B for Oracle Applications is a comprehensive solution that includes D&B's Data Rationalization Services and online access to D&B's global information base. These services provide Oracle customers with the ability to cleanse and standardize existing customer and vendor identification information; identify and eliminate redundant records; validate the existence and status of newly acquired customers and vendors; and obtain value-added demographic, risk, financial and socio-economic data to maximize ongoing decision support.

Create table privilege is not granted in order to grant create table privilege, connect to sys/manager and then type grant create table to

Developers and DBAs use these tools to get the best performance out of their applications. The execution plan is made available to you in the form of rows inserted into a special table called a plan table. Once you have access to a plan table, you are ready to run the EXPLAIN PLAN statement. The syntax is as follows:

10. I have scenario where I need to upload data from XML file into a table. XML file is a predifined format. How can I achieve this, Is there any built in package similar to SQL loader to extract required field values and upload them into table.

There are couple of ways to do it other than loader. 1) You can load the file into a clob and make use of the sys.xmlparser and sys.xslprocessor packages to load it to files. 2) You can load the file into a clob and make use of the dbms_xmlsave package to load it. The above one allows you to customize and load whereas here the available functionality is minimal.