You have created a database for employee management. The database has a table named Employees. The
table has the following attributes:
Name
Address
Contact Number
Designation
You want to store the salary information for each employee. The database should also store salary history.
How will you design the database so that you can query the last increment given to a particular employee?

Mark works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server database.
Mark has to change the properties of an object inside the database. Which of the following statements will he
use to accomplish the task?

Mark works as the Database Administrator for DataWorld Inc. The company has a SQL server 2008 database.
Mark wants to protect the database from unintended activities made by authorized individuals or processes
such as authenticated misuse, malicious attacks, orinadvertent mistakes. Which of the following should he use
to accomplish the task?

Examine the following table:

In the table, you deleted the record of Mark Smith.Which of the following will change as a result?

Rick works as a database administrator for a MySQL server. The server uses the InnoDB storage engine. Rick
finds that a table’s performance is inconsistent. He wants to bring the table to a consistent state without
shutting down the server. Choose the required stepsto accomplish the task.

Which of the following files contain configuration information that must be restored after a MySQL database
server has crashed? Each correct answer represents a complete solution. Choose two.

John works as a Database Administrator in www.company.com Inc. The company has a SQL Server database.
John wants to create a table named employees in thedatabase. The table will have the id, firstname,
lastname, and dateofbirth columns. John has to ensure that the lastname column does not allow null values.
Which of the following queries will he use to accomplish the task?

Which of the following statements are true regarding DML? Each correct answer represents a complete
solution. Choose all that apply.

Which of the following is NOT a valid DDL command?

You are a database developer for a database named Sales hosted on a SQL Server 2008 server. The Sales
database includes the Exams and
ExamQuestions tables. If any questions are modifiedfor an exam, you need to ensure that the
ExamModifiedDate in the Exams table is
updated with the date and time of the update. The ExamQuestions table includes an INSTEAD OF trigger that
records when and who last
modified each question. Therefore, you decide to create a trigger. You only want the trigger to fire if a
constraint violation has not occurred.
Which of the following code will create the triggerto meet your goals?