You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?
Log and data files for your databases as well as the Quorum drive and the backup folders.
Anti-virus programs can exist on the same server as SQL Server without an issue if you [...]
What will be the result of the last SELECT statement if you execute the T-SQL script below as a sysadmin.
USE master
GO
IF DB_ID(’test_schema’) IS NOT NULL
DROP DATABASE test_schema
GO
CREATE DATABASE test_schema
GO
USE test_schema
GO
CREATE SCHEMA Schema1
CREATE TABLE Table1 (col1 int)
GO
CREATE SCHEMA Schema2
GO
CREATE TABLE Table1 (col1 int)
GO
SELECT SCHEMA_NAME(schema_id), name FROM sys.objects
WHERE name = ‘Table1′
Schema1 Table1
dbo Table1
The correct answer is A. [...]
What level of permissions does a user need to create an assembly with UNSAFE permissions?
sysadmin
Only a sysadmin can create assemblies that are specified as unsafe.
Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?
SQL Server Integration Services
You must install Integration Services in order to properly create and [...]
You have to create some T-SQL that produces an order of players in a golf tournament. Players who finish on the same number of strokes have to be given the same finishing place denoting that they will have an equal prize amount. What T-SQL function can achieve this?
RANK alongside the OVER function where the OVER [...]
In SQL Server 2005, can you include a user-defined role as a member of another user-defined role?
Yes
Yes you can.
In SQL Server 2005, what does instance aware mean for a service?
The service is installed once for each instances on the server.
An instance aware service is one that is installed for each instance on the server. An [...]
You have installed one new assembly on your SQL Server 2005 server and are wondering if it is being used on the production server. How can you easily monitor to see if this assembly is being used?
You can monitor the Assembly Load event in a trace.
While you could scan trace results for the names of [...]
What does this return?
SELECT USER_NAME() — Returns Andy
EXECUTE AS TechPreparation
GO
EXECUTE AS Steve
GO
REVERT
GO
SELECT USER_NAME()
TechPreparation
The execution context switches can be nested, so changing to TechPreparation , then Steve, then issuing a Revert will return you to the context of TechPreparation . This works in the same manner as a stack.
In building a PDF report in Reporting Services [...]
In replication, what is each set of the source data that is replicated from the source server called?
Article
Each set of source data that is replicated is called an article.
In SSIS, what is the difference between output columns and external columns?
External columns represent the meta data of external data sources and output columns are used be [...]
You are developing security policy for your SQL Servers and have all of the data entry clerks needing access to a series of tables. You create a Data Entry role and assign the proper permissions as well as add the users.
You then find out that Bob is a part of the HR group because of [...]
To recover an instance of Notification Services in 2005 on another server, what information would you need?
A backup of the database holding Notification Services and the XSD and XSLT files as well as the name and password for the service account.
To recover SSNS, you need the database backup as well as the operational files, XSD [...]
Latest Jobs