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.

Mcq Answers for SQL Server

SELECT Name FROM person.employees WHERE Name LIKE '[_]n' GO 

Which of the following values will be returned by the above code?

  1. In

  2. Sin

  3. _n

  4. All of the above

Answer: Answer is a
Further Reading:

Useful resources, LIKE


  1. core.sp_delete_data

  2. core.sp_purge_data

  3. core.sp_remove_data

  4. None of the above

Answer: Answer is b
Further Reading:

Useful resources, Managing Data Collection


DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

  1. It checks the current iDentity fielD value of the specifieD table.

  2. It sets the identity field value to the new reseed value.

  3. It sets the identity field value to 1.

  4. All of the above.

Answer: Answer is a, b
Further Reading:

Useful resources, DBCC CHECKIDENT


  1. n (n= number of expressions in the element list passed to CUBE)

  2. n+1 (n= number of expressions in the element list passed to CUBE)

  3. 2^n (n= number of expressions in the element list passed to CUBE)

  4. 2^n+1 (n= number of expressions in the element list passed to CUBE)

Answer: Answer is c
Further Reading:

Useful resources, GROUP BY


  1. 1 to 116

  2. 1 to 127

  3. 1 to 128

  4. 1 to 512

Answer: Answer is c
Further Reading:

Useful resources, Identifiers


  1. ABCD

  2. ABDC

  3. DCAB

  4. DCBA

Answer: Answer is a

  1. Push, delete

  2. Insert, pop

  3. Put, extract

  4. Push, pop

Answer: Answer is d
Further Reading:

Useful resources, Stack


  1. 15

  2. 20

  3. 50

  4. 100

Answer: Answer is c

  1. Breadth-first search

  2. Depth-first search

Answer: Answer is a

CREATE TABLE Orders (         

OrderID Int IDENTITY NOT NULL,        

 SalesPersonID Int NOT NULL,        

 RegionID Int NOT NULL,         

OrderDate Datetime NOT NULL,         

OrderAmount Int NOT NULL )

Which statement will produce the report correctly?

  1. SELECT TOP 5 OrderAmount, SalesPersonID FROM orders

  2. SELECT TOP 5 OrderAmount, SalesPersonID FROM orders ORDER BY OrderAmount DESC

  3. SELECT TOP 5 WITH TIES OrderAmount, SalesPersonID From Orders

  4. SELECT TOP 5 WITH TIES OrderAmount, SalesPersonID From Orders ORDER BY OrderAmount

Answer: Answer is b
Further Reading:

The company need the highest sate amount. So we need to order amount in DESC order. Useful resources, TOP, WITH TIES


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.

;