You manage an instance of SQL Server 2008. The server contains several databases that have differentcollations.
An assistant administrator named Paul wants to create a table in a database named Products , but heis unfamiliar with collation precedence rules.
You want to inform Paul about collation precedence rules that he should consider when specifying differentcollations for columns in the table.
Which statements are true? (Choose all that apply.)