News:
Order - - - - - Orderid Customerid Orderdate Comments Select ISNULL (Comments, 'No comments') AS comments From Order
What will be the output of the above query?
The output will always be "No comments" irrespective of the value in the Comments field
The output will be null in all the rows
The output will be "No comments", when the database entry is Null
The output will be "No comments", when the database entry is Not Null
This query is erroneous
A view is like a window through which data on tables can be viewed or changed
A view is stored as a select statement only
A view cannot be derived from another view
A view has no data of its own
SELECT * FROM [Table_Name] WHERE LOWER(Field_Name) = 'name'
The required keyword ('name') is already in the LOWER case
The query requires more time to convert to the LOWER case
T-Sql is not case sensitive. Hence, the LOWER keyword is not required
Instead of '=' the operator, 'LIKE' should be used
Modifications made in a table will be faster if the number of indexes is more
Modifications made in a table will be slower if the number of indexes is more
The number of indexes does not affect the modification process of a table
Select usercomments From Comments Order by commentid
Select usercomments From Comments Order by commentid desc
Select usercomments From Comments Order by usercomments
Select usercomments From Comments Order by usercomments desc
Complete backup
Differential backup
Transaction Log backup
Partial backup
File(s) and Filegroup(s) backup
The Full-Text catalog is an index for searching specific keywords
The Full-Text catalog is a file which contains full-text indexes
The Full-Text catalog is basically an inbuilt function for checking the validation of a text
The Full-Text catalog is a system trigger for checking text validation
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?
Select Customers.Customername,(Select Min(Orderdate) From Orders Where Customers.Customerid=Orders.Customerid) From Customers
Select Customers.Customername,(Select Max(Orderdate) From Orders Where Customers.Customerid=Orders.Customerid) From Customers
Select Customers.Customername,(Select Orderdate From Orders Where Customers.Customerid=Orders.Customerid) From Customers
Select Customers.Customername,Min(Orders.Orderdate) From Orders,CustomersWhere Customers.Customerid=Orders.Customerid
None of these
DECLARE qselect CURSOR ON SELECT * FROM qlist
DECLARE qselect CURSOR FOR SELECT * FROM qlist
DECLARE qlist CURSOR ON SELECT * FROM qselect
DECLARE qselect CURSOR AS SELECT * FROM qlist
Useful resources, DECLARE CURSOR