PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

How will you design the database so that you can query the last increment given to a particular employee?

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?

Which of the following should 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, or inadvertent mistakes.
Which of the following should he use to accomplish the task?