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 Knowledge of SQL Server 2008 Skills

  1. DEFAULT

  2. CONTENT

  3. DOCUMENT

  4. FILESTREAM

Answer: Answer is b
Further Reading:

Useful resources, columns


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

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.

;