SQL

What is the best SQL data type for a Boolean?

BIT Correct Answer!REALUNIQUEIDENTIFIERNCHARTINYINTEGERShow Answer!

In SQL Server which of the following data types has the highest data type precedence?

INTDATETIME Correct Answer!VARCHARFLOATNUMERICShow Answer!

How many Clustered index can there be in a table in SQL?

1 Correct Answer!02InfiniteShow Answer!

The data type which is supported in SQL?

CURSORALL OF THESE Correct Answer!MONEYTINYINTIMAGEShow Answer!

SQL is a procedural language

False Correct Answer!TrueShow Answer!

Which of the following is the correct SQL statement to use to remove rows from a table?

DELETE Correct Answer!DROPREMOVEAll of the optionsShow Answer!

In SQL a NULL value is treated as a blank or 0

False Correct Answer!TrueShow Answer!

What will be the output of the following statement? SELECT ROUND(123.89, -1)

120.00 Correct Answer!123.00124.00123.90Show Answer!

With _ locking a user may have to redo their work when a conflict occurs

optimistic Correct Answer!deterministicpessimisticShow Answer!

Which of the following commands denote DML commands

INSERT Correct Answer!CREATEALTERAll of theseShow Answer!

What is the different between Truncate and Delete ?

Truncate deletes all items and delete only deletes each row Correct Answer!Truncate resizes the data page of a table and delete performs operations...