News:

SQL Table To C# Entity Model ConverterEntity Model (Class Properties) to SQL Table ConverterIf you encounter any trouble visiting our site, please contact us.

Online Test MS SQL Server 2005

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

Answer: Answer is c

  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

Answer: Answer is c

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

Answer: Answer is c

  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

Answer: Answer is b

  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

Answer: Answer is b

  1. Complete backup

  2. Differential backup

  3. Transaction Log backup

  4. Partial backup

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

Answer: Answer is a

  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

Answer: Answer is a

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

Answer: Answer is a

  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

Answer: Answer is b
Further Reading:

Useful resources, DECLARE CURSOR


Advertisement

BCS Preparation now even more easy. ReadBD is the place where you can find all kind of resources to be successful in BCS,Bank,Islami Bank exam and interview.

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;