70-433 · Question #92
You are working with a SQL Server 2008 instance that is configured to use the Latin1_General_CS_AS collation. You create a database by using the following statements. CREATE DATABASE TestDB COLLATE…
Sign in or unlock 70-433 to reveal the answer and full explanation for question #92. The question stem and answer options stay visible for context.
Question
You are working with a SQL Server 2008 instance that is configured to use the Latin1_General_CS_AS collation. You create a database by using the following statements. CREATE DATABASE TestDB COLLATE Estonian_CS_AS; GO USE TestDB; GO CREATE TABLE TestPermTab (PrimaryKey int PRIMARY KEY, Col1 nchar ); You implement a temporary table named #TestTempTab that uses the following code. use TestDB; GO CREATE TABLE #TestTempTab (PrimaryKey int PRIMARY KEY, Col1 nchar ); INSERT INTO #TestTempTab SELECT * FROM TestPermTab; You need to identify which collation will be assigned to #TestTempTab. Which collation will be assigned?
Options
- ANo-collation
- BEstonian_CS_AS
- CLatin1_General_CS_AS
- DThe collation selected by the Windows system locale of the server
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.