Technology Questions

Q:

What is the use of FOR XML in SQL Server?

Answer

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. 

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1840
Q:

What is an ABAP?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 1839
Q:

Whats a struct?

Answer

A struct is a special C data type that encapsulates other pieces of data into a single cohesive unit. Like an object, but built into C.

Report Error

View answer Workspace Report Error Discuss

0 1838
Q:

What is the difference between array and ArrayList ?

Answer

Array is collection of same data type. Array size is fixed, It cannot be expanded.


 


But ArrayList is a growable collection of objects.ArrayList is a part of Collections Framework and can work with only objects.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1837
Q:

Differentiate linked list from arrays.

Answer

Arrays can store data in a fix allotted space. The use of linked list allows more flexibility because space is dynamically allocated as needed.

Report Error

View answer Workspace Report Error Discuss

0 1836
Q:

What are windows object and navigator object in JavaScript?

Answer

Windows object is top level object in Java script. It contains several other objects such as, document, history, location, name, menu bar etc., in itself. Window object is the global object for Java script that is written at client-side.


Information pertaining to the client browser and system is returned by the navigator object of JavaScript. Navigator object is the top level object for all users.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1835
Q:

What is the Dictionary class?

Answer

- The Dictionary class is an abstract class.


- Classes like Hashtable which map keys to values inherit from this class. 


- An object can be looked for if a dictionary and a key is provided.


- Any non-null object can be used as a key and as a value.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 1833
Q:

Describe the functionality of accelerometer of an iphone

Answer

iPhone responds to motion using a built-in accelerometer.
The accelerometer detects the movement and changes the display accordingly, at the time of rotating iPhone from portrait to landscape. 

Report Error

View answer Workspace Report Error Discuss

0 1830