You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. CK_DB contains a table named CK_Prod
where the Sales Product resides. You have received instruction to move CK_Prod’ test to a new
schema named CK_Tester. You need to complete this task using the appropriate Transact-SQL statement.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. A new Domain.com security policy requires allows members of a Windows group
name CK_Prod to build new links to the SQL Server instance that should occurs between the
business hours of 10:00 and 22:00. Furthermore, the other Domain.com users are not allowed to
connect the database at any time. At the bottom the Transact-SQL statements:

CREATE TABLE Security.RestrictedTester(
ProductID int NOT NULL IDENTITY(1,1),
GroupTest sysname NOT NULL,
RestrictedTesterTimeStart time NOT NULL,
RestrictedTesterTimeStop time NOT NULL,CONSTRAINT RestrictedTester _pk PRIMARY KEY
CLUSTERED(Id));
INSERT INTO Security.RestrictedTester
(GroupTest,RestrictedTesterTimeStart,RestrictedTesterTimeStop)VALUES (‘ CK_Prod’,
CAST(’10:00′ AS time),CAST(’22:00′ AS time));

You have received instructions from management to run the new Domain.com security policy
which is reserved in the RestrictedTester table.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You have received instructions from management to configure the following:
* The required permission for Clerk and other users at Domain.com.
You need to complete this task with the least amount of SQL administrative statements.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. During your leave, you have given a
Domain.com user named Mia Hamm permission to keep the database snapshots. You need to
make sure that Mia Hamm has the appropriate rights assigned to remove database snapshots.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using two SQL Server
2008 sample named CKSmp1 and CKSmp2. Furthermore, CKSmp1 contains a database named CK_DB.
A Domain.com user named Mia Hamm uses her name Mia to log on to the database on CKSmp1.
During the week you have transferred CK_DB to CKSmp2 with Mia Hamm credentials.
However, when she tries to login on CK_DB at CKSmp2, she received an error message stating
that she is not allowed access. Mia Hamm needs to access CK_DB and you need to make it happen.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
Domain.com contains a SQL Server 2008 server named CERTKILLER-DB1.
There are also SQL Server Agent jobs on the server. Furthermore the database is backed up at a
daily basis. One morning, the master database on CERTKILLER-DB2 went down. You then
restore and rebuild the database. The Domain.com managers want CERTKILLER-DB1 to work
as it was in the past.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that has a table named CK_StockOnHand.
CK_StockOnHand contains a column named CK_Price.
A new Domain.com policy states that the value in CK_Price cannot be
decreased by more than 10 percent in any single database operation.
However, ad hoc queries and various other methods are used to update CK_Price.
You need to make sure that the Domain.com policy is being complied with.

What should you do?