Exam 98-364 topic 1 question 214 discussion

Actual exam question from Microsoft's 98-364

Question #: 214
Topic #: 1

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?

A. Create a new table that includes the EmployeeSalary and DateOfIncrement columns. Create a one-to-one relationship with the Employees table.
B. Create a new table that includes the EmployeeID, EmployeeSalary, and DateOfIncrement columns. Create a one-to-many relationship with the Employees table.
C. Add the EmployeeSalary and DateOfIncrement columns to the Employees table.
D. Create a new table that includes the EmployeeSalary and DateOfIncrement columns. Create a many-to-many relationship with the Employees table using the new table.

Show Suggested Answer

Suggested Answer: B 🗳️

by [deleted] at April 4, 2025, 6:31 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!