Interview Questions

 The proximity sensor immediately turns off the display when the iPhone is lifted to ear. With this sensor the power is saved and accidental dialing is prevented.

The display is automatically brightens the iPhone by the ambient light sensor when the sunlight or bright rooms and dims in darker places. 

Server-based network: Provide centralized control of network resources and rely on server computers to provide security and network administration.

peer-to-peer network: computers can act as both servers sharing resources and as clients using the resources.

1:m

Arrays are created by using new Array() in Java Script.

For example : var employees = new Array();

The elements to this array is assigned as follows :

employees[0] = "Kumar"

employees[1] = "Fedrick"

The storage of cookies on the hard disk depends on OS and the browser. The Netscape navigator on Windows, the file cookies.txt contains all the cookies. The path is :

c:\Program Files\Netscape\Users\username\cookies.txt

The Internet Explorer stores the cookies on a file by name username@website.txt is

c:\Windows\Cookies\username@Website.txt

Sample Answers :

(i) Upset but did not show it, that is the nature of the job, this things happen, the patients care takes priority.

(ii) I have not experienced this necessarily, but I have had my nurse mentor cancel on me because of a family emergency. In this situation I still attended my clinical and worked with a different nurse mentor. I quickly adapt to situations, which is an important quality in a nurse. In this situation I would stay until a substitute is able to come in. I would do this to ensure patient safety and maintain positive staff morale. It is important to recognize that getting sick is inevitable, and I will most likely be in the same situation one day and will need staff to pick up my shift.

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;

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.