Technology Questions

Q:

What are sensors in iphone?

Answer

 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. 

Report Error

View answer Workspace Report Error Discuss

0 1854
Q:

How do you load data from XML file to a ORACLE table?

Answer

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;

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1852
Q:

What are the challenges faced while successfully implementing Business intelligence?

Answer

Most companies grasp the potential value of successful business intelligence applications. However, a common challenge that IT professionals encounter is how to find successful BI application that are adopted by users and make a positive impact on the organization and on the bottom line. It can be difficult to structure effective BI project teams, select the right BI application, manage business-IT communications and measure BI success. BI is robust application, developing and optimizing successful BI application is always a challenge which involves structuring BI teams and managing business-IT communication.

Report Error

View answer Workspace Report Error Discuss

2 1851
Q:

Explain VBScript in detail.

Answer

This is a scripting language developed by Microsoft and is based loosely on Visual Basic. Its functionality in a web environment is dependant upon either an ASP engine or the Windows Scripting Host, and must be used on a Windows hosting platform. 

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1850
Q:

What is hierarchy relationship in a dimension. whether it is: 1) 1:1 2) 1:m 3) m:m

Answer

1:m

Report Error

View answer Workspace Report Error Discuss

2 1848
Q:

What are major types of networks and explain?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

0 1847
Q:

How to create arrays in JavaScript?

Answer

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"

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1836
Q:

Where can you test Apple iPhone apps if you don’t have the device?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

0 1836