A database developer needs to create a column that will hold employee ID codes such as "AB1234." Which data type should she choose so the field can accept both letters and numbers in each value?
Alphanumeric
Numeric
Binary large object
Date
Alphanumeric data types are explicitly designed to store character strings that may include both alphabetic symbols and numeric digits, allowing values like AB1234 or Room7A. Numeric types restrict the field to numbers only, preventing any letter from being entered. Date types are reserved for calendar or time information. Binary large objects (BLOBs) are intended for unstructured binary data such as pictures, audio, or video files. Therefore, the only option suited for mixing letters and digits in the same field is an alphanumeric type.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All IT & Cybersecurity Package plans include the following perks and exams .
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All IT & Cybersecurity Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.