News:
The number of columns must be same in all queries.
The order of columns must be same in all queries.
The data types of the columns of the queries must be compatible.
There should be at least one common column in the tables which are part of the UNION operation.
Useful resources, union
True
False
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
4 digits
6 digits
8 digits
10 digits
Useful resources, date data type
00:00:00.0000000 through 23:59:59.9999999
00:00:00.0000000 through 24:00:00.0000000
00:00:00.0000000 through 23:59:00.0000000
00:00:00.0000000 through 23:59:59.0000000
Useful resources, time
On demand
On change: prevent
On change: log only
On schedule
Useful resources,Policy-Based Management
Server Audit object
Server Audit Specification object
Database Audit Specification object
Useful resources,Auditing in SQL Server 2008
Windows Authentication
SQL Server Authentication
IIS Authentication
Digest Authentication
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
p1 - s1 + s2 + max(6, s1 + p2 + 1)
max(s1, s2) + max(p1 - s1, p2 - s2) + 1
p1 + p2 + 1
Useful resources,precision, scale, and length
Clustered
Nonclustered
None of the above
Useful resources,Creating Clustered Indexes
Integer
Binary
Decimal
Hexadecimal
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