Questions

Using automatically incrementing IDENTITY columns is very popular with database developers. You don’t need to explicitly calculate unique surrogate keys when inserting new data, the IDENTITY column functionality does that for you. The IDENTITY feature also allows you to specify useful Seed and Increment properties. When you use an INSERT statement to insert data into a table with an IDENTITY column defined, SQL Server will generate a new IDENTITY value.

You can use the @@IDENTITY variable and the SCOPE_IDENTITY and IDENT_CURRENT functions to return the last IDENTITY value that has been generated by SQL Server. This is very useful when you need to return the key for the row that has just been inserted, back to the caller.

Ans: ANN.

Sol.Give each letter a number according to its position in the alphabet.

TED =20+5+4(29)

ANN=1+14+14(29)

(George  and Mary each add to 57).

As per the latest updates, India is :

• Largest producer of milk.

• Largest producer of millets in the world.

• Largest producer of jute.

• Largest producer of ginger.

• Largest producer of bananas.

• Largest producer of castor oil seeds.

• Largest producer of mangoes.

• Largest producer of safflower oil seeds.

• Largest producer of papayas.

• Largest producer of cottonseed (As per International Cotton Advisory Committee (ICAC) report for the month of March 2017)

• Second largest producer of tea, the first position being held by China.

• Second largest producer of sugarcane, the first position being held by Brazil.

• Second largest producer of wheat, the first position being held by China.

• Second largest producer of onions, the first position being held by China.

• Second largest producer of potatoes, the first position being held by China.

• Second largest producer of garlic, the first position being held by China.

• Second largest producer of rice, the first position being held by China.

• Second largest producer of cement., next to China.

• Second largest producer of silk, the first position being held by China.