Upwork KNOWLEDGE OF SQL SERVER 2008 SKILLS TEST 2016

Hello Freelancer, Welcome to allupworktestanswers.com Here to get the KNOWLEDGE OF SQL SERVER 2008 SKILLS TEST of Latest version 2016. We are ready here to provide your desire upwork test answer. We already tested all exam test information Available include on here. So Dear, Why Late? Read the below full exam test and get more information from our website.


 1. Which of the following statements using GROUP BY clause are allowed in SQL Server 2008?
Answers:
  1. SELECT Column1 + Column2 FROM Table GROUP BY Column1, Column2
  2. SELECT Column1, Column2 FROM Table GROUP BY Column1 + Column2
  3. SELECT Column1 + constant + Column2 FROM Table GROUP BY Column1 + Column2
  4. SELECT Column1 + Column2 FROM Table GROUP BY Column1 + Column2
2. What is the function of DBCC CHECKDB command in SQL Server 2008?
Answers:
  1. It checks the allocation of all the objects in the specified database.
  2. It checks the structural integrity of all the objects in the specified database.
  3. It checks for consistency in and between system tables in the specified database.
  4. It checks the consistency of disk space allocation structures of a specified database.
3. Which of the following compression features have been introduced in SQL Server 2008 that were NOT supported by SQL Server 2005?
Answers:
  1. Row-level compression
  2. Page-level compression
  3. Data file level compression
  4. Backup level compression
4. Which of the following rules must be followed for combining the result sets of two queries by using UNION?
Answers:
  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.
5. Which of the following scripting options are available while creating a script using the shortcut menu from the Object Explorer in SQL Server 2008 Management Studio?
Answers:
  1. DELETE To
  2. MERGE To
  3. CREATE INDEX To
  4. INSERT To
  5. UPDATE To
6. Which of the following options are available for the DATA_COMPRESSION clause specified for a table in SQL Server 2008?
Answers:
  1. Page
  2. Table
  3. Row
  4. Column
7. Which of the following methods can be specified for the lock escalation of a table in SQL Server 2008?
Answers:
  1. ENABLE
  2. AUTO
  3. DISABLE
  4. TABLE
  5. DEFAULT
8. Which of the following data types are supported by SQL Server 2008?
Answers:
  1. date
  2. datetime
  3. datetime1
  4. datetime2
  5. datetimeoffset
9. Which of the following statements are true?
Answers:
  1. IGNORE_DUP_KEY cannot be set to ON for XML indexes.
  2. IGNORE_DUP_KEY can be set to ON for spatial indexes.
  3. IGNORE_DUP_KEY can be set to ON for filtered indexes.
  4. IGNORE_DUP_KEY can be set to ON for XML indexes.
  5. IGNORE_DUP_KEY cannot be set to ON for indexes created on a view.
10. Which of the following statements are true regarding row and page compression in SQL Server 2008?
Answers:
  1. When a table or index is created, data compression is set to NONE, unless otherwise specified.
  2. Nonclustered indexes inherit the compression property of the table.
  3. New pages allocated in a heap as part of DML operations will not use PAGE compression until the heap is rebuilt.
  4. When you are compressing indexes, leaf-level pages can be compressed with only page compression.
11. Which of the following security features have been introduced in SQL Server 2008?
Answers:
  1. Extensible Key Management
  2. SOAP Security
  3. Hashing
  4. Transparent Data Encryption
12. Which of the following encryption algorithms are used by the Transparent Data Encryption security mechanism of SQL Server 2008?
Answers:
  1. Tiny Encryption Algorithm
  2. Advanced Encryption Standard(AES)
  3. Blowfish
  4. Triple Data Encryption Standard(3DES)
13. Which of the following formats are supported by the language_term argument while altering a full-text stoplist in SQL Server 2008?
Answers:
  1. Integer
  2. Binary
  3. Decimal
  4. Hexadecimal
14. Which of the following are valid DATETIME functions in SQL Server 2008?
Answers:
  1. SYSDATE()
  2. SYSTIME()
  3. SYSDATETIME()
  4. SYSUTCDATETIME()
15. Which of the following counters are used to monitor compression of the whole instance of SQL Server?
Answers:
  1. Page compression attempts/sec
  2. Row compression/sec
  3. Pages compressed/min
  4. Pages compressed/sec
  5. Rows compressed/min
16. Which of the following statements are true about the FILESTREAM argument of SQL Server 2008?
Answers:
  1. If a table contains FILESTREAM data and the table is partitioned, the FILESTREAM_ON clause must be included.
  2. The FILESTREAM column can be partitioned even if a table is not partitioned.
  3. There may not be a FILESTREAM filegroup if a table is not partitioned and the FILESTREAM_ON clause is not specified.
  4. The filegroup in the FILESTREAM_ON <filegroup>> clause must have one file defined for the filegroup.
17. Which of the following spatial data types are used in SQL Server 2008?
Answers:
  1. Geography
  2. Longitude
  3. Altitude
  4. Geometry
  5. Latitude
18. Which function/functions are performed by the following statement?
BCC CHECKIDENT (‘table_name’, RESEED, new_reseed_value)
Answers:
  1. It checks the current iDentity fielD value of the specifieD table.
  2. It sets the identity field value to the new reseed value.
  3. It sets the identity field value to 1.
  4. All of the above.
19. Which of the following statements are true about FILESTREAM storage in SQL Server 2008?
Answers:
  1. Transact-SQL can be used to SELECT, INSERT, UPDATE, DELETE FILESTREAM data.
  2. The size of the stored data is limited to 2 GB.
  3. You cannot take backup of a database without the FILESTREAM data.
  4. FILESTREAM storage is best used when the BLOB file sizes average 1MB or higher.
20. Which of the following permissions are required to create a view in SQL Server 2008?
Answers:
  1. CREATE VIEW permission in database
  2. ALTER permission on schema
  3. CONTROL permission on object
21. For which of the following data types can a COLLATE clause be applied?
Answers:
  1. text
  2. int
  3. varchar
  4. bigint
22. Columns marked with which of the following constraints/properties allow null values to be inserted in them?
Answers:
  1. PRIMARY KEY
  2. UNIQUE
  3. IDENTITY
  4. FOREIGN KEY
23. Analyze the following code used to update a Common Table Expression:
USE demodb
GO
DECLARE @a TABLE (ID int, Value int);
DECLARE @b TABLE (ID int, Value int);
INSERT @a VALUES (1, 10), (2, 20);
INSERT @b VALUES (1, 100),(2, 200);
WITH cte AS (SELECT * FROM @a)
UPDATE cte
SET Value = b.Value
FROM cte AS a
INNER JOIN @b AS b ON b.ID = a.ID
SELECT * FROM @a
GO
What Will be the output of the above code?
Answers:
  1. ID Value —– —– 1 100 2 200
  2. ID Value —– —– 1 10 2 100
  3. ID Value —– —– 1 10 2 200
  4. ID Value —– —– 1 100 2 100
24. The Server Audit object and the Server Audit Specification object of SQL Server 2008 share a __________ relationship.
Answers:
  1. One-to-one
  2. One-to-many
  3. Many-to-one
  4. Many-to-many
25. What is the maximum value for the sum of the values of MIN_CPU_PERCENT and MIN_MEMORY_PERCENT for all the resource pools of SQL Server?
Answers:
  1. 50
  2. 75
  3. 100
  4. 150
  5. 200
26. An identifier denoting a global temporary object in SQL Server 2008 starts with a ______ sign.
Answers:
  1. At sign(@)
  2. Double number(##)
  3. Underscore(_)
  4. None of the above
27. Which of the following features is used by SQL Server Audit to create and manage audits in SQL Server 2008?
Answers:
  1. System stored procedures
  2. Triggers
  3. SQL DDL syntax
  4. None of the above
28. What is returned by NULLIF if the two expressions that it compares are NOT equal?
Answers:
  1. It returns the first expression.
  2. It returns the second expression.
  3. It returns a null value.
  4. It returns an error.
29. User defined data type columns can be designated with ROWGUIDCOL.
Answers:
  1. True
  2. False
30. Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?
Answers:
  1. sqlcmd -S instanceName -o C:new.txt
  2. sqlcmd -S instanceName -i C:myScript.sql -o C:new.txt
  3. sqlcmd -S myServerinstanceName -o C:new.txt
  4. sqlcmd -S myServerinstanceName -i C:myScript.sql -o C:new.txt
31. Analyze the following code snippet:
DECLARE @myTime TIME(4) = ’02:02:02.234567 +01:01′
SELECT @myTime AS ‘@myTime’
What is the output of the above code?
Answers:
  1. 02:02:02.2345
  2. 02:02:02
  3. 02:02:02.2346
  4. An error is displayed
32. Which of the following is used by SQL Server 2008 Management Studio to execute scripts in regular mode in the Query Editor?
Answers:
  1. sqlcmd
  2. Microsoft .NET Framework SqlClient
  3. OLE DB provider
  4. None of the above
33. What is the default value of the SORT_IN_TEMPDB clause of the relational_index_option specified at the time of creation of an index on a table in SQL Server 2008?
Answers:
  1. ON
  2. OFF
  3. TRUE
  4. FALSE
34. Which of the following statements is NOT true about the UNIQUE constraint of SQL Server 2008?
Answers:
  1. Multiple UNIQUE constraints can be defined on a table.
  2. When using the UNIQUE constraint, only one null value is allowed per column.
  3. UNIQUE constraint cannot be referenced by a FOREIGN KEY constraint
35. Which of the following options is used to change the value of the password variable and exit using sqlcmd?
Answers:
  1. -p
  2. -P
  3. -z
  4. -Z
36. The regular identifiers of SQL Server 2008 may contain a range of _____________ characters.
Answers:
  1. 1 to 116
  2. 1 to 127
  3. 1 to 128
  4. 1 to 512
37. Which of the following evaluation modes of Policy-Based Management CANNOT be automated in SQL Server 2008?
Answers:
  1. On demand
  2. On change: prevent
  3. On change: log only
  4. On schedule
38. Which of the following statements is true if you create a global temporary table in SQL Server 2008 and specify a FOREIGN KEY with the CREATE TABLE command?
Answers:
  1. The table is created successfully with the FOREIGN KEY constraint.
  2. The table is not created and no message is returned.
  3. The table is created without the FOREIGN KEY constraint and a warning message is returned.
  4. The table is not created and an error message is displayed.
39. Which of the following features of SQL Server 2008 evaluates servers for compliance with a set of predefined conditions and prevents making undesirable changes to servers?
Answers:
  1. Data Compression
  2. Resource Governor
  3. Policy-Based Management
  4. Auditing
40. How many groupings are generated when CUBE is used with the GROUP BY clause of SQL Server 2008?
Answers:
  1. n (n= number of expressions in the element list passed to CUBE)
  2. n+1 (n= number of expressions in the element list passed to CUBE)
  3. 2^n (n= number of expressions in the element list passed to CUBE)
  4. 2^n+1 (n= number of expressions in the element list passed to CUBE)
41. Which of the following Audit objects primarily describes the destination where the audit data of SQL Server 2008 gets stored?
Answers:
  1. Server Audit object
  2. Server Audit Specification object
  3. Database Audit Specification object
42. Windows Security log can be specified as a target for Audit in SQL Server 2008.
Answers:
  1. True
  2. False
43. Which of the following is a valid code to delete a clustered index with a PRIMARY KEY constraint in SQL Server 2008?
Answers:
  1. ALTER TABLE Production.ProductCost DROP CONSTRAINT PK_Product WITH (ONLINE = ON) GO
  2. ALTER TABLE Production.ProductCostHistory DROP CONSTRAINT PK_Product DROP INDEX Index_Product WITH (ONLINE = ON) GO
  3. DROP INDEX Index_Product ON Production.ProductCost GO
44. What is the default timeout for login to sqlcmd while you try to connect to a server?
Answers:
  1. 5 seconds
  2. 8 seconds
  3. 10 seconds
  4. 15 seconds
  5. 1 minute
45. What is the default precision of the date data type in SQL Server 2008?
Answers:
  1. 4 digits
  2. 6 digits
  3. 8 digits
  4. 10 digits
46. What amount of storage is required by a date variable in SQL Server 2008?
Answers:
  1. 3 bytes
  2. 5 bytes
  3. 6 bytes
  4. 8 bytes
47. PRIMARY KEY constraint defaults to __________ index.
Answers:
  1. Clustered
  2. Nonclustered
  3. None of the above
48. Which of the following is a valid code to change the index created on a column of a table to page compression?
Answers:
  1. ALTER INDEX Index_Product ON Table1 WITH ( DATA_COMPRESSION = PAGE ) GO
  2. ALTER INDEX Index_Product ON Table1 SET ( DATA_COMPRESSION = PAGE ) GO
  3. ALTER INDEX Index_Product ON Table1 REBUILD WITH ( DATA_COMPRESSION = PAGE ) GO
  4. ALTER INDEX Index_Product ON Table1 REBUILD SET ( DATA_COMPRESSION = PAGE ) GO
49. What is the return type of the value returned by @@DATEFIRST in SQL Server 2008?
Answers:
  1. datetime
  2. date
  3. int
  4. tinyint
50. Which of the following features of SQL Server 2008 enables you to limit the memory used by incoming application requests?
Answers:
  1. Hot Add CPU
  2. Dynamic management views
  3. Resource Governor
  4. Backup Compression
51. Which data type of SQL Server 2008 converts itself into the type of data that is inserted into it?
Answers:
  1. real
  2. rowversion
  3. type_var
  4. sql_variant
  5. monetary
52. Analyze the following command:
-o “C:Folder<file_name>”
Which of the following statements is true if a file with the file name specified in the above command already exists?
Answers:
  1. An error is generated.
  2. The file is overwritten.
  3. None of the above.
53. Multiple CHECK constraints can be applied to a single column and a single CHECK constraint can be applied to multiple columns in SQL Server 2008.
Answers:
  1. True
  2. False
54. A local temporary stored procedure name can contain a maximum of __________ characters.
Answers:
  1. 58
  2. 116
  3. 128
  4. 512
55. Analyze the following code using wild card characters of SQL Server 2008:
SELECT Name
FROM person.employees
WHERE Name LIKE ‘[_]n’
GO
Which of the following values will be returned by the above code?
Answers:
  1. in
  2. sin
  3. _n
  4. All of the above
56. Which of the following is the default authentication mode for sqlcmd in SQL Server 2008?
Answers:
  1. Windows Authentication
  2. SQL Server Authentication
  3. IIS Authentication
  4. Digest Authentication
57. All MDX, DMX and XML/A errors are displayed in the Error List window of the SQL Server 2008. Management Studio.
Answers:
  1. True
  2. False
58. Which of the following stored procedures is used to delete data from the management data warehouse of a Data Collector?
Answers:
  1. core.sp_delete_data
  2. core.sp_purge_data
  3. core.sp_remove_data
  4. None of the above
59. What is the maximum number of processors that can be used in parallel plan execution using the MAXDOP option in SQL Server 2008?
Answers:
  1. 32 processors
  2. 50 processors
  3. 64 processors
  4. 75 processors
60. Which of the following arguments of the fn_get_audit_file() function of SQL Server 2008 specifies the directory indicating the location and audit file set to be read?
Answers:
  1. Initial_file_name
  2. File_pattern
  3. Audit_file_offset
  4. None of the above
61. Analyze the following code snippet:
DECLARE @myDate DATETIME2
SELECT @myDate = ‘2009/10/08 12:35:29.2348 +12:15’
SELECT @myDate AS ‘@myDate’
What is the output of the above code?
Answers:
  1. 2009-10-08 12:35:29
  2. 2009/10/08 12:35:29.2348000
  3. 2009-10-08 12:35:29.2348000
  4. 2009/10/08 12:35:29
62. What exactly is Full-Text Catalog in SQL Server 2008?
Answers:
  1. The Full-Text Catalog is an index for searching specific keywords.
  2. The Full-Text Catalog is a file which contains full-text indexes.
  3. The Full-Text Catalog is an inbuilt function for validating text data.
  4. The Full-Text Catalog is a system trigger for checking text validation.
63. Which of the following clauses of SQL Server 2008 avoids enforcing a constraint when repeated inserts are performed?
Answers:
  1. IDENTITY
  2. SPARSE
  3. NOT FOR REPLICATION
  4. COLLATE
64. Which of the following roles is required to connect to a Central Management Server?
Answers:
  1. ServerGroupReaderRole
  2. ServerGroupAdministratorRole
  3. PolicyAdministratorRole
  4. db_ssisoperator
65. What range is supported by the TIME data type in SQL Server 2008?
Answers:
  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
66. Which of the following is a valid syntax of the ALTER SERVER AUDIT statement used to enable a server audit?
Answers:
  1. ALTER SERVER AUDIT <audit_name> WITH (ENABLE=TRUE)
  2. ALTER SERVER AUDIT <audit_name> SET (ENABLE=TRUE)
  3. ALTER SERVER AUDIT <audit_name> WITH (STATE=ON)
  4. ALTER SERVER AUDIT <audit_name> SET (STATE=ON)
67. What is the name of the default instance installed by SQL Server 2008 Express in your computer?
Answers:
  1. sqlinst
  2. sqlcmd
  3. sqlexpress
  4. sqldef
68. Analyze the following permissions:
1.ALTER permission on the database.
2.CONTROL permission in the database.
3.ALTER ANY SCHEMA permission and CREATE XML SCHEMA COLLECTION permission in the database.
Which of the above permissions is/are required to create an XML SCHEMA COLLECTION?
Answers:
  1. 1 and 2
  2. 2 and 3
  3. 1 and 3
  4. 1 or 2 or 3
  5. 1 and 2 and 3
69. Which of the following statements is true regarding indexes in SQL Server 2008?
Answers:
  1. Modifications made in a table will be faster if the number of indexes is more.
  2. Modifications made in a table will be slower if the number of indexes is more.
  3. The number of indexes does not affect the modification process of a table.
70. How many audit action groups are available for a server in SQL Server 2008 to perform different actions on audit data?
Answers:
  1. 25
  2. 30
  3. 35
  4. 40
71. Which of the following data types can be specified as SPARSE?
Answers:
  1. image
  2. text
  3. nchar
  4. geography
72. Analyze the following code snippet for creating a stored procedure in SQL Server 2008:
CREATE PROCEDURE Person.GetEmployees
@LastName nvarchar(50),
@FirstName nvarchar(50)
AS
SET NOCOUNT ON
SELECT FirstName, LastName, JobTitle, Department
FROM Person.EmployeeDepartment
WHERE FirstName = @FirstName AND LastName = @LastName
GO
Which of the following is a valid code to execute the GetEmployees stored procedure?
Answers:
  1. EXECUTE Person.GetEmployees N’John’, N’Miller’
  2. EXEC Person.GetEmployees @LastName = N’Miller’, @FirstName = N’John’
  3. EXECUTE Person.GetEmployees @FirstName = N’John’, @LastName = N’Miller’
  4. All of the above
73. Starting from the lowest, arrange the following operators in the order in which they produce results in an SQL WHERE query.
1. >, >=, <, <=
2. <>
3. =
4. LIKE
Answers:
  1. 1,4,3,2
  2. 4,1,2,3
  3. 3,2,1,4
  4. 2,4,1,3
74. What is the default maximum precision of decimal data type in SQL Server 2008?
Answers:
  1. 16
  2. 18
  3. 38
  4. 48
75. What is the maximum number of columns that can be combined into a single composite index key?
Answers:
  1. 8
  2. 16
  3. 32
  4. 64
76. Which of the following values specifies that each instance of the XML data type in column_name can contain multiple top-level elements?
Answers:
  1. DEFAULT
  2. CONTENT
  3. DOCUMENT
  4. FILESTREAM
77. Which of the following is the correct order of steps to be followed while using the Transparent Data Encryption security feature of SQL Server 2008?
Answers:
  1. 1. Create a database encryption key. 2. Create or obtain a certificate protected by the encryption key. 3. Create a master key and protect it by the certificate. 4. Set the database to use encryption.
  2. 1. Create a database encryption key. 2. Create a master key. 3. Create or obtain a certificate protected by the master key. 4. Set the database to use encryption.
  3. 1. Create a master key. 2. Create or obtain a certificate protected by the master key. 3. Create a database encryption key and protect it by the certificate. 4. Set the database to use encryption.
78. Which of the following commands is used to start the Resource Governor in SQL Server 2008?
Answers:
  1. ALTER Resource Governor Enable
  2. ALTER Resource Governor Reconfigure
  3. ALTER Resource Governor Set
  4. None of the above
79. Which of the following commands is used to connect to a named instance of SQL Server using the sqlcmd utility of SQL Server?
Answers:
  1. sqlcmd -C myServerinstanceName
  2. sqlcmd -S instanceName
  3. sqlcmd -C instanceName
  4. sqlcmd -S myServerinstanceName
80. Which of the following commands is used to run a Transact-SQL script file by using sqlcmd?
Answers:
  1. sqlcmd -S myServerinstanceName -i C:newScript.sql
  2. sqlcmd -S instanceName -o C:newScript.sql
  3. sqlcmd -S myServerinstanceName -r C:newScript.sql
  4. sqlcmd -S instanceName -i C:newScript.sql
81. What is the default precision of the TIME data type in SQL Server 2008?
Answers:
  1. 5 digits
  2. 6 digits
  3. 7 digits
  4. 10 digits
82. Which of the following permissions is required to drop a stored procedure in SQL Server 2008?
Answers:
  1. SELECT permission on the schema
  2. ALTER permission on the schema
  3. CONTROL permission on the procedure
  4. Both a and b
  5. Either b or c
  6. Both b and c
83. The login timeout when you try to connect to a server must be a number between __________.
Answers:
  1. 0 and 66020
  2. 1 and 65530
  3. 0 and 65534
  4. 1 and 65535
84. In which of the following statements can TOP clause be used in SQL Server 2008?
Answers:
  1. Only SELECT
  2. Only SELECT and INSERT
  3. Only SELECT, INSERT, UPDATE, DELETE
  4. Only SELECT, INSERT, UPDATE, MERGE, DELETE
85. Which of the following default passwords is used by sqlcmd if -P option is used at the end of the command prompt without a password?
Answers:
  1. 0000
  2. NULL
  3. 1234
  4. None of the above
86. Which of the following namespaces is used to manage the audit configuration programmatically in SQL Server 2008?
Answers:
  1. Microsoft.SqlServer.Management.Smo
  2. Microsoft.SqlServer.Server
  3. Microsoft.sqlserver.management.common
  4. Microsoft.sqlserver.connectioninfo
87. What happens to the audit records if a failure to write the Audit event does NOT trigger the SQL Server instance to shut down?
Answers:
  1. The server blocks any new activity to be performed to the SQL Server instance.
  2. Audit events are buffered in memory until they can be flushed to the target.
  3. The audit is automatically disabled.
  4. An error is displayed.
88. Which of the following code snippets causes only partition number 1 to be rebuilt while changing the compression of a partitioned table?
Answers:
  1. ALTER TABLE Table1 REBUILD WITH (DATA_COMPRESSION = PAGE)
  2. ALTER TABLE Table1 REBUILD PARTITION = 1 WITH (DATA_COMPRESSION = NONE) GO
  3. ALTER TABLE Table1 REBUILD PARTITION ALL WITH (DATA_COMPRESSION = PAGE ON PARTITIONS(1) )
  4. All of the above
89. Analyze the following data types and schemas:
1.The SQL Server system data type.
2.The default schema of the current user in the current database.
3.The dbo schema in the current database.
In which order does the SQL Server Database Engine refer to type_name when a type_schema_name is NOT specified while creating a table in SQL Server 2008?
Answers:
  1. 3,2,1
  2. 2,3,1
  3. 3,1,2
  4. 1,2,3
  5. Any order
90. Which of the following options is NOT supported by the ON DELETE clause of a FOREIGN KEY constraint of SQL Server 2008?
Answers:
  1. CASCADE
  2. DELETE
  3. SET NULL
  4. SET DEFAULT
91. Suppose you create a stored procedure and save it in the database with “sp_” prefix. Which of the following statements is true regarding the execution of the stored procedure?
Answers:
  1. The prefix will speed up the execution of the stored procedure.
  2. The prefix will slow down the execution of the stored procedure.
  3. The performance of the stored procedure is not affected.
92. Each table in SQL Server 2008 can have up to ______ nonclustered indexes.
Answers:
  1. 777
  2. 888
  3. 999
  4. 1000
93. Analyze the following code which uses the TOP clause of SQL Server 2008:
USE Person
GO
DECLARE @p AS int
SELECT @p=10
SELECT TOP(@p)
FROM Employee
GO
What Will be the output of the above code?
Answers:
  1. No output is displayed.
  2. A list of first 10 employees is displayed from the Person database.
  3. An incorrect syntax error is displayed.
  4. None of the above.
94. Which of the following is a valid code to remove the key used to encrypt a database using Transparent Data Encryption algorithm?
Answers:
  1. ALTER DATABASE DROP ENCRYPTION KEY
  2. DROP DATABASE ENCRYPTION KEY
  3. ALTER DATABASE REMOVE ENCRYPTION KEY
  4. REMOVE DATABASE ENCRYPTION KEY
95. What should a computed column be marked as so that SQL Server Database Engine can physically store values in a table?
Answers:
  1. ON
  2. WRITE
  3. PERSISTED
96. The output of a Transact SQL query using the GROUPING function of SQL Server 2008 is of __________ return type.
Answers:
  1. varchar
  2. boolean
  3. int
  4. tinyint
97. What is the data type of the parameter “Audit_file_offset” of function “fn_get_audit_file()” in SQL Server 2008?
Answers:
  1. varchar
  2. nvarchar
  3. int
  4. bigint
98. Which of the following queries is used to rename a database in SQL Server 2008?
Answers:
  1. sp_renamedb oldname,newname
  2. sp_renamedb newname,oldname
  3. sp_dbrename oldname,newname
  4. sp_rename oldname,newname
99. Which of the following is the correct precedence order of the data types in SQL Server 2008?
1.xml
2.text
3.bigint
4.image
5.float
6.datetime
Answers:
  1. 1,2,3,4,5,6
  2. 6,5,4,3,2,1
  3. 1,6,5,3,2,4
  4. 1,4,2,3,6,5

Finally no more words require about the KNOWLEDGE OF SQL SERVER 2008 SKILLS TEST  information in this session of this content. If you are require knowing more, Please ask to us via our contact us form or comment box. Please make sure that, you don’t send Personal information via the Comment box.  Thank you very mutch for being with us.

0 comments: