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. Image

  2. Text

  3. Nchar

  4. geography

Answer: Answer is c
Further Reading:

Useful resources,sparse


  1. ON

  2. WRITE

  3. PERSISTED

Answer: Answer is c
Further Reading:

The Database Engine uses the PERSISTED keyword in the CREATE TABLE and ALTER TABLE statements to physically store computed columns in the table. Useful resources, computed columns


  1. One-to-one

  2. One-to-many

  3. Many-to-one

  4. Many-to-many

Answer: Answer is a
Further Reading:

Useful resources, Auditing in SQL Server 2008


  1. Multiple UNIQUE constraints can be defined on a table.

  2. When using the UNIQUE constraint, only one null value is allowed per column.

  3. UNIQUE constraint cannot be referenced by a FOREIGN KEY constraint

Answer: Answer is c
Further Reading:

Useful resources,Unique Constraints


  1. Text

  2. Int

  3. Varchar

  4. bigint

Answer: Answer is a, c
Further Reading:

Useful resources, collate


  1. 50

  2. 75

  3. 100

  4. 150

  5. 200

Answer: Answer is c
Further Reading:

Useful resources,resource pool


  1. 16

  2. 18

  3. 38

  4. 48

Answer: Answer is c

  1. SELECT Column1 + Column2 FROM Table GROUP BY Column1, Column2

  2. SELECT Column1, Column2 FROM Table GROUP BY Column1 + Column2

  3. SELECT Column1 + constant + Column2 FROM Table GROUP BY Column1 + Column2

  4. SELECT Column1 + Column2 FROM Table GROUP BY Column1 + Column2

Answer: Answer is a, d
Further Reading:

Useful resources,GROUP BY


  1. The server blocks any new activity to be performed to the SQL Server instance.

  2. Audit events are buffered in memory until they can be flushed to the target.

  3. The audit is automatically disabled

  4. An error is displayed.

Answer: Answer is b
Further Reading:

Useful resources, Auditing in SQL Server 2008


  1. 5 digits

  2. 6 digits

  3. 7 digits

  4. 10 digits

Answer: Answer is c
Further Reading:

Useful resources, time


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.

;