MySQL Online test free - Computer Training, Web design & Graphic Design

MySQl Practice Questions

MySQL also referred to an Structured Query Language. Use the Northwind Database for this quiz

1 / 5

1. Create a report that shows all the CustomerID in lowercase letter and renamed as ID from the customers table.

2 / 5

2. Create a report that shows the top 10 OrderID, OrderDate, ShippedDate, CustomerID, Freight from the orders table sorted by Freight in descending order.

3 / 5

3. Create a report that shows the CategoryName and Description from the categories able sorted by CategoryName.

4 / 5

4. Create a report that shows the ContactName, CompanyName, ContactTitle and Phone number from the customers table sorted by Phone.

5 / 5

5. Create a report that shows the capitalized FirstName and capitalized LastName renamed as FirstName and Lastname respectively and HireDate from the employees table sorted from the newest to the oldest employee.

Your score is

MySQl Practice Questions

MySQL also referred to an Structured Query Language. Use the Northwind Database for this quiz

1 / 5

1. Create a report that shows the ContactName, CompanyName, ContactTitle and Phone number from the customers table sorted by Phone.

2 / 5

2. Create a report that shows the capitalized FirstName and capitalized LastName renamed as FirstName and Lastname respectively and HireDate from the employees table sorted from the newest to the oldest employee.

3 / 5

3. Create a report that shows all the CustomerID in lowercase letter and renamed as ID from the customers table.

4 / 5

4. Create a report that shows the top 10 OrderID, OrderDate, ShippedDate, CustomerID, Freight from the orders table sorted by Freight in descending order.

5 / 5

5. Create a report that shows the CategoryName and Description from the categories able sorted by CategoryName.

Your score is

Join our MySQL Training

Click Here

MySQl Practice Questions

MySQL also referred to an Structured Query Language. Use the Northwind Database for this quiz

1 / 5

1. Create a report that shows the ContactName, CompanyName, ContactTitle and Phone number from the customers table sorted by Phone.

2 / 5

2. Create a report that shows the top 10 OrderID, OrderDate, ShippedDate, CustomerID, Freight from the orders table sorted by Freight in descending order.

3 / 5

3. Create a report that shows the capitalized FirstName and capitalized LastName renamed as FirstName and Lastname respectively and HireDate from the employees table sorted from the newest to the oldest employee.

4 / 5

4. Create a report that shows the CategoryName and Description from the categories able sorted by CategoryName.

5 / 5

5. Create a report that shows all the CustomerID in lowercase letter and renamed as ID from the customers table.

Your score is

MySQl Practice Questions

MySQL also referred to an Structured Query Language. Use the Northwind Database for this quiz

1 / 5

1. Create a report that shows the CategoryName and Description from the categories able sorted by CategoryName.

2 / 5

2. Create a report that shows the ContactName, CompanyName, ContactTitle and Phone number from the customers table sorted by Phone.

3 / 5

3. Create a report that shows the top 10 OrderID, OrderDate, ShippedDate, CustomerID, Freight from the orders table sorted by Freight in descending order.

4 / 5

4. Create a report that shows the capitalized FirstName and capitalized LastName renamed as FirstName and Lastname respectively and HireDate from the employees table sorted from the newest to the oldest employee.

5 / 5

5. Create a report that shows all the CustomerID in lowercase letter and renamed as ID from the customers table.

Your score is

Join our MySQL Training

Get in touch

Call

Chat

Email

Computer Basics

Web Development

Programming

Data Analytics

Digital Marketing

CAD & Animation

GIS

Online Courses

Contact

Company

Courses