Interview Questions

Video: Videos can be edited, shared. High quality VGA video can be shot in portrait or landscape.

- 3 Megapixel Camera: Still photos with greater quality can be taken

- Voice control: It recognizes the names in contacts and recognizes the music on iPod.

- Compass: iPhone 3GS has built-in digital compass, used to point the way.

- Internet Tethering: Internet surfing can be done from anywhere. A 3G connection can be shared on Iphon3 with Mac notebook or laptop.. 

- The web browser visits a website using the HTTP and then it keeps the track of the identity of the user visiting the web page.

- The cookies of HTTP get stored with the personal information of the user and it doesn’t accept the information. 

- Users accept the cookies as by rejecting all the cookies will load the web page in longer time and it will not be desired by the users. 

- Even if the cookie is being rejected a session cookie is being kept for use as it is the provision given to the web browser to use it. 

- The cookies gets stored temporary basis depending on the user of accepting or rejecting it and it basically saves the session so that the duration of the page load can be reduced.

The cookie settings include the enabling and disabling of the services that are used with the web browsers.

The following steps are taken to set the cookies:

- The TOOLS menu is being opened on web browser and the privacy tab is selected from where the privacy of individual user can be managed. 

- Using the ADVANCED tab the options to set the cookies will be visible and it will allow the overriding of cookie. 

- The cookies can be accepted by checking the first party cookies or the third party cookies. Out of these choices the first party cookies provide more security. 

- Check the checkbox for "Always allow session cookies" so that the session cookies can be maintained. 

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;

Math object has two constant : Math.PI and Math.E

Math object has following functions:

- Math.abs(val1);

It will give absolute value of val1.

- Math.max(val1,val2);

This fuction will return maximum value from val1 and val2.

- Math.random();

This function will return a random number between 0 and 1.

- Math.floor(val1)

This function will returns decimal value of val1

Enterprise systems (ES) are large-scale application software packages that support business processes, information flows, reporting, and data analytics in complex organizations.

Here option A) The software is expressly built to allow companies to mimic their unique business practices is not TRUE about enterprise systems.

JAR files are java's version of ZIP files. In fact, JAR uses the ZIP file format.

uses:

- to compress a number of . class files into one file

- to make a java executable JAR file.