GIAC
GSSP-.NET · Question #148
GSSP-.NET Question #148: Real Exam Question with Answer & Explanation
Sign in or unlock GSSP-.NET to reveal the answer and full explanation for question #148. The question stem and answer options stay visible for context.
Question
- (Topic 2) You work as a Software Developer for ABC Inc. You create a SQL server database named DATA1 that will manage the payroll system of the company. DATA1 contains two tables named EmployeeData and 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? Each correct answer represents a part of the solution. Choose all that apply.
Options
- ADefine views in the database.
- BAdd constraints to the EmployeeData table.
- CDefine triggers in the EmployeeData table.
- DDefine indexes in the EmployeeData table.
- EAdd stored procedures by using Transact-SQL queries.
Unlock GSSP-.NET to see the answer
You've previewed enough free GSSP-.NET questions. Unlock GSSP-.NET 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.