Tag: databases

Questions Related to databases

Which inbuilt SP is used to parse the values from XML document
technology databases

  1. sp_xml_postdocument

  2. sp_xml_readdocument

  3. sp_xml_loaddocument

  4. sp_xml_preparedocument

Show answer
Correct Option: D

Which command is used to Check integrity of a table or indexed view?
technology databases

  1. DBCC CHECKIDENT

  2. DBCC CHECKTABLE

  3. DBCC CHECKALLOC

  4. DBCC CHECKINTEG

Show answer
Correct Option: B

Could we able to create a assembly in SQL 2005?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which function takes as argument a numeric value or an expression that can be evaluated to a number.
technology databases

  1. CEILING()

  2. SQRT()

  3. EXP()

  4. FLOOR()

Show answer
Correct Option: D

How will you call a function in sql server 2005
technology databases

  1. DatabaseName.fun.FunctionName()

  2. DatabaseName.dbo.FunctionName()

  3. Exercise.fun.GetFullName();

  4. Exercise.dbo.GetFullName();

Show answer
Correct Option: B

Select from the following, Transact-SQL internal keywords
technology databases

  1. datetime

  2. hierarchyid

  3. status

  4. views

  5. value

Show answer
Correct Option: A,B,C

How to rename a existing table.
technology databases

  1. sp_rename TableNewName, ExistingTableName;

  2. sp_renametable ExistingTableName, TableNewName;

  3. sp_rename ExistingTableName, TableNewName;

  4. sp_renametable TableNewName, ExistingTableName;

Show answer
Correct Option: C

By using TOP() can we able to update a record
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Oracle DATE columns always contain the date but not the time fields.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Analytic functions compute an aggregate value based on a group of rows and return a single row for each group.
technology databases

  1. True

  2. False

Show answer
Correct Option: B