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!
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!
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...
To remove duplicate rows from the result set of a select use the following keyword(s):
DISTINCT
Correct Answer!NO DUPLICATESUNIQUENone of theseShow Answer!
Which is not included in an ACID model of a Database
ConsistencyConnectivity
Correct Answer!AtomicityIsolationDurabilityShow Answer!
Which one of the following trigger is run before the DML ?
INSTEADOF
Correct Answer!INSERTUPDATEAFTERShow Answer!