Interview Questions

You need to first create a table in oracle that matches with the fields of the XML data.

So to get the XMl into the table, you can create a generic procedure that moves an XML document into a table by converting the elements to Oracle Canonical format.

Oracle Canonical format is as follows:

<ROWSET>

   <ROW>  

     <column_name_1 />

     .

     .

     </ROW>

     <ROW>

         <column_name_1 />

         .

         .

      </ROW> 

        .

        .

</ROWSET>        

ROW is used for the table names

ROWSET is used for the XML document

You can get the XML into the canonical form using XSL:

<?xml version="1.0"?>

<xsl:stylesheet 

             xmlns:xsl="https://www.w3.org/1999/XSL/Transform"                   

             version="1.0">

     <xsl:template match="/">

          <ROWSET>

               <ROW>

                         <Attribute_name>                      

                             <xsl:value-of select="Table_name/Attribute_name" />

                         </Attribute_name>

                < /ROW>

          </ROWSET>

     </xsl:template>

</xsl:stylesheet>

To transform the XML document into the canonical form, you can write a procedure. Make sure you include the line below in your procedure code:

v_rows := DBMS_XMLStore.insertXML(

                v_context,    

                XMLType.transform(p_xml_in, p_xsl_in));

The only remaining step is calling your procedure: 

DECLARE

   v_xml XMLType := XMLType( YOUR XML Document );

   v_xsl XMLType := XMLType( YOUR XSL Document );

BEGIN 

   procedure_name(v_xml, v_xsl, 'table_name');

END;

An abstract class is defined with the keyword abstract Eg:
public abstract class MyClass { }

BATCH INPUT SESSION is an intermediate step between internal table and database table. Data along with the action is stored in session ie data for screen fields, to which screen it is passed, program name behind it, and how next screen is processed.

iOS Simulator can be used to test mobile applications. Xcode tool that comes along with iOS SDK includes Xcode IDE as well as the iOS Simulator. Xcode also includes all required tools and frameworks for building iOS apps.  However, it is strongly recommended to test the app on the real device before publishing it.

To format the ABAP code 'pretty printer' is used.

Do businesses want employees at every level who develop ideas to solve problems and embrace opportunities?

Yes.

In a range of studies since 2003, The Accenture Institute for High Performance found that the highest performing companies in the world encourage staff at every level to solve problems to make things new and better.

The Ernst & Young Connecting Innovation to Profit report (2010) found that fast-moving, agile companies recognise the importance of creative thinking skills, concluding that “the ability to manage, organise, cultivate and nurture creative thinking is directly linked to growth and achievement."

The IBM Global CEO Survey 2010 interviewed more than 1500 CEO’s from 60 countries and 33 industries, concluding that creativity is the most important leadership trait for the future. They suggested that “more than rigor, management discipline, integrity or even vision – successfully navigating an increasingly complex world will require creativity.”

Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.

MDM is short for Mobile Device Management. The term generally refers to a system that hooks into the operating system on smartphones to collect information or apply restrictions and security precautions that may be sound company policy. This is true for Miradore Online, our free MDM product you can get started with today.