Bissoy.com
Doctors Medicines MCQs Q&A

An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces.

An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces. Correct Answer 3, 20

Varchar changes its length accordingly whereas char has a specific length which has to be filled by either letters or spaces.

Related Questions

The ratio between the salaries of Avi, Manu, and Ram is 2x : 3x : 4y. If the salary of Ram is twice the salary of Avi and salary of Manu is Rs. 12000 then what will be the ratio between the sum of Avi and Manu's salary to the Manu and Ram's salary?
Tapas, Avi and Rishi shared a cake. Tapas had 1/2 of it, Rishi had 1/3 of it and Avi had the rest. What was Avi’s share of the cake?
Tapas, Avi and Rishi shared a cake. Tapa had 1/2 of it, Rishi had 1/3 of it, and Avi had the rest. What was Avi's share of the cake?
In SQL, if a value is entered in CHAR datatype which does not occupy all the length spaces then the remaining spaces will be occupied with blank spaces.
Avi introduced a girl as the daughter of the only son of his father. How is that girl related to Avi?
In a vibrating reed type frequency meter, the reed which will vibrate the most is the one whose natural frequency is equal to
Which of the following syntax is correct way to declare a variable in PL/SQL? ; b) variable_name datatype ; c) variable_name datatype; d) variable_name datatype (NOT NULL := value );
Consider the following statements and choose the correct answer:
1. Average density of soil is 2.65 gms. per ml.
2. The spaces present between soil particles in a given volume of soil are called pore spaces
3. Porosity of the soil decreases with the increase in the percentage of organic matter in the soil
4. Macro-pore spaces have little water holding capacity and allow free movement of moisture and air in the soil under normal condition
(i) Arun and Aparna are here. (ii) Arun and Aparna is here. (iii) Arun's families is here. (iv) Arun's family is here. Which of the above sentences are grammatically CORRECT?
There are blank spaces in the following passage which have been numbered . These numbers are printed below the passage and against each some words are suggested . Find out the word that best fit the blank spaces. Global Strategies to control infective disease have historically included the erection of barriers to international travel and ___ (24) _______. Keeping people with such deadly disease outside national borders has ___ (25) _______ as an important public health policy in the human immunodeficiency virus (HIV) epidemic . Betwwn 29 and 50 countries ___ (26) _____ to have introduced border restrictions on HIV _ positive foreigners ,usually those planning an ___ (27) ___ stay in the country , such as students , workers or seamen.