MYSQL
Test Your MySQL Knowledge
Welcome to the MySQL Quiz! This quiz is designed to test your knowledge of MySQL and its various fun
Here's what you can expect:
- 17 challenging questions
- Multiple-choice format
- Instant feedback for each question
1. Which statement is used to extract data from a table?
Select
Display
Read
Extract
2. How do you select all the columns from a table named "Employee"?
SELECT [all] FROM Employee;
SELECT Employee;
SELECT * BY Employee;
SELECT * FROM Employee ;
3. How do you select a column named "IName" from a table named "Inventory"?
SELECT Inventory FROM Iname;
DISPLAY Iname FROM Inventory;
SELECT Iname FROM Inventory;
SELECT Iname, Inventory FROM Iname;
4. Which of the following are valid column names?
Marks Eng
66_Marks
Marks_Eng
#Eng_Marks
5. SELECT statement can be used to perform these functions.
Insert rows into a table.
Choose and display columns from a table
Modify data in a table.
Select and display structure of a table
6. Which statement is used to insert new data in a table?
ADD RECORD
INSERT RECORD
INSERT INTO
INSERT ROW
7. How would you display all those rows from a table named "Friends" where the value of the column "Hobbies" is "SWIMMING"
SELECT ALL FROM Friends WHERE Hobbies IS 'SWIMMING';
SELECT * FROM Friends WHERE Hobbies = 'Swimming" ;
SELECT ALL FROM Friends WHERE Hobbies 'SWIMMING' ;
SELECT * FROM Friends WHERE Hobbies is 'SWIMMING';
8. Which statement is used to modify data in a table?
CHANGE
MODIFY
UPDATE
SAVE AS
9. Which SQL statement is used to delete data from a table?
DELETE
DROP
REMOVE
TRUNCATE
10. How do you select all the rows from a table named "Student" where the value of the column "FName" starts with "G"?
SELECT * FROM Student WHERE FName LIKE 'G_' ;
SELECT * FROM Student WHERE FName='G';
SELECT * FROM Student WHERE FName LIKE 'G%' ;
SELECT * WHERE Student WHERE FName='%G%' ;
11. The OR operator displays a record if ANY of the conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
True
False
12. Which keyword is used to return only different values in a column?
DIFFERENT
EXCLUSIVE
DISTINCT
UNIQUE
13. Which SQL keyword(s) is/are used to sort the rows in the output:
SORTED ORDER
SORT
SORT BY
ORDER BY
14. How would you return all the rows from a table named "Item" sorted in descending order on the column "IName"?
SELECT * FROM Item SORT 'IName' DESC;
SELECT * FROM Item ORDER BY IName DESC ;
SELECT * FROM Item ORDER IName DESC ;
SELECT * FROM Item SORT BY 'IName' DESC ;
15. How can you insert a new row into the "Store" table?
INSERT (1,'Abc Rice') INTO Store;
INSERT VALUES (1,'Abc Rice') INTO Store ;
INSERT INTO Store VALUES (1,'Abc Rice');
ADD ROW Store values(1,'Abc Rice');
16. Which statement is appropriate to change the first name "Madhur" to "Mridul" in the "FName" column in the 'Student' table?
UPDATE Student SET FName='Mridul' WHERE FName='Madhur' ;
MODIFY Student SET FName='Madhur' INTO FName='Mridul ;
UPDATE Student SET FName='Madhur' INTO FName='Mridul' ;
UPDATE Student SET FName='Madhur' WHERE FName='Mridul' ;
17. How can you delete the rows with marks below 33 in the 'Student' Table?
DELETE FROM Student WHERE marks <=33;
DELETE marks < 33 FROM Student ;
DELETE ROW marks <33 FROM Student;
DELETE FROM Student WHERE marks <33;
{"name":"MYSQL", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Welcome to the MySQL Quiz! This quiz is designed to test your knowledge of MySQL and its various functionalities. Whether you're a beginner or an experienced user, you're sure to learn something new!Here's what you can expect:17 challenging questionsMultiple-choice formatInstant feedback for each question","img":"https:/images/course1.png"}