Tag: SQL
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!
View text definitions are stored in which system table?
syscomments
Correct Answer!sysobjectssyscolumnssysviewsShow Answer!
Which of the following cannot be done by a SQL profiler?
Users monitoringBatch Execution
Correct Answer!To find the Stored procedures triggeredError trackingPerformance monitoringShow Answer!
Which of the command below undo the current transaction
ROLLBACK
Correct Answer!COMMITSAVEPOINTUNDOShow Answer!
SQL is a language for
Relational database management system
Correct Answer!Developing system programsBusiness applications onlyNone of theseShow Answer!