Class 10 Computer Science Chapter 3| Database Part II MySQL: Welcome to our website! We are happy to provide you with Class 10th Notes for your academic journey. Class IX is an important year for learners as they prepare themselves for the upcoming board exams, which will determine their academic success.
Today, I will discuss your Class 10th “ Database Part II MySQL” Long and Short Questions| We provide solutions for almost all long and short questions.
Our goal is to meet your needs. We provide the Notes here for free. We wish you all the best for your upcoming exams. If you have any doubts, don’t hesitate to get in touch with us.
Database Part II MySQL Question Answer
TEXTUAL QUESTIONS AND ANSWERS
MULTIPLE CHOICE QUESTIONS:
1. The command used to modify the contents of a table is:
(a) ALTER TABLE
(b) SELECT
(c) UPDATE
Ans. (c) UPDATE
2. The command used to display the table structure is:
(a) DISPLAY
(b) STRUCTURE
(c) DESCRIBE
Ans. (c) DESCRIBE
3. A table name should begin with:
(a) Number
(b) Alphabet
(c) Symbol
Ans. (b) Alphabet
4. The command used to delete the database physically:
(a) DELETE
(b) ERASE
(c) DROP
Ans. (c) DROP
5. The wildcard character allows finding a match for any string of any length including zero length.
(a) .
(b) %
(c) #
Ans. (a) %
6. This operator displays only those records that do not satisfy the specific Condition:
(a) AND
(b) OR
(c) NOT
Ans. (c) NOT
II. FILL IN THE BLANKS:
1. MySQL is named after co-founder Michael Widenius’s daughter,______
Ans: My
2. The number of rows denotes the_____of the table.
Ans: Cardinality.
3. ______words are not allowed in a table name.
Ans: Columns
4. A MySQL statement is terminated by a________.
Ans: semi-colon
6. The underscore wildcard allows finding a match for any_____character.
Ans. single.
III. ANSWER THE FOLLOWING QUESTIONS:
1. Who were the developers of MySQL?
Ans. The developers of the MySQL platform were Michael Widenius (Monty), David Axmark, and Allan Larsson.
2. Why is MySQL becoming so popular? Give two reasons.
Ans. MySQL is becoming so popular because –
- MySQL is released under an open-source license.
- MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, etc.
- MySQL works very quickly and supports large databases.
3. What is a constraint? Name any two constraints.
Ans. Constraints are the rules that help ensure the validity of the data while entering data in a table. In other words, MySQL constraints are used to specify rules for the data in a table.
The constraints in MySQL are PRIMARY KEY, NOT NULL, FOREIGN KEY, UNIQUE etc.
4. Give an example of DML commands.
Ans. Data Manipulation Language (DML) commands are used to modify the database.
Some of the DML commands are –
INSERT, UPDATE, DELETE etc.
5. What are the characteristics by which you can determine the data type MySQL?
Ans. The data can be determined by the –
- Number of bytes it takes for storage.
- Kind of value it represents.
6. What is the query to display the table structure?
Ans. To display complete information about the table structure, the
DESCRIBE < TABLE NAME>;
Or
DESC <TABLE NAME>;
For example, if the table name is student, then the query is-
DESCRIBE student;
Or
DESC student;
7. What is the query to display all the records in a table?
Ans. To display all the records in a table, the query is –
SELECT* FROM <TABLE NAME>;
if fiol brodele d
For example, if the table name is student, then the
SELECT * FROM student;
RUM
8. List the Arithmetic Operators used in MySQL.
Ans. The Arithmetic Operators used in MySQL are –
| Operator | Meaning | Example |
| + | Addition | A + B |
| – | Subtraction | A-B |
| / | Division | A / B |
| . | Multiplication | A. B |
| % | Modulus or remainder | A % B |
9. List the Relational Operators used in MySQL.
Operator
=on
<> Or !=
MD=
<
Meaning
Addition
Subtraction
Division
V
Multiplication on
Modulus or remainder
9. List the Relational Operators used in MySQL.
Ans. Relational operators compare two expressions or values and return a Boolean result. The relational operators used in MySQL are –
| Operator | Meaning | Example |
| = | Equal to | A = B |
| <> Or != | Not equal to | A !=B |
| < | Less than | A > B |
| > | Greater than | A < B |
| <= | Less than or equal to | A <=B |
| >= | Greater than or | A>=B |
10. Differentiate between COUNT (*) and COUNT.
Ans. The COUNT (*) returns all rows whether column contains null value or no while COUNT returns the number of rows except null rows.
11. What are the rules for naming a table in MySQL?
Ans. The rules for naming a table in MySQL
- A table can have a maximum of 30 characters.
- A table name should begin with an alphabet.
- The special character (_) underscore is allowed.
- Reserved words are not allowed.
12. Explain the five categories of SQL commands.
Ans. SQL Commands are divided into five broad categories – DDL, DML, DCL, TCL, and DQL.
(a) Data Definition Language (DDL) – The Data Definition Language made up of SQL commands that can be used to design the database structure.
Some commands that come under this category are CREATE, ALTER, DROP, TRUNCATE
(b) Data Manipulation Language (DML) – The SQL commands that deal with manipulating data in a database are classified as DML (Data Manipulation Language), which covers the majority of SQL statements.
Some commands that come under this category are –
INSERT, UPDATE, DELETE
(c) Data Control Language (DCL) – DCL (Data Controlling Language) is a query language that allows users to retrieve and edit data held in databases.
Some commands come under this category are – GRANT, REVOKE
(d) Transaction Control Language (TCL) – Transaction Control Language (TCL) instructions are used in the database to manage transactions. This command is used to handle the DML statements’ modifications.
Some commands that come under this category are – COMMIT, ROLLBACL, SAVEPOINT
(e) Data Query Language (DQL)- Data Query Language (DQL) is used to fetch the data from the database.
Some commands that come under this category are SELECT, SHOW, HELP
ADDITIONAL QUESTIONS AND ANSWERS
1. What is a database?
Ans. A database is an organized collection of structured information or data stored electronically in a computer system.
2. What is DBMS?
Ans. A database management system (or DBMS) is a computerized data-keeping system. It manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs. Some DBMS examples include MySQL, Microsoft Access, SQL Server, Oracle, RDBMS, FoxPro etc.
3. What is MySQL?
Ans. MySQL is an open-source Database Management System (DBMS) for managing and organizing data in a tabular format. These data can be manipulated using MySQL programming language.
4. What does SQL in MySQL stand for?
Ans. The SQL in MySQL stands for Structured Query Language.
5. What does a MySQL database contain?
Ans. A MySQL database contains one or more tables, each of which contains records rows. Within these rows are various columns or fields that contain the data itself.
6. Why MySQL is used?
Ans. Open source software
- Flexible structure
- High performance
- Security and storage management
- Works on many operating system.
7. What are MySQL Database Queries?
Ans. A query is a specific request or a question. One can query a database for specific information and have a record returned.
8. What is the difference between databases and tables?
Ans. There is a major difference between a database and a table. The differences are as follows:
◆ Tables are a way to represent the division of data in a database while the database a collection of tables and data.
◆ Tables are used to group the data in relation to each other and create a dataset. Th dataset will be used in the database. The data stored in the table in any form is a pa of the database, but the reverse is not true.
◆ A database is a collection of organized data and features used to access them, where a table is a collection of rows and columns used to store the data.
9. How do you create a database in MySQL?
Ans. To create a new database name “school”, the command is CREATE DATABASE school;
10. What are the basic SQL commands?
Ans. There are five types of SQL commands:
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Control Language (DCL)
- Transaction Control Language (TCL)
- Data Query Language (DQL)
11. How do you create a table name “academic” in MySQL?
Ans. To create the table using MySQL, the command is –
CREATE TABLE academic (
name VARCHAR (30),
class CHAR (5),
UT 1 INT);
12. Differentiate between DML and DDL.
Ans. The SQL DML (Data Manipulation Language) is used to put values and manipulate them in tables and other database objects and DDL (Data Definition Language) I used to create tables and other database objects.
13. How do you insert data into MySQL?
Ans. The INSERT INTO statement is used to add new records to a MySQL table:
Syntax
INSERT INTO table_name
VALUES (value1, value2, value);
14. What is the command to view the MySQL version?
Ans. The command to know about the MySQL version is –
SELECT VERSION ();
Conclusion:
We believe these notes will help learners develop a better understanding of the topics and boost their confidence for their exams.
We are confident that these notes will help learners achieve their goals and enhance their academic performance. If you like this article and find it helpful, please share it with your friends.