Recent Interview Questions I face

[mansi sharma]

1)What are different types of Cursors?
Explain me in detail plz.

2)What are diff types of locks?
In some sites-

Four types of locks availbale in ADODB

1.Optimistic
2.pessimistic
3.batch optimistic
4.readonly

In some sites
Forwardonly , lock,adLockUnspecified

What are exact locks,can somebody tell me?

3) What is Z order Precedence?

4) dim X,Y as integer
They ask me X is of which datatype in VB & in VB.net?
I told integer in both Vb & VB.Net,they told me wrong? Whats the ans?

[sknake]

>> 1)What are different types of Cursors?
http://www.databasejournal.com/features/mssql/article.php/1439731/Using-SQL-Server-Cursors.htm

>> 2)What are diff types of locks?

<table_hint> ::=
[ NOEXPAND ] {
INDEX ( index_value [ ,...n ] ) | INDEX = ( index_value )
| FASTFIRSTROW
| FORCESEEK
| HOLDLOCK
| NOLOCK
| NOWAIT
| PAGLOCK
| READCOMMITTED
| READCOMMITTEDLOCK
| READPAST
| READUNCOMMITTED
| REPEATABLEREAD
| ROWLOCK
| SERIALIZABLE
| TABLOCK
| TABLOCKX
| UPDLOCK
| XLOCK
}

See: http://technet.microsoft.com/en-us/library/ms187373.aspx

3) What is Z order Precedence?
Lets say you have 3 buttons that are all docked to "Top". How do you determine which button is the first, second, then third? The answer is the Z-Order. You can right click on the bottom-most button and click "Send to Back" and it will make that button the top most. Likewise you can click on the topmost button and click "Bring To Front" to send it to the bottom.

>>4) dim X,Y as integer

In Visual Basic 6.0, you can declare variables of different types in the same statement, but you must specify the data type of each variable or it defaults to Variant. The following example shows multiple declarations and their resulting data types.

Dim I, J As Integer ' I is Variant, J is Integer.
Dim L As Integer, M As Integer ' L is Integer, M is Integer.
Dim N As Integer, X As Double ' N is Integer, X is Double.

http://msdn.microsoft.com/en-us/library/56ht941f.aspx

In VB.NET:

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
		Dim x, y As Integer
		Console.WriteLine("x: " + VarType(x).ToString())
		Console.WriteLine("y: " + VarType(y).ToString())
		System.Diagnostics.Debugger.Break()
	End Sub

Results in:

x: Integer
y: Integer