The login timeout when you try to connect to a server must be a number between __________.

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?

Which of the following namespaces is used to manage the audit configuration programmatically in SQL Server 2008?

What happens to the audit records if a failure to write the Audit event does NOT trigger the SQL Server instance to shut down?

Which of the following code snippets causes only partition number 1 to be rebuilt while changing the compression of a partitioned table?

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?

To find all employees whose name ends with 'ith', complete this sql statement: 'SELECT * FROM employees WHERE name ' ...

Which service is used to run scheduled jobs?

Which of the following statements prevents users from performing actions?

True or false? Foreign keys always point to other tables.

By default, SQL Server treats NULL as what data type