MYSQL

Test Your MySQL Knowledge

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 questions
Multiple-choice format
Instant feedback for each question

17 Questions4 MinutesCreated by QueryMaster305

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;

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';

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;

MYSQL

Test Your MySQL Knowledge

More Quizzes