Introduction to MySQL Questions | Practice Test / Quiz / MCQs

Home > Databases > Quizzes > Introduction to MySQL Questions

Introduction to MySQL Questions

Fast practice, instant feedback. Timer auto-submits when time’s up.

Avg score: 72% • Most missed: “What are the main numeric data types in MS SQL?”

What is MySQL?
MySQL is an open-source relational database management system (RDBMS). It is the most popular database system used with PHP. MySQL is developed, distributed, and supported by Oracle Corporation.

The data in a MySQL database are stored in tables which consists of columns and rows.
MySQL is a database system that runs on a server.
MySQL is ideal for both small and large applications.
MySQL is very fast, reliable, and easy to use database system.It uses standard SQL
MySQL compiles on a number of platforms.

Introduction to MySQL Questions

Time left 00:00

24 Questions

1. Why are Datatypes important?

Yes it is a datetime value(9x things) SQL can execute queries against a database and retrieve data from a database SQL can insert rows in a tables SQL can update rows in a tables SQL can delete rows in a tables SQL can create new databases SQL can create new tables in a database SQL can create stored procedures in a database SQL can create views in a database SQL can set permissions on tables, procedures, and views(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)Three main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)

2. What are the main characteristics of decimal data types in MS SQL?

(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)(9x things) SQL can execute queries against a database and retrieve data from a database SQL can insert rows in a tables SQL can update rows in a tables SQL can delete rows in a tables SQL can create new databases SQL can create new tables in a database SQL can create stored procedures in a database SQL can create views in a database SQL can set permissions on tables, procedures, and viewsYes it is a datetime valueThree main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)

3. Does the value '2002-01-25 20:20:01.001' respect one of thefollowing formats date, datetime, and datetime2. If Yes which one?

Three main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)Yes it is a datetime value(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)(9x things) SQL can execute queries against a database and retrieve data from a database SQL can insert rows in a tables SQL can update rows in a tables SQL can delete rows in a tables SQL can create new databases SQL can create new tables in a database SQL can create stored procedures in a database SQL can create views in a database SQL can set permissions on tables, procedures, and views

4. What does SQL mainly allows us to do?

Three main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)Yes it is a datetime value(9x things) SQL can execute queries against a database and retrieve data from a database SQL can insert rows in a tables SQL can update rows in a tables SQL can delete rows in a tables SQL can create new databases SQL can create new tables in a database SQL can create stored procedures in a database SQL can create views in a database SQL can set permissions on tables, procedures, and views

5. if you are supposed to create a table and on one column you have to store the following values. '2002-01-25 22:10:15.323' '1980-11-25 22:10:15' '2020-01-25' Whad data type you would choose for that column?

Yes it is a datetime valuedatetime or datetime2(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)Three main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)

6. Does the value '2002-01-25 22:10:15.3239999' respect one of the following formats date, datetime, and datetime2. If Yes which one?

7. Does the value '22:10:15.3239999' respect one of the following formats date, datetime, and datetime2. If Yes which one?

Yes it is a datetime value(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)Three main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)No – date information is missing

8. What is SQL?

9. What is a Primary Key?

(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)Yes it is a datetime valueThree main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)(2x) Primary Keys (PK)- The primary key consists of one or more columns whose data contained within are used to uniquely identify each row in the table. Also, no value in the PK columns can be blank or NULL. A table has just one primary key, and its definition is mandatory The primary key for each table is stored in an index. Indexes – increase performance for the data access (you do not like slow e-commerce sites)

10. Which is the default schema name used in most Microsoft SQL databases?

Yes it is a datetime value(because developers forget or are too lazy to change it) dbo – comes from 'database owner' most of the queries will look something like SELECT * FROM dbo.City – * is a wildcard - represents all columns or SELECT * FROM CityThree main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)

11. What are the most basic and used elements / objects of a relational database?

Tables are the most sed element in a database. Important elements of a table are: Column Names – aka table header, Rows with data, Values on rows and corresponding column (conforming to the date type), - values (eg. '0.00' of decimal data type, 'Springfield' of nvarchar data type) - NULL values - represents empty value / informationYes it is a datetime valueThree main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)

12. What are the main categories of Datatypes in relational databases?

13. What is the minimal information needed when defining a table?

Three main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)Yes it is a datetime value(3x elements) Before storing data (rows) into a table, the table (header) should be defined. This is called table creation / definition. Table Name, Column Names with associated Data Types(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)

14. What are the main numeric data types in MS SQL?

Three main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)A:Two main data types: int – store integers, decimal – store decimals with precision (examples of such values '1.88', '1.8812', '228.00')Yes it is a datetime value

15. Why are schemas needed in a database?

Yes it is a datetime valueThree main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)(2x reasons) In order to organize tables in subgroups. To facilitate permision granting to users - to packages of tables in the same time. (schemas)

16. Does the value '2002-01-25' respect one of the following formats date, datetime, and datetime2. If Yes which one?

17. What are some table elements and data?

18. How do you test if a date time value is a valid datetime datatype?

19. What is a table?

(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)Three main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)Yes it is a datetime value(very beginner definition) A place where the data is stored. It has named Columns. Rows are added and they have to have the same number of columns and data types. Eg. This table has 4 columns of different data types (Id - is of int (number) type, Cname - is of nvarchar (string) type, Bdate - is of datetime type, Samnt is of decimal (number) type, City - is of nvarchar (string) type) It has 4 rows with data Some values do not exist on some rows - they are known as NULL values. (eg. row 4 on column Bdate) Data is accessible using Select statements. To get all the data from the table the query is: SELECT Id, Cname, Bdate, Samnt, City FROM Clients or using * - wildcard that represents all columns SELECT * FROM Clients

20. What statement do we use to fetch data from a Database?

Three main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)SELECT statement (ex. SELECT * FROM dbo.City - using a wildcard or SELECT col1,col2,... FROM dbo.City) * - wildcard, represents all the columns in the table alternatively(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)Yes it is a datetime value

21. How is the place where the data is stored in the database called?

22. Do you know when and who is the inventor of RDBMS (relational database management systems)?

23. if you are supposed to create a table and on one column you have to store the following values. '2002-01-25' '1980-11-25' '2020-04-25' Whad data type you would choose?

24. What are the main elements of the database?

(4 x components) One Database > may contain many Schemas One Schema is a way to group the other contained objects. One Schema > contains many Tables, - they have columns and each column is of a certain type of date. Views, - are named queries Stored Procedures - they contain SQL code that can be run on the server and other many objects that are not so important for the moment.Three main data types: decimal(p,s) – precision and scale. (examples of decimal Datatypes. decimal(18,2), decimal(18,4)) '22342.33' is a decimal(18,2), while '22342.3333' is a decimal(18,4)Yes it is a datetime value(4x reasons) 1.Data is stored in consistent format (ex. do not allow to mix numbers with strings or dates in same column) 2.Allows you to use correspondent calculations and formulas (examples. datediff to calculate time differences or average to calculate average of numbers) 3.It allows storage and performance optimizations 4.It allows proper results ordering (ex. ordering numbers in ascending order is not the same with order string in ascending order)

⚡ 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

24 Questions

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

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.

24 Questions

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

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.

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