Home > Databases > Quizzes > MySQL Basics Practice Test: MySQL Data Type Reference, Operators and Functions
MySQL Basics Practice Test: MySQL Data Type Reference, Operators and Functions
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 70% • Most missed: “Which is the header that should be included first?”
Quiz questions on numeric, string and spatial data types, operators and functions. MySQL has three main data types: numeric, date and time, and string. Other data types include: Spatial: Geometric-based information for geographic data JSON: Stores JSON documents ENUM: A string object whose value is chosen from a list of permitted values defined at the time of column creation  MySQL also has arithmetic operators, which are used to perform mathematical calculations on numerical values in queries. These include: Addition (+) Subtraction (-) Multiplication (*) Division (/: ) Modulus... Show more
MySQL Basics Practice Test: MySQL Data Type Reference, Operators and Functions
Time left 00:00
25 Questions

1. There cannot be more than one column per table with the AUTO_INCREMENT attribute.
2. The right shift operator is _____________
3. The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____________
4. SPATIAL indexes cannot be created on NOT NULL spatial columns.
5. What does RTF refer to?
6. What is the generic handle whose meaning depends on context?
7. What does the AUTO_INCREMENT sequences begin at by default?
8. Which function returns an array of row values?
9. The mode of search is the search string parsed into words and the search looks for rows is ______________
10. The maximum value that can be specified to the size of VARCHAR is _____________
11. What is used to reload a delimited text data file?
12. Which function returns a reference to hash of row values?
13. To disallow zero month or day parts in dates, the option used is _____________
14. What is the non handle array representing a row of values?
15. Which variable is a handle to a database object?
16. The string function that returns the index of the first occurrence of substring is _____________
17. MySQL automatically converts a date or time value to a number if the value is used in a numeric context.
18. The minimum value stored by signed TINYINT is _____________
19. The variable used as a handle to an open file is ______________
20. The maximum non zero value for FLOAT is ______________
21. The operator that compares sounds is _____________
22. On Unix, ‘mysql’ client writes a record of executed statements to a history file.
23. Which classes does spatial data types in MySQL correspond to?
24. The one that is not optional is _____________
SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;
25. What is the minimum value stored by signed TINYINT?

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.