Interview Questions

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

- Notification messages to the user from an Android enabled device can be displayed using Intents.

- There are two types of Intents - Explicit Intent, Implicit Intent.

Implicit Intent:

- In case of Implicit Intent, an intent is just declared. 

- It is for the platform to find an activity that can respond to it.

- Since the target component is not declared, it is used for activating components of other applications.

Explicit Intent

- Explicit intent specifies the particular activity that should respond to the intent. 

- They are used for application internal messages.

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

drawImage(image,x,y) method is used to draw an image on the canvas.

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.

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.

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;

The average propensity to consume (APC) is the ratio of consumption expenditures (C) to disposable income (DI), or APC = C / DI. 

Hence, APC = consumption/income.