Câu 6: 70-762: Developing SQL Databases
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals. You have a database that contains a table named Employees. The table stores information about the employees of your company…
Nội dung câu hỏi
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals. You have a database that contains a table named Employees. The table stores information about the employees of your company. You need to implement and enforce the following business rules: ✑ Limit the values that are accepted by the Salary column. ✑ Prevent salaries less than $15,000 and greater than $300,000 from being entered. ✑ Determine valid values by using logical expressions. ✑ Do not validate data integrity when running DELETE statements.Solution: You implement a check constraint on the table. Does the solution meet the goal?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. Yes — đáp án hiện tại
- B. No
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.