Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 667
|
An attribute A of data type varchar (20) has value ‘Ram’ and the attribute B of data type char (20) has value ‘Sita’ in oracle. The attribute A has _______ memory spaces and B has _______ memory spaces.
|
20,20
|
|
|
3,20
|
|
|
3,4
|
|
|
20,4
|
Question 667 Explanation:
VARCHAR is variable length and CHAR is fixed length.
Given, varchar(20) and has value ‘Ram’ it means 3 spaces.
char(20) and has value ‘Sita’ but char is fixed spaces. It will take 20 spaces.
Given, varchar(20) and has value ‘Ram’ it means 3 spaces.
char(20) and has value ‘Sita’ but char is fixed spaces. It will take 20 spaces.
Correct Answer: B
Question 667 Explanation:
VARCHAR is variable length and CHAR is fixed length.
Given, varchar(20) and has value ‘Ram’ it means 3 spaces.
char(20) and has value ‘Sita’ but char is fixed spaces. It will take 20 spaces.
Given, varchar(20) and has value ‘Ram’ it means 3 spaces.
char(20) and has value ‘Sita’ but char is fixed spaces. It will take 20 spaces.