The modulos operator (%) CANNOT be used on the _____ datatype.
Tinyint
Money
Float
Smallint
Table with no clustered index is called
AOL
BOL
DOL
Heap
Which one is the level of index in the below list
Intermediate level
Header level
Data level
Binary level
Maximum columns added into index
31
32
225
2065
Which one of the following constraints enforces domain integrity?
Primary key constraint
Check constraint
Foreign key constraint
Unique constraint
Which database objects can a stored procedure create?
View
Index
Default
Extended stored procedure
Sub-queries can be nested in…
DELETE statements only.
INSERT statements only.
UPDATE statements only.
UPDATE, DELETE, INSERT and SELECT statements.
What will be the result of the following SQL statement: SELECT LEFT('Have a nice day.', 4)
Have
The statement will produce error.
day.
Missing parameter
Which one is the parameter of SP_Configure
allow updates to system tables
locking
Setup
no of lock
Which is not parameters for STUFF function
First string
Second string
Start position
End position