Consider the following table:

Order
- - - - -
Orderid
Customerid
Orderdate
Comments

Select ISNULL (Comments, 'No comments') AS comments From Order

What will be the output of the above query?

1. The output will always be "No comments" irrespective of the value in the Comments field

2. The output will be null in all the rows

3. The output will be "No comments", when the database entry is Null

4. The output will be "No comments", when the database entry is Not Null

5. This query is erroneous

Which one of the following statements regarding "views" is incorrect?

1. A view is like a window through which data on tables can be viewed or changed

2. A view is stored as a select statement only

3. A view cannot be derived from another view

4. A view has no data of its own

What is wrong with the following query in accordance with performance?

SELECT * FROM [Table_Name] WHERE LOWER(Field_Name) = 'name'

1. The required keyword ('name') is already in the LOWER case

2. The query requires more time to convert to the LOWER case

3. T-Sql is not case sensitive. Hence, the LOWER keyword is not required

4. Instead of '=' the operator, 'LIKE' should be used

Which of the following statements is correct?

1. Modifications made in a table will be faster if the number of indexes is more

2. Modifications made in a table will be slower if the number of indexes is more

3. The number of indexes does not affect the modification process of a table

The table Comments has an auto incremented column called "Commentid" and a "UserComments" column, both of which store the comments of the users visiting the site. What will be the correct query to display the latest comments first?

1. Select usercomments From Comments Order by commentid

2. Select usercomments From Comments Order by commentid desc

3. Select usercomments From Comments Order by usercomments

4. Select usercomments From Comments Order by usercomments desc

Which of the following is not a type of Database backup in the SQL SERVER 2005?

1. Complete backup

2. Differential backup

3. Transaction Log backup

4. Partial backup

5. File(s) and Filegroup(s) backup

What exactly is the Full-Text Catalog?

1. The Full-Text catalog is an index for searching specific keywords

2. The Full-Text catalog is a file which contains full-text indexes

3. The Full-Text catalog is basically an inbuilt function for checking the validation of a text

4. The Full-Text catalog is a system trigger for checking text validation

Consider the following tables:

Customers

- - - - - - - -

Customerid

Customername

Address

Orders

- - - - -

Orderid

Customerid

Orderdate

Comments

What will be the query to fetch Customername and 1st Orderdate for order placed by each customer?

1. Select Customers.Customername,(Select Min(Orderdate) From Orders Where Customers.Customerid=Orders.Customerid) From Customers

2. Select Customers.Customername,(Select Max(Orderdate) From Orders Where Customers.Customerid=Orders.Customerid) From Customers

3. Select Customers.Customername,(Select Orderdate From Orders Where Customers.Customerid=Orders.Customerid) From Customers

4. Select Customers.Customername,Min(Orders.Orderdate) From Orders,CustomersWhere Customers.Customerid=Orders.Customerid

5. None of these

You want to select a row using cursors in the table 'qlist'. Which of the following statements DECLARES a cursor 'qselect' to perform the desired operation?

1. DECLARE qselect CURSOR ON SELECT * FROM qlist

2. DECLARE qselect CURSOR FOR SELECT * FROM qlist

3. DECLARE qlist CURSOR ON SELECT * FROM qselect

4. DECLARE qselect CURSOR AS SELECT * FROM qlist