Sawaal

 Technology Questions

Popular Latest Rated
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 1451
Q:

What is BDC programming?

Answer

Transferring of large/external/legacy data into SAP system using Batch Input programming. Batch input is a automatic procedure referred to as BDC(Batch Data Communications). The central component of the transfer is a queue file which receives the data vie a batch input programs and groups associated data into “sessions”.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 1451
Q:

What are the steps involved in uploading the files using FTP client software?

Answer

- FTP is used to upload the files on the server from the client side where it is installed on the computer of clients. 


- FTP client is checked for the installation of the software and according to that the appropriate directory is uploaded on the hosting server. 


- The hosting server uploads the files that is being created by the user and set the permissions for it so that public can access it. 


- Web hosting uses different directories like HTML that is used as var/www/html that is determined using the FTP client. 


- Initial local directory is being set up using FTP client and it is where the website gets stored. 


- The transfer mode is being determined for the files that need to be transferred either in ASCII or BINARY mode.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1449
Q:

What is HTML5 Web Storage?

Answer

With HTML5, it is possible for the web pages to store the data locally in the user's browser. This web storage is much faster and secured than the cookies. Also, a larger amount of data can be stored without causing any adverse effect to the performance of the website. 


The data here is not included with every server request. It is used ONLY when it is asked for. It is only that particular web page that can access the data stored by itself.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1448
Q:

How to determine the state of a checkbox using Javascript?

Answer

var checkedP = window.document.getElementById("myCheckBox").checked;

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1447
Q:

What is the purpose of pseudo-elements?

Answer

Pseudo elements allow the use of the part of element and not the element itself. They are applied to block level element, which is used for the complete block for which the CSS is being written. This allow the subpart of an element to be styled like paragraphs and headings. For example:


selector:pseudo-element {property:value;}


p: first-line {text-transform: lowercase;}


It adds the style to the first line of the code in the paragraph.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1447
Q:

What is the use of Media Types in CSS?

Answer

Media types in CSS define the media like audio and video to be used in your HTML document to represent the properties in a better way. The font property can be used for media types as it can be used for print media or screen media. Document requires a defined media to represent the screen that can be read on the paper. It is used as:@media 


<html>


<head>


<style>


@media screen


{


p.test {font-family:verdana,sans-serif;font-size:14px;}


}


@media print


{


p.test {font-family:times,serif;font-size:10px;}


}


</style>


</head>


<body>


----------Your code here----------


</body>


</html>

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1447
Q:

What are the features of iphone 3G?

Answer

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.. 

Report Error

View answer Workspace Report Error Discuss

Subject: Mobile Technology

0 1447