Interview Questions

The JVM performs three main tasks:

• Loads code

• Verifies code

• Executes code

By setting the columnSpan property for cells of each row as required.

The persons whose primary investing objective is to preserve capital while generating a tax-free income stream, then municipal bonds are worth considering.

Municipal bonds (munis) are debt obligations issued by government entities. When you buy a municipal bond, you are loaning money to the issuer in exchange for a set number of interest payments over a predetermined period. At the end of that period, the bond reaches its maturity date, and the full amount of your original investment is returned to you.

Types of Municipal Bonds :

Municipal bonds come in the following two varieties:

1. General obligation bonds (GO)
2. Revenue bonds

General obligation bonds, issued to raise immediate capital to cover expenses, are supported by the taxing power of the issuer.

Revenue bonds, which are issued to fund infrastructure projects, are supported by the income generated by those projects.

Both types of bonds are tax exempt and particularly attractive to risk-averse investors due to the high likelihood that the issuers will repay their debts.

Cursors help you manipulate the information retrieved by select statements. This can be done by assigning a name to the cursor.

Example:

CURSOR emp_cur 

IS 

SELECT emp_number from employee_tbl where employee_name = name_in;

Types of Cursors:

Implicit cursors- These cursors are not declared by the programmer. They are issued when the SQL statement is executed. The open, close and fetching is done by itself.

Example:

UPDATE employee SET salary = salary * 2.1;

Here, an implicit cursor is issued to identify the set of rows in the table which would be affected by the update.

Explicit cursors- These cursors are defined by programmer. They are used in queries that return multiple rows.

Example:

CURSOR emp_cur 

IS 

SELECT emp_number from employee_tbl where employee_name = name_in;

-To store information usually relevant to browsers and search engines.

-To only store information usually relevant to browsers

-To only store information about search engines.

-To store information about external links

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. 

Java uses sand box security model.

A record data type represents a data type for that row in a database table. It lets u define your own records and not your own fields.