Computer Science
The data types CHAR(n) and VARCHAR(n) are used to create ……………, and …………… length types of string/text fields in a database.
- Fixed, equal
- Equal, variable
- Fixed, variable
- Variable, equal
DDL & DML
1 Like
Answer
Fixed, variable
Reason — CHAR datatype specifies a fixed length string. Defining a length is not required, but the default is 1. While VARCHAR datatype specifies a variable length string. Defining a length is required.
Answered By
1 Like
Related Questions
Differentiate between DDL and DML.
Consider the following SQL statement. What type of statement is this ?
CREATE TABLE employee (name VARCHAR, id INTEGER)- DML
- DDL
- DCL
- Integrity constraint
A table Table1 has two text fields defined as below :
: Name1 varchar(20), Name2 char(20), :If Name1 stores value as 'Ana' and Name2 stores value as 'Anuj', then Name1 will consume ………….. characters' space and Name2 will consume …………… characters' space.
- 3, 20
- 20, 4
- 20, 20
- 3, 4
Consider the following SQL statement. What type of statement is this ?
INSERT INTO instructor VALUES (10211, 'Shreya' , 'Biology', 66000 ) ;- Procedure
- DML
- DCL
- DDL