Remo works as a Database Designer for Tech Inc. He wants to create a table named Product. He issues the
following query to create the Product table:
CREATE Product (
ProductID Char (10) NOT NULL,
OrderID Char (10) NULL
ProductName Varchar NOT NULL,
Primary key (OrderID, ProductID))
What are the errors in the above query?
Each correct answer represents a complete solution.Choose two.

What is the relationship between the foreign key and primary key? Each correct answer represents a complete
solution. Choose all that apply.

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.