REQUIREMENTS ENGINEERING
REQUIREMENTS VALIDATION AND VERIFICATION
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Data is recorded which is outside of a given range (eg month part of the date input as 13)
|
|
Range Check
|
|
|
Presence Check
|
|
|
Format Check
|
|
|
Check Digit
|
Explanation:
Detailed explanation-1: -SQL Server comes with the following data types for storing a date or a date/time value in the database: DATE-format YYYY-MM-DD. DATETIME-format: YYYY-MM-DD HH:MI:SS. SMALLDATETIME-format: YYYY-MM-DD HH:MI:SS.
Detailed explanation-2: -You can use the EDATE function to quickly add or subtract months from a date. The EDATE function requires two arguments: the start date and the number of months that you want to add or subtract.
There is 1 question to complete.