Technology Questions

SQL Server is having a fantastic feature to retrieve data persisted in the form of XML format. The data in the XML format can be retrieved using FOR XML clause appending to the SELECT statement.

It offers 3 modes.

- “FOR XML AUTO": Returns XML elements that are nested, based on which tables are listed in the "from" part of the query, and which fields are listed in the "select" part.

- "FOR XML RAW": Returns XML elements with the "row" prefix (ex: ""). Each column in a table is represented as an attribute and null column values aren't included.

- "FOR XML EXPLICIT": Explicit mode is the most complex shaping method used in SQL Server 2000. It allows users to query a data source in such a way that the names and values of the returned XML are specified before the query batch is executed. 

ABAP (Advanced Business Application Programming) is a high level programming language created by the German software company SAP. It is currently positioned as the language for programming SAP's Web Application Server, part of its NetWeaver platform for building business applications. Its syntax is somewhat similar to COBOL.

- The infinite file error can be solved when the data will be read continuously from the file. 

- The error can be solved by using the keys that provide only the resources that are required. 

- The following program is as follows:

osw.write ("HTTP/1.0 200 OK\n\n"); 

while (c != -1) { 

sb.append((char)c); 

c = fr.read(); 

} 

osw.write (sb.toString()); 

- This converts the requested file in such a way that if the file exists it shows the messages as ok otherwise it shows an error.

- Limited file access is to be given to the file to remove the error from the infinite file type.

String class objects are immutable objects and they represents strings( sequence of characters)

StringBuffer class objects are mutable objects representing strings and they are Thread safe

StringBuild class objects are also mutable objects representing strings and they are not Thread safe

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.

Java uses sand box security model.

Research in Motion, a Canadian company provided a proprietary operating system for BlackBerry.

The operating system provides support for Java MIDP 1.0 and WAP 1.2.

The current version supports Novell Group Wise and Lotus Notes.

Third-party software can be developed using BlackBerry APIs as well, with certain restriction functionality must be signed by RIM digitally, so that it can be associated to a developer account. 

Android uses Dalvik Virtual Machine (DVM) which requires a special bytecode. We need to convert Java class files into Dalvik Executable files using an Android tool called "dx". In normal circumstances, developers will not be using this tool directly and build tools will care for the generation of DVM compatible files.