News:

• SQL Table To C# Entity Model Converter • Entity Model (Class Properties) to SQL Table Converter • If you encounter any trouble visiting our site, please contact us.

Online Test Knowledge of SQL Server 2008 Skills

Which of the following rules must be followed for combining the result sets of two queries by using UNION?

  1. The number of columns must be same in all queries.

  2. The order of columns must be same in all queries.

  3. The data types of the columns of the queries must be compatible.

  4. There should be at least one common column in the tables which are part of the UNION operation.

Answer: Answer is a, b, c
Further Reading:

Useful resources, union

Windows Security log can be specified as a target for Audit in SQL Server 2008.

  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

What is the default precision of the date data type 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

What range is supported by the TIME data type in SQL Server 2008?

  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

Which of the following evaluation modes of Policy-Based Management CANNOT be automated in SQL Server 2008?

  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

Which of the following Audit objects primarily describes the destination where the audit data of SQL Server 2008 gets stored?

  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

Which of the following is the default authentication mode for sqlcmd 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

Suppose e1 and e2 denote two decimal expressions with precisions p1 and p2 and scales s1 and s2, respectively. What is the result precision of the following operation on the two expressions?

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

PRIMARY KEY constraint defaults to __________ index

  1. Clustered

  2. Nonclustered

  3. None of the above

Answer: Answer is a
Further Reading:

Useful resources,Creating Clustered Indexes

Which of the following formats are supported by the language_term argument while altering a full-text stoplist in SQL Server 2008?

  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

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.

;