Tag: SQL
What is the best SQL data type for a Boolean?
StuPick -
BIT
Correct Answer!REALUNIQUEIDENTIFIERNCHARTINYINTEGERShow Answer!
In SQL Server which of the following data types has the highest data type precedence?
StuPick -
INTDATETIME
Correct Answer!VARCHARFLOATNUMERICShow Answer!
How many Clustered index can there be in a table in SQL?
StuPick -
1
Correct Answer!02InfiniteShow Answer!
The data type which is supported in SQL?
StuPick -
CURSORALL OF THESE
Correct Answer!MONEYTINYINTIMAGEShow Answer!
Which of the following is the correct SQL statement to use to remove rows from a table?
StuPick -
DELETE
Correct Answer!DROPREMOVEAll of the optionsShow Answer!
What will be the output of the following statement? SELECT ROUND(123.89, -1)
StuPick -
120.00
Correct Answer!123.00124.00123.90Show Answer!
With _ locking a user may have to redo their work when a conflict occurs
StuPick -
optimistic
Correct Answer!deterministicpessimisticShow Answer!
Which of the following commands denote DML commands
StuPick -
INSERT
Correct Answer!CREATEALTERAll of theseShow Answer!
What is the different between Truncate and Delete ?
StuPick -
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):
StuPick -
DISTINCT
Correct Answer!NO DUPLICATESUNIQUENone of theseShow Answer!
Which is not included in an ACID model of a Database
StuPick -
ConsistencyConnectivity
Correct Answer!AtomicityIsolationDurabilityShow Answer!
Which one of the following trigger is run before the DML ?
StuPick -
INSTEADOF
Correct Answer!INSERTUPDATEAFTERShow Answer!
Popular
Chhattisgarh Quiz: 25 Multiple Choice Questions and Answers
Test your knowledge about Chhattisgarh! Each question is followed...
Telangana Quiz: 25 Multiple Choice Questions and Answers
Test your knowledge about Telangana with this quiz! Each...
Indian Politics Quiz 2025: 25 Multiple Choice Questions and Answers
Test your knowledge of the latest happenings in Indian...
Rivers Quiz: 25 Multiple Choice Questions and Answers
Test your knowledge about rivers from around the world...