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"

What exactly is the Full-Text Catalog?

The commands GRANT and REVOKE are examples of :

We are creating Stored Procedure in Database and using 'sp_' prefix in its name. Which of the following statements is correct in accordance with the performance of the Stored Procedure execution?

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

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?

A ________ is an alphanumerical, hexadecimal, or numberic constant.

Which of the following storage options can be used to store LOBs and save storage?

In SQL Server 2012 introduces what new feature?

Which of the following operators allows the specification of two or more expressions to be used for a query search?

Which of the following is not considered a Boolean Operator?