What is the maximum storage capacity of XML data type in SQL SERVER 2005?

1. 1GB

2. 2GB

3. 4GB

State whether True or False

The plus (+) and minus (-) operators cannot be used to perform increment/decrement operations on datetime and smalldatetime values.

1. True

2. False

Which of the following statements regarding "views" are incorrect?

1. A view has a data of its own

2. Data can be inserted into the table using its own view

3. Data can be updated in the table using its own view

4. A table can be altered by altering its corresponding view

5. A View is derived from another table

Which of the following commands will be used to see the structure of the table named 'salary'?

1. sp_helptext salary

2. sp_define salary

3. sp_help salary

4. define salary

State whether True or False.

Many-to-One is a type of relationship in RDBMS.

1. False

2. True

Which of the following operators will be evaluated first in the following statement?

Select (salary+40^2*30/5) from employees

1. +

2. *

3. /

4. ^

Consider the following table "Students":

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"

1. Dri

2. ivi

3. iving

4. ving

5. It will give an error

Which clause will be used to extract data from Tables A and B having a similar structure but no relation between themselves?

1. Join

2. Group By

3. Order By

4. Union All

5. Where

State whether True or False.

The "text" and "ntext" data type can store character based data. These data types can be used in joins.

1. True

2. False

Columns are called _____________ of a table in a relational model.

1. Tuples

2. Elements

3. Objects

4. Attributes

5. Constraints