GIAC Systems and Network Auditor

370 Questions

You can start the exam to practice all questions related to this exam.

Question No. 1

You work as a Software Developer for XYZ CORP. You create a SQL server database named DATA1 that will manage the payroll system of the company. DATA1 contains two tables named EmployeeData, Department. While EmployeeData records detailed information of the employees, Department stores information about the available departments in the company. EmployeeData consists of columns that include EmpID, EmpName, DtOBrth, DtOJoin, DeptNo, Desig, BasicSal, etc. You want to ensure that each employee ID is unique and is not shared between two or more employees. You also want to ensure that the employees enter only valid department numbers in the DeptNo column.

Which of the following actions will you perform to accomplish the task?

Choose all the correct options from the given list.

01 / 370

0 Discussions

Trending Exams