Database Administration 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.

Let p be the speed of man in kmph

According to the given data in the question,

Distance travelled by bus in 10 min with 20 kmph == Distance travelled by man in 8 min with (20 + p) kmph in opposite direction

=> 20 x 10/60 = 8/60 (20 + p)

=> 200 = 160 + 8p

=> p = 40/8 = 5 kmph.

Here it is an idiom that says The cricket match proved to be a big draw means it stands as a huge attraction.

18 tens 20 ones, the given stateent can be split into

18 tens = 18 x 10 = 180

20 ones = 20 x 1 = 20

Then add both => 180 + 20 = 200

Hence, 18 tens 20 ones = 200.

The primary Author of HTML is Tim Berners-Lee, a scientist and academic, with the assistance of his colleagues at CERN, an international scientific organization based in Geneva, he did this. Berners-Lee invented the World Wide Web in 1989 at CERN.

Upto first 5 minutes I, J and K will fill => 5[(1/20)+(1/30)+(1/40)] = 65/120

For next 6 minutes, J and K will fill => 6[(1/30)+(1/40)] = 42/120

So tank filled upto first 11 minutes = (65/120) + (42/120) = 107/120
So remaining tank = 13/120

Now at the moment filling with C and leakage @ 1/60 per minute= (1/40) - (1/70) = 3/280.
So time taken to fill remaining 13/120 tank =(13/120) /(3/280) = 91/6 minutes

Hence total time taken to completely fill the tank = 5 + 6 + 91/6 = 26.16 minutes.

A digital computer accepts, processes and outputs data in digitized forms. The digital computer was developed primarily in Unites States of America.