No products in the cart.

Ask questions which are clear, concise and easy to understand.

Ask Question
  • 0 answers
  • 0 answers
  • 1 answers

Sia ? 3 years, 6 months ago

SR.NO. CHAR VARCHAR
1. CHAR datatype is used to store character string of fixed length VARCHAR datatype is used to store character string of variable length
2. In CHAR, If the length of string is less than set or fixed length then it is padded with extra memory space. In VARCHAR, If the length of string is less than set or fixed length then it will store as it is without padded with extra memory spaces.
3. CHAR stands for “Character” VARCHAR stands for “Variable Character”
4. Storage size of CHAR datatypes is equal to n bytes i.e. set length Storage size of VARCHAR datatype is equal to the actual length of the entered string in bytes.
5. We should use CHAR datatype when we expect the data values in a column are of same length. We should use VARCHAR datatype when we expect the data values in a column are of variable length.
6. CHAR take 1 byte for each character VARCHAR take 1 byte for each character and some extra bytes for holding length information
9. Better performance than VARCHAR Performance is not good as compared to CHAR
  • 1 answers

Aadhya Maheshwari 6 years, 9 months ago

Do while loop is generally used when user don't know in advance how many times loop will be executed and user want it to execute it at least one time. It is an exit controlled loop. While loop is generally used when user don't know in advance how many times loop will be executed . It is an entry controlled loop
  • 1 answers

Somiya Sharma 6 years, 9 months ago

It is a technique used in secure computers system or network to block unauthorized user
  • 0 answers
  • 1 answers

Avinash Kumar 6 years, 9 months ago

It is a small piece of data sent from a website and stored in user's web browser while a user is browsing. This cookies helps to track user's browsing session and load information faster.
  • 0 answers
  • 0 answers
I
  • 0 answers
  • 0 answers
  • 0 answers
  • 1 answers

Adhi Mp 6 years, 9 months ago

INFORMATICS PRACTICES CLASS XI Time allowed: 3 hours Note: (i) This question paper is divided into 3 sections (ii)Section A consists of 30 Marks. (iii)Section Bconsists of 20 marks. (iv)Section Cconsists of 20 Marks. (iv) Answer the questions after carefully reading the text. SECTION-A Maximum Marks: 70 1. Answer the following questions : a. Define each of the following: (a) Nibble (b) Byte (c) Kilo Byte (d) Giga Byte 2 b. State the basic units of the computer. Name the subunits that make up the CPU, and give the function of each of the 2 units. c. Differentiate between the compiler and interpreter. 2. d What is a computer virus? How can it affect your computer? 2. e Expand the following terms : 2 a) PDAs b) MICR c) DVD d) TFT 2. a. Which Graphical controls of JAVA can used to display multiple choices out of which more than one can be selected? 1 b. Suppose you want to scan your storage devices attached with your computer for virus infection . Suggest the type and 1 name of the software. c. What is Write Once Run Anywhere characteristics of Java? 2 d. How can you declare the variable in JAVA for the following:- 2 (i) If you want to store the employee no. of an employee. (ii) If you want to store the name of an employee. e. What is meant by E-learning. Suggest any two websites which can be used for E-learning. 2 f. What benefits (mention at least 2) does an e-business offer to an organization? 2 3. a. Define the following terms in respect of Relationdatabase
  • 0 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Download myCBSEguide App