Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 3

Q1. Write two advantages of SQL.

Q2. MySQL is an ___________Software. (open source/Proprietary)

Q3. Name two types of SQL commands.

Q4. What is the difference between DDL and DML Commands?

Q5. Identify the DDL and DML commands from the following.

1. Create
2. Alter
3. Insert
4. Update
5. Drop
6. Delete
7. Select
8. Grant
9. Revoke

Q6. What do you mean by data type?

Q7. Name two numeric data type in MySQL.

Q8. Name two String Data type in MySQL.

Q9. Which data type is used for "Date of birth" field in Student table.

Q10. What is the difference between Char and Varchar.

SOLUTIONS:

Q1. Write two advantages of SQL.

Ans. 

• It is very easy to learn
• It is not a case sensitive language.

Q2. MySQL is an ___________Software. (open source/Proprietary)

Ans. open source

Q3. Name two types of SQL commands.

Ans

1. DDL
2. DML

Q4. What is the difference between DDL and DML Commands?

Ans. 

DDL	DML
It stands for Data Definition Language	It stands for Data Definition Language
These commands allow   to perform tasks related   to the structure of the table	These commands are used to manipulate data

       

Q5. Identify the DDL and DML commands from the following.

1. Create
2. Alter
3. Insert
4. Update
5. Drop
6. Delete
7. Select
8. Grant
9. Revoke

Ans

1. DDL
2. DDL
3. DML
4. DML
5. DDL
6. DML
7. DML
8. DDL
9. DDL

Q6. What do you mean by data type?

Ans. Data type refers to the type of data we are entering in the column of the table.

Q7. Name two numeric data type in MySQL.

Ans. Integer and Smallint

Q8. Name two String Data type in MySQL.

Ans. Char and Varchar

Q9. Which data type is used for "Date of birth" field in Student table.

Ans. Date

Q10. What is the difference between Char and Varchar.

Ans. Char is fixed length data type while Varchar is variable length data type.