GIAC
GSNA · Question #171
GSNA Question #171: Real Exam Question with Answer & Explanation
Sign in or unlock GSNA to reveal the answer and full explanation for question #171. The question stem and answer options stay visible for context.
Question
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?
Options
- ADefine triggers in the EmployeeData table.
- BAdd stored procedures by using Transact-SQL queries.
- CAdd constraints to the EmployeeData table.
- DDefine indexes in the EmployeeData table.
- EDefine views in the database.
Unlock GSNA to see the answer
You've previewed enough free GSNA questions. Unlock GSNA 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.