A user named Elizabeth McKenzie is on a website that asks for her full name: first, middle, and last. However, she does not have a middle name at all. She enters “Elizabeth” for the first name and “McKenzie” for the last name and clicks submit. The website then saves her name in a database, and there is nothing to put in the MiddleName column.
Sometimes a value is not known. It’s not that the value is 0 or an empty string, but just nothing at all. Enter the term used to describe the absence of a value:
When working with data in a SQL database, each column will have a data type. There are many types for storing things like numbers, dates, and strings. Enter the name of the commonly used data type that can store numbers without decimal places within the range from about -2 billion to 2 billion:
If you get stuck or need assistance, you can click the button below to connect with a tutor.
For additional questions or technical support, email firstname.lastname@example.org.