UGC-NET | UGC NET CS 2017 Jan – II | Question 16

An attribute A of datatype varchar (20) has value ‘Ram’ and the attribute B of datatype char (20) has value ‘Sita’ in oracle. The attribute A has _______ memory spaces and B has _______ memory spaces.
(A) 20,20
(B) 3,20
(C) 3,4
(D) 20,4


Answer: (B)

Explanation: varchar will acquire the exact memory of attribute and it varies from tuple to tuple while char will acquire memory space which is define at the time of table creation it is fixed: varchar(20) ‘Ram’ will take 3 and ‘Sita’ will take 20 character space in memory.
So, option (B) is correct.


Quiz of this Question

My Personal Notes arrow_drop_up

Save