Why MySQL is widely used - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all records from the users table.

MySQL

SELECT * FROM [1];

Drag options to blanks, or click blank then click option'

Aorders

Buser

Cusers

Dcustomers

Attempts:

3 left

💡 Hint

Common Mistakes

Using singular form 'user' instead of 'users'.

Selecting from unrelated tables like 'orders'.

The table name is users. Using SELECT * FROM users; retrieves all records.

2fill in blank

medium

Complete the code to find users with age greater than 30.

MySQL

SELECT * FROM users WHERE age [1] 30;

Drag options to blanks, or click blank then click option'

A>

B<

C=

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' which finds ages less than 30.

Using '=' which finds ages exactly 30.

The operator > means 'greater than'. So, age > 30 finds users older than 30.

3fill in blank

hard

Fix the error in the query to count users by city.

MySQL

SELECT city, COUNT(*) AS user_count FROM users GROUP BY [1];

Drag options to blanks, or click blank then click option'

Aage

Bname

Cuser_count

Dcity

Attempts:

3 left

💡 Hint

Common Mistakes

Grouping by 'age' or 'name' instead of 'city'.

Grouping by the alias 'user_count' which is invalid.

Grouping by city counts users per city. Grouping by other columns won't group correctly.

4fill in blank

hard

Fill both blanks to find users whose name starts with 'A' and order by age descending.

MySQL

SELECT * FROM users WHERE name [1] 'A%' ORDER BY age [2];

Drag options to blanks, or click blank then click option'

ALIKE

BASC

CDESC

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' instead of LIKE for pattern matching.

Ordering age ascending instead of descending.

Use LIKE 'A%' to find names starting with 'A'. Use ORDER BY age DESC to sort from oldest to youngest.

5fill in blank

hard

Fill all three blanks to create a new table named 'employees' with columns 'id' (integer primary key), 'name' (text), and 'salary' (decimal).

MySQL

CREATE TABLE [1] (id [2] PRIMARY KEY, name [3], salary DECIMAL(10,2));

Drag options to blanks, or click blank then click option'

Aemployees

BINTEGER

CTEXT

DVARCHAR(100)

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong table name.

Using TEXT instead of VARCHAR for name.

Not specifying PRIMARY KEY for id.

The table name is employees. The id column is an INTEGER primary key. The name column is VARCHAR(100) type.

Practice

1. Why is MySQL considered easy for beginners to learn?

easy

A. Because it requires advanced programming skills

B. Because it has no documentation

C. Because it only works on Windows

D. Because it uses simple and clear SQL commands

Solution

1. Step 1: Understand MySQL's learning curve

   MySQL uses SQL, which is a simple language to read and write for managing data.

2. Step 2: Compare with other options

   Unlike complex programming languages, MySQL commands are straightforward and easy to remember.

3. Final Answer:

   Because it uses simple and clear SQL commands -> Option D

4. Quick Check:

   Simple SQL commands = Easy for beginners [OK]

Hint: Remember: Simple commands mean easier learning [OK]

Common Mistakes:

• Thinking MySQL needs advanced programming
• Believing MySQL only works on one OS
• Assuming no documentation is available

2. Which of the following is the correct way to start the MySQL command line client?

easy

A. mysql -u username -p

B. start mysql client

C. mysql connect username

D. open mysql -user

Solution

1. Step 1: Recall MySQL client start syntax

   The correct command to start MySQL client with username and password prompt is mysql -u username -p.

2. Step 2: Check other options for syntax errors

   Other options are not valid commands and will cause errors.

3. Final Answer:

   mysql -u username -p -> Option A

4. Quick Check:

   Correct command syntax = mysql -u username -p [OK]

Hint: Use '-u' for user and '-p' for password prompt [OK]

Common Mistakes:

• Using incorrect command words
• Omitting '-u' or '-p' flags
• Trying to use natural language commands

3. What will be the output of this MySQL query?

SELECT COUNT(*) FROM users WHERE active = 1;

Assuming the table users has 10 rows with active set to 1.

medium

A. 10

B. 0

C. Error

D. NULL

Solution

1. Step 1: Understand the COUNT(*) function

   COUNT(*) counts all rows matching the condition active = 1.

2. Step 2: Apply the condition to the data

   Since 10 rows have active = 1, the count will be 10.

3. Final Answer:

   10 -> Option A

4. Quick Check:

   COUNT of active=1 rows = 10 [OK]

Hint: COUNT(*) counts all matching rows, not values [OK]

Common Mistakes:

• Confusing COUNT(*) with SUM
• Expecting NULL if no rows match
• Thinking it returns all rows instead of count

4. Identify the error in this MySQL query:

SELECT * FROM users WHERE name = 'John

medium

A. Incorrect table name

B. Missing closing quote for string 'John'

C. Missing WHERE keyword

D. Using * is not allowed

Solution

1. Step 1: Check string literals in the query

   The string 'John' is missing the closing single quote.

2. Step 2: Verify other parts of the query

   The table name and WHERE keyword are correct; using * is allowed to select all columns.

3. Final Answer:

   Missing closing quote for string 'John' -> Option B

4. Quick Check:

   Unclosed string quotes cause syntax errors [OK]

Hint: Always close string quotes in SQL queries [OK]

Common Mistakes:

• Forgetting to close string quotes
• Assuming * is invalid
• Misreading error as table name issue

5. Which reason best explains why MySQL is widely used across many programming languages and platforms?

hard

A. It requires expensive licenses for each use

B. It only works with PHP and Windows

C. It is free and open-source with broad community support

D. It has limited documentation and support

Solution

1. Step 1: Understand MySQL's licensing and support

   MySQL is free and open-source, which encourages wide use and community contributions.

2. Step 2: Consider compatibility and support

   It works on many platforms and languages, unlike options that limit usage or require payment.

3. Final Answer:

   It is free and open-source with broad community support -> Option C

4. Quick Check:

   Free and open-source = Wide usage [OK]

Hint: Free and open-source means many users and support [OK]

Common Mistakes:

• Thinking MySQL is limited to one language or OS
• Believing it requires paid licenses
• Assuming poor documentation