Q. Which data type is most appropriate for storing a customer’s last name?
Solution:
VARCHAR is used for variable-length character strings. INT is for integers, DECIMAL for fixed-point numbers, and BOOLEAN for true/false values. A name is a string of characters.
Related Questions
Q. Which query would count the number of distinct cities in the ‘Customers’ table?
View SolutionQ. What is the purpose of the HAVING clause?
View SolutionQ. How can you remove a table from the database?
View Solution
Get Question Bank
Strengthen Your Practice with our comprehensive question bank.
