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
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