CBSE Class 11 Informatics Practices Introduction to MySQL Questions

CBSE Assignment for Class 11 Informatics Practices -Introduction to Mysql Questions . Based on CBSE and CCE guidelines. The students should read these basic concepts to gain perfection which will help him to get more marks in CBSE examination.

QUESTIONS & ANSWERS on MySQL

Q.1. What is MySQL?

Ans:- It is an Open Source RDBMS Software. It is available free of cost.

Q.2. What is SQL?

Ans . SQL is Non-procedural universal data access language used to access and manipulate data stored in nearly all the data bases available currently. SQL standards are defined by ANSI (American National Standards Institute). SQL statements are used to retrieve and update data in a database. SQL works with database programs like MySQL, MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc.

Q.3. Differentiate between DDL and DML?

Ans Data Definition Language (DDL): This is a category of SQL commands. All the commands which are used to create, destroy, or restructure databases and tables come under this category. Examples of DDL commands are -

CREATE, DROP, ALTER. Data Manipulation Language (DML): This is a category of SQL commands. All the commands which are used to manipulate data within tables come under this category. Examples of DML commands are - INSERT, UPDATE, DELETE.

Q.4 What is a constraint?

Ans : A constraints is a condition or check application on a field or set of fields. Example: NOT NULL (ensure that column con not have null value), CHECK (make sure that all value satisfy certain criteria), UNIQUE (ensure that all values in a column are different) etc.

Q5 What are single row functions ?

Ans: Single Row Function work with a single row at a time. A single row function returns a result for every row of a queried table. Examples of Single row functions are Sqrt(), Concat(), Lcase(), Upper(), Day(), etc.

Q. 6 Compare CHAR and VARCHAR data types.

Ans. The CHAR data-type stores fixed length strings such that strings having length smaller than the field size are padded on the right with spaces before being stored. The VARCHAR on the other hand supports variable length strings and therefore stores strings smaller than the field size without modification.

Q.7 What are the differences between DELETE and DROP commands of SQL?

Ans: DELETE is DML command while DROP is a DDL command. Delete is used to delete rows from a table while DROP is used to remove the entire table from the database. 

Q8 What do you understand by MySQL Server?

Ans:MySQL server listens for clients requests coming in over the network and accesses database contents according to those requests and provides that to the client.

Q9 What do you understand by MySQL Client?

Ans:MySQL Clients are programs that connect to MySQL Server and issue queries in predefined format.

Please refer to attached file for CBSE Class XI Informatics Practices Introduction to Mysql Questions