Mark works as a Database Administrator for DataWorld Inc. The company has a SQL Server database.
Management instructs him to ensure that no inconsistent data is entered in the database. Which of the
following will help him to accomplish the task?

You work as a Database Designer for Netwell Inc. The database has a table named Project, which is depicted
below:
ProjectID
ProjectName
TaskID
TaskName
A
Macwell
Design
A
Macwell
Coding
B
Vintech
Design
B
Vintech
Coding
Is the table given above in normalized form? If not, then which normal form (NF) is violated?

Which of the following statements about rebuilding an index is true?

You work as a database developer for www.company.com.com. The company has a database named www.
company.com that is hosted on a SQL Server 2008 server. The database includes a table named Employees,
which contains the details of the employees. You want to ensure that anytime any data in the Employeestable
is modified with an UPDATE statement, they are recorded in a table named EmployeeChanges. The
EmployeeChanges table includes columns to record what the change was, who made the change, and when
they made the change. What should you create to meet this need?

You want to recover one or more tablespaces to a point in time older than the rest of the database. Which of
the following are the recovery situations in which tablespace Point-in-Time Recovery (TSPITR) should be
used? Each correct answer represents a part of the solution. Choose all that apply.

Linda works as a Database Designer for Lion Inc. She has been given an assignment to design the database
of a publishing company. The database has a table named Author, which has a composite key, AuthorID and
TitleID. Royalty and LiteraryAgent are the other attributes. The functional dependencies are such thatAuthorID
+ TitleID-> Royalty (i.e. Royalty is functionally dependent on AuthorID and TitleID) and AuthorID->
LiteraryAgent (i.e. LiteraryAgent is functionally dependent on AuthorID). Which of the following is true about this
table?

Which of the following is a management activity that allows the stages of the database application to be
realized as efficiently and effectively as possible?

You work as a Database Administrator for Bell Ceramics Inc. An employee of the company has fired a query,
including a DML statement, such as INSERT, against a table named Sales. You notice that the DML statement
has not executed. What will you do to resolve the issue? Each correct answer represents a complete solution.
Choose two.

You manage a large database named Sales. The Sales database contains a table named OrderDetails, which
is a heavily transacted table with frequent inserts. Indexes in the table often become fragmented due to
excessive page splitting. You want to minimize the amount of fragmentation due to page splits. What should
you do?

Which of the following is the process of extractingtrails on a regular basis so that they can be transferred to a
designated security system where the database administrators do not have access?