Class 10 Chapter 3 Solution SEBA Computer Science Solution
Looking for Class 10 Chapter 3 notes and solutions? You’ve come to the right place! Our website offers well-structured, easy-to-understand study materials that align perfectly with the latest CBSE syllabus. These notes are crafted by subject matter experts to provide clear explanations and step-by-step solutions to help you master even the most challenging topics. Whether you’re preparing for exams or need a quick revision, our resources ensure you’re always ready. Access our Class 10 Chapter 3 solutions now and take your learning to the next level!
I. MULTIPLE CHOICE QUESTIONS:
The command used to modify the content of a table is:
a) ALTER TABLE
b) SELECT
c) UPDATE
Ans. (3) UPDATE.
The command used to display the table structure is:
a) DISPLAY
b) STRUCTURE
c) DESCRIBE
Ans. (3) DESCRIBE.
A table name should begin with:
a) Number
b) Alphabet
c) Symbol
Ans.(2) Alphabet.
The command used to delete the database physically:
a) DELETE
b) ERASE
c) DROP
Ans. (3) DROP.
This wildcard character allows finding a match for any string of any length, including zero length: a) *
b) %
c) #
Ans. (2) %
This operator displays only those records that do not satisfy the specified condition,
a) AND
b) OR
c) NOT 111
Ans. (3) NOT.
II. FILL IN THE BLANKS:
MySQL is named after co-founder Michael Widenius’s daughter, _______
Ans. My.
The number of rows denotes the _________ of the table.
Ans. Cardinality.
The number of _________ denotes the Degree of the table.
Ans. Columns.
____________ words are not allowed in a table name.
Ans. Reserved.
A MySQL statement is terminated by a ___________.
Ans. Semi-colon.
The underscore wildcard allows finding a match for any ________ character.
Ans. Single.
III. ANSWER THE FOLLOWING QUESTIONS:
1. Who were the developers of MySQL?
2. Why is MySQL becoming so popular? Give two reasons.
3. What is a constraint? Name any two constraints.
4. Give examples of DML commands?
5. What are the characteristics by which you can determine the data type of MySQL?
6. What is the query to display the table structure?
7. What is the query to display all the records in a table?
8. List the Arithmetic Operators used in MySQL.
9. List the Relational Operators used in MySQL.
10. Differentiate between COUNT(*) and COUNT.