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
1
Design
A
Macwell
2
Coding
B
Vintech
1
Design
B
Vintech
2
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 Employees table 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 that AuthorID + 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.