Database Administration Questions

The letter 'E'.

As of the above given data,

It is in the 1st place in Earth, 2nd in Heaven and in the middle of the Sea.

It appears once in a Year and twice in a Week.

It is present in February, June, September, October, November & December.

But not in the Month.

Hence, it is the letter 'E'.

In a computer, memory is one part of Central processing unit i.e, CPU.

First is the sigh of the second.

Hence, Wince : Pain :: Prostration :Submissiveness.

GUI stands for Graphical User Interface.

A Graphical User Interface is a computer interface that allows users to interact with a device through graphical elements such as pictures and animations, as opposed to text-based commands.

A term used interchangeably with diskette is Floppy disk.

Mixing of blue and yellow colors make Green Color.

RYB (an abbreviation of red–yellow–blue) is a historical set of colors used in subtractive color mixing and is one commonly used set of primary colors. It is primarily used in art and design education, particularly painting.

RYB predates modern scientific color theory, which has determined that cyan, magenta, and yellow are the best set of three colorants to combine, for the widest range of high-chroma colors.

80x900/100 + 256 x 4 x ? = 1331 - 99

720 + 1024 x ? = 1232

? = 1232 - 720/1024

? = 512/1024 = 0.5

? = 0.5 

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.