News:
1GB
2GB
4GB
Useful resources,xml (Transact-SQL)
The plus (+) and minus (-) operators cannot be used to perform increment/decrement operations on datetime and smalldatetime values.
True
False
Useful resources, Datetime arithmetic in SQL
A view has a data of its own
Data can be inserted into the table using its own view
Data can be updated in the table using its own view
A table can be altered by altering its corresponding view
A View is derived from another table
sp_helptext salary
sp_define salary
sp_help salary
define salary
Useful resources, sp_help
Many-to-One is a type of relationship in RDBMS.
False
True
Select (salary+40^2*30/5) from employees
+
*
/
^
Useful resources, Operator Precedence (Transact-SQL)
Students - - - - - - Name Hobbies John Driving Miller Fishing David Writing Robert Singing
What will be the output of the following query?
Select Substring(Hobbies,3) From students Where name= "john"
Dri
ivi
iving
ving
It will give an error
Join
Group By
Order By
Union All
Where
The "text" and "ntext" data type can store character based data. These data types can be used in joins.
True
False
Useful resources,ntext, text, and image (Transact-SQL)
Tuples
Elements
Objects
Attributes
Constraints