Which inbuilt SP is used to parse the values from XML document
sp_xml_postdocument
sp_xml_readdocument
sp_xml_loaddocument
sp_xml_preparedocument
Which command is used to Check integrity of a table or indexed view?
DBCC CHECKIDENT
DBCC CHECKTABLE
DBCC CHECKALLOC
DBCC CHECKINTEG
Could we able to create a assembly in SQL 2005?
True
False
Which function takes as argument a numeric value or an expression that can be evaluated to a number.
CEILING()
SQRT()
EXP()
FLOOR()
How will you call a function in sql server 2005
DatabaseName.fun.FunctionName()
DatabaseName.dbo.FunctionName()
Exercise.fun.GetFullName();
Exercise.dbo.GetFullName();
Select from the following, Transact-SQL internal keywords
datetime
hierarchyid
status
views
value
How to rename a existing table.
sp_rename TableNewName, ExistingTableName;
sp_renametable ExistingTableName, TableNewName;
sp_rename ExistingTableName, TableNewName;
sp_renametable TableNewName, ExistingTableName;
By using TOP() can we able to update a record
Oracle DATE columns always contain the date but not the time fields.
Analytic functions compute an aggregate value based on a group of rows and return a single row for each group.