Computer Science
In which datatype the value stored is padded with spaces to fit the specified length.
- DATE
- VARCHAR
- FLOAT
- CHAR
Relational Database
1 Like
Answer
CHAR
Reason — The CHAR data type in SQL is used to store fixed-length strings. When a value is stored in a CHAR field, it is padded with spaces to fit the specified length.
Answered By
2 Likes
Related Questions
Which SQL command can change the degree of an existing relation ?
What will be the output of the query ?
SELECT * FROM products WHERE product_name LIKE 'App%';- Details of all products whose names start with 'App'
- Details of all products whose names end with 'App'
- Names of all products whose names start with 'App'
- Names of all products whose names end with 'App'
Which aggregate function can be used to find the cardinality of a table ?
- sum()
- count()
- avg()
- max()
Which protocol is used to transfer files over the Internet ?
- HTTP
- FTP
- PPP
- HTTPS