Depending on the scenario you may want to use both SET or SELECT.

Following are few scenarios for using SET

• If you are required to assign a single value directly to variable and no query is involved to fetch value
• NULL assignments are expected (NULL returned in result set)
• Standards are meant to be follow for any planned migration
• Non scalar results are expected and are required to be handled
  
  Using SELECT is efficient and flexible in the following few cases.
• Multiple variables are being populated by assigning values directly
• Multiple variables are being populated by single source (table , view)
• Less coding for assigning multiple variables
• Use this if you need to get @@ROWCOUNT and @ERROR for last statement executed

Ans. Wired, Guided, Twisted Pair Cable.

Ans. you must pass theory and practical exam separately. if crossed mean he/she didn't get qualifying marks in the theory then it means he/she is failed in that perticular paper and have to attempt it again. 

/ is a divisional operator which gives the result of a division..

While % is a modulus operator which gives the remainder of a particular division

8

6

And.

• Primary keys: Contain one or more columns whose combined values uniquely identify every row in a table. Each table can have only one primary key.
• Alternate keys: Contain one or more columns whose combined values uniquely identify every row in a table.

Ans. Officially called the Unicode Worldwide Character Standard, it is a system for "the interchange, processing, and display of the written texts of the diverse languages of the modern world." It also supports many classical and historical texts in a number of languages.

Currently, the Unicode standard contains 34,168 distinct coded characters derived from 24 supported language scripts. These characters cover the principal written languages of the world.

In Unicode, a script is a collection of letters and other written signs used to represent textual information in one or more writing systems.

Some scripts support one and only one writing system and language, for example, Armenian.

Other scripts support many different writing systems; for example, the Latin script supports English, French, German, Italian, Vietnamese, Latin itself, and several other languages.

Ans. 2 times 

First time as (5<= 10 ) so condition true

Now y = 10 and  x = 5 

Second time as ( 5 <= 10 )

now y = 2 and x = 5 

now condition is false. 

Dear dinesh,

it is difficult to explain everything as in ouput questions we have for , while and do while loops and each loop execute differently when resume , continue commands are used so ask question and i will try to explain it clearly.