Microsoft
98-364 · Question #105
98-364 Question #105: Real Exam Question with Answer & Explanation
Sign in or unlock 98-364 to reveal the answer and full explanation for question #105. The question stem and answer options stay visible for context.
Question
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?
Options
- ACreate a new table that includes the EmployeeSalary and DateOfIncrement columns.
- BCreate a new table that includes the EmployeeID, EmployeeSalary, and DateOfIncrement
- CAdd the EmployeeSalary and DateOfIncrement columns to the Employees table.
- DCreate a new table that includes the EmployeeSalary and DateOfIncrement columns.
Unlock 98-364 to see the answer
You've previewed enough free 98-364 questions. Unlock 98-364 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.