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. 5 seconds

  2. 8 seconds

  3. 10 seconds

  4. 15 seconds

  5. 1 minute

Answer: Answer is b

1. ALTER permission on the database.

2. CONTROL permission in the database.

3. ALTER ANY SCHEMA permission and CREATE XML SCHEMA COLLECTION permission in the database

Which of the above permissions is/are required to create an XML SCHEMA COLLECTION?

  1. 1 and 2

  2. 2 and 3

  3. 1 and 3

  4. 1 or 2 or 3

  5. 1 and 2 and 3

Answer: Answer is e
Further Reading:

Useful resources, Granting Permission to Create an XML Schema Collection


  1. True

  2. False

Answer: Answer is a
Further Reading:

Useful resources, Error List Window (Management Studio)


  1. Sqlinst

  2. Sqlcmd

  3. Sqlexpress

  4. sqldef

Answer: Answer is c
Further Reading:

Useful resources, Instance Name (SQL Server Express)


  1. CASCADE

  2. DELETE

  3. SET NULL

  4. SET DEFAULT

Answer: Answer is b

  1. –p

  2. –P

  3. –z

  4. -Z

Answer: Answer is d
Further Reading:

Useful resources, sqlcmd Utility


  1. Only SELECT

  2. Only SELECT and INSERT

  3. Only SELECT, INSERT, UPDATE, DELETE

  4. Only SELECT, INSERT, UPDATE, MERGE, DELETE

Answer: Answer is d
Further Reading:

Useful resources, TOP


  1. 58

  2. 116

  3. 128

  4. 512

Answer: Answer is b
Further Reading:

The complete name for a stored procedure or a global temporary stored procedure, including ##, cannot exceed 128 characters. The complete name for a local temporary stored procedure, including #, cannot exceed 116 characters. Useful resources, CREATE PROCEDURE


  1. ALTER DATABASE DROP ENCRYPTION KEY

  2. DROP DATABASE ENCRYPTION KEY

  3. ALTER DATABASE REMOVE ENCRYPTION KEY

  4. REMOVE DATABASE ENCRYPTION KEY

Answer: Answer is b
Further Reading:

Useful resources, Transparent Data Encryption (TDE)


  1. ALTER Resource Governor Enable

  2. ALTER Resource Governor Reconfigure

  3. ALTER Resource Governor Set

  4. None of the above

Answer: Answer is b
Further Reading:

Useful resources, ALTER RESOURCE GOVERNOR


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.

;