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

  1. True

  2. False

Answer: Answer is a
Further Reading:

Windows Security log can be specified as a target for Audit (starting with the Windows Server® 2003 operating system).Useful resources,Auditing in SQL Server 2008


  1. 4 digits

  2. 6 digits

  3. 8 digits

  4. 10 digits

Answer: Answer is d
Further Reading:

Useful resources, date data type


  1. 00:00:00.0000000 through 23:59:59.9999999

  2. 00:00:00.0000000 through 24:00:00.0000000

  3. 00:00:00.0000000 through 23:59:00.0000000

  4. 00:00:00.0000000 through 23:59:59.0000000

Answer: Answer is a
Further Reading:

Useful resources, time


  1. On demand

  2. On change: prevent

  3. On change: log only

  4. On schedule

Answer: Answer is a
Further Reading:

Useful resources,Policy-Based Management


  1. Server Audit object

  2. Server Audit Specification object

  3. Database Audit Specification object

Answer: Answer is a
Further Reading:

Useful resources,Auditing in SQL Server 2008


  1. Windows Authentication

  2. SQL Server Authentication

  3. IIS Authentication

  4. Digest Authentication

Answer: Answer is a
Further Reading:

Windows Authentication is the default authentication mode for sqlcmd. To use SQL Server Authentication, you must specify a user name and password by using the -U and -P options. Useful resources,Start the sqlcmd Utility, sqlcmd utility


Operation: e1 / e2

  1. p1 - s1 + s2 + max(6, s1 + p2 + 1)

  2. max(s1, s2) + max(p1 - s1, p2 - s2) + 1

  3. p1 + p2 + 1

Answer: Answer is a
Further Reading:

Useful resources,precision, scale, and length


  1. Clustered

  2. Nonclustered

  3. None of the above

Answer: Answer is a
Further Reading:

Useful resources,Creating Clustered Indexes


  1. Integer

  2. Binary

  3. Decimal

  4. Hexadecimal

Answer: Answer is a, d
Further Reading:

language_term can be specified as a string, integer, or hexadecimal value corresponding to the locale identifier (LCID) of the language Useful resources, alter fulltext stoplist


  1. Image

  2. Text

  3. Nchar

  4. geography

Answer: Answer is c
Further Reading:

Useful resources,sparse


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.

;