Interview 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 1934
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 1933
Q:

Why cannot you run standard Java byte code on Android ?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

1 1929
Q:

What is Web Server?

Answer

Web server handles client side and server side validations and helps to deliver web content that can be accessed through the Internet protocols.


Examples:


Microsoft IIS (Internet Information Service)


Apache web server from Apache


Java web server


Pramathi web server etc...

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1929
Q:

What is web application?

Answer

Web application provides services (Free and Paid) apart from information.


Ex: Online Banking System


It provides Bank  information , Branches & ATM information, Loans information etc...


And It provides balance enquiry, Fund transfer, Bill payments like services.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1926
Q:

Explain how can you calculate manufacturing work in progress?

Answer



Manufacturing work in growth is when manufacturing firm transforms material into the work in process which includes labor, raw material, and factory overhead. You can add all the below factors to know the amount of the manufacturing work in progress.


    Labor amount


    Raw material inventory costs


    Production price


    A price of ending work in process for the accounting period


 

Report Error

View answer Workspace Report Error Discuss

Subject: Manufacturing

0 1924
Q:

What are the problems in processing batch input sessions and How is batch input process different from processing online ?

Answer

PROBLEMS:


i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue(log remains). However if session is processed we may delete it manually.


ii)if session processing fails data will not be transferred to SAP database table.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 1924
Q:

What is the primary reason to issue stock?

Answer

 The primary reason to issue stock is to raise money to start and maintain an ongoing business.


Other Reasons::


The reasons that a company might want to raise money by issuing stock are:


 



  • To develop new products


 



  • To buy more advanced equipment


 



  • To pay for new buildings and inventories


 



  • To hire more employees


 



  • To provide for a merger or acquisition


 



  • To decrease debt


 



  • To give company owners greater flexibility


 



  • To place a value on the company.

Report Error

View answer Workspace Report Error Discuss

Subject: Finance Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

0 1922