Tag: SQL
What is the best SQL data type for a Boolean?
BIT
Correct Answer!
REAL
UNIQUEIDENTIFIER
NCHAR
TINYINTEGER
Show Answer!
In SQL Server which of the following data types has the highest data type precedence?
INT
DATETIME
Correct Answer!
VARCHAR
FLOAT
NUMERIC
Show Answer!
How many Clustered index can there be in a table in SQL?
1
Correct Answer!
0
2
Infinite
Show Answer!
The data type which is supported in SQL?
CURSOR
ALL OF THESE
Correct Answer!
MONEY
TINYINT
IMAGE
Show Answer!
Which of the following is the correct SQL statement to use to remove rows from a table?
DELETE
Correct Answer!
DROP
REMOVE
All of the options
Show Answer!
What will be the output of the following statement? SELECT ROUND(123.89, -1)
120.00
Correct Answer!
123.00
124.00
123.90
Show Answer!
With _ locking a user may have to redo their work when a conflict occurs
optimistic
Correct Answer!
deterministic
pessimistic
Show Answer!
Which of the following commands denote DML commands
INSERT
Correct Answer!
CREATE
ALTER
All of these
Show 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 DUPLICATES
UNIQUE
None of these
Show Answer!
Which is not included in an ACID model of a Database
Consistency
Connectivity
Correct Answer!
Atomicity
Isolation
Durability
Show Answer!
Which one of the following trigger is run before the DML ?
INSTEADOF
Correct Answer!
INSERT
UPDATE
AFTER
Show Answer!