Quiz 1 of 0

Exam simulator: CompTIA Data+ SQL Hands-on Exercices

Anastasia-Instructor August 31, 2022

Time limit: 0

Quiz Summary

0 of 15 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 15 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Write a SQL statement that displays all the information about the real estate table.

 
Table name: real_estate
realestate_id       |  name       |   city   | commission 
--------------------+-------------+----------+------------
        1001        | James Lyck  | New York |   0.15
        1002        | Nail Alex   | Paris    |   0.13
        1003        | Nick Knick  | London   |   0.11
        1004        | Mc Byon     | Paris    |   0.14

Correct

Incorrect

Question 2 of 15

2. Question

Write a SQL statement that will select the city column from the real estate table.

 
Table name: real_estate
realestate_id       |  name       |   city   | commission 
--------------------+-------------+----------+------------
        1001        | James Lyck  | New York |   0.15
        1002        | Nail Alex   | Paris    |   0.13
        1003        | Nick Knick  | London   |   0.11
        1004        | Mc Byon     | Athens   |   0.14

Correct

Incorrect

Question 3 of 15

3. Question

Select all the different values from the commission column in the real estate table.

 
Table name: real_estate
realestate_id       |  name       |   city   | commission 
--------------------+-------------+----------+------------
        1001        | James Lyck  | New York |   0.15
        1002        | Nail Alex   | Paris    |   0.13
        1003        | Nick Knick  | London   |   0.11
        1004        | Mc Byon     | Paris    |   0.11

Correct

Incorrect

Question 4 of 15

4. Question

Write a SQL statement that will select all records where the city column has the value “Paris”.

 
Table name: real_estate
realestate_id       |  name       |   city   | commission 
--------------------+-------------+----------+------------
        1001        | James Lyck  | New York |   0.15
        1002        | Nail Alex   | Paris    |   0.13
        1003        | Nick Knick  | London   |   0.11
        1004        | Mc Byon     | Athens   |   0.14

Correct

Incorrect

Question 5 of 15

5. Question

From the following table, write a SQL query to find real estate agents whose commission is 0.11.

 
Table name: real_estate
realestate_id       |  name       |   city   | commission 
--------------------+-------------+----------+------------
        1001        | James Lyck  | New York |   0.15
        1002        | Nail Alex   | Paris    |   0.13
        1003        | Nick Knick  | London   |   0.11
        1004        | Mc Byon     | Athens   |   0.14

Correct

Incorrect

Question 6 of 15

6. Question

From the following table, write a SQL query to find orders that are delivered by a salesman with ID. 801.

Table name: orders
ord_no        amount         ord_date     customer_id   salesman_id
----------  ----------      ----------    -----------   -----------
2021         422.20         2022-10-05      2005          801
2022          50.85         2022-09-09      2001          888
2023         120.05         2021-04-03      2002          900

Correct

Incorrect

Question 7 of 15

7. Question

Use the NOT keyword to select all records where City is NOT “London”.

 
Table name: real_estate
realestate_id       |  name       |   city   | commission 
--------------------+-------------+----------+------------
        1001        | James Lyck  | New York |   0.15
        1002        | Nail Alex   | Paris    |   0.13
        1003        | Nick Knick  | London   |   0.11
        1004        | Mc Byon     | Athens   |   0.14

Correct

Incorrect

Question 8 of 15

8. Question

Select all records where the City column has the value ‘Paris’ and the commission column has the value 0.14.

 
Table name: real_estate
realestate_id       |  name       |   city   | commission 
--------------------+-------------+----------+------------
        1001        | James Lyck  | New York |   0.15
        1002        | Nail Alex   | Paris    |   0.13
        1003        | Nick Knick  | London   |   0.11
        1004        | Mc Byon     | Athens   |   0.14
        1005        | Luis Jam    | Paris    |   0.14

Correct

Incorrect

Question 9 of 15

9. Question

Write a SQL statement to find the Winners in the field of “Economics” since 1980. Return only the winner and country.

Table name: winners
YEAR FIELD                     WINNER                             COUNTRY                
---- ---------------------     ----------------------------       -------------------
1972 Physics                   Haddesh Luke                       Germany                 
1960 Physics                   Nouiz Deel                         Italy                 
1988 Chemistry                 Luis Fed.                          France                 
1967 Literature                Aleksandr Sotsyn                   Russia                 
1970 Economics                 Mike Druelson                      USA

Correct

Incorrect

Question 10 of 15

10. Question

Select all records where the Country column has the value ‘Italy’ or ‘USA’.

Table name: winners
YEAR FIELD                     WINNER                             COUNTRY                
---- ---------------------     ----------------------------       -------------------
1972 Physics                   Haddesh Luke                       Germany                 
1960 Physics                   Nouiz Deel                         Italy                 
1988 Chemistry                 Luis Fed.                          France                 
1967 Literature                Aleksandr Sotsyn                   Russia                 
1970 Economics                 Mike Druelson                      USA

Correct

Incorrect

Question 11 of 15

11. Question

From the following table, write a SQL query to retrieve all the details of the real estate agents whose first names match with the string ‘Nick’.

 
Table name: real_estate
realestate_id       |  name       |   city   | commission 
--------------------+-------------+----------+------------
        1001        | James Lyck  | New York |   0.15
        1002        | Nail Alex   | Paris    |   0.13
        1003        | Nick Knick  | London   |   0.11
        1004        | Mc Byon     | Athens   |   0.14
        1005        | Nick Lyck   | Berlin   |   0.18

Correct

Incorrect

Question 12 of 15

12. Question
Assuming you have the column ‘CustomerName’ in the Customers table. Insert a new record with the value “Nick Burger”.
Correct

Incorrect
Question 13 of 15

13. Question
Write a SQL statement that will select all records from the Agents table where the ‘Address’ column is empty.
Correct

Incorrect
Question 14 of 15

14. Question
Write a SQL statement that will select all records from the Agents table where the ‘Address’ column is NOT empty.
Correct

Incorrect

Question 15 of 15

15. Question

Delete all the records from the Agents table where the City value is ‘Paris’.

 
Table name: Agents
realestate_id       |  name       |   city   | commission 
--------------------+-------------+----------+------------
        1001        | James Lyck  | New York |   0.15
        1002        | Nail Alex   | Paris    |   0.13
        1003        | Nick Knick  | London   |   0.11
        1004        | Mc Byon     | Athens   |   0.14

Correct

Incorrect

Exam simulator: CompTIA Data+ SQL Hands-on Exercices

Anastasia-Instructor August 31, 2022

Quiz Summary

Information

Results

Results

Categories

1. Question

Write a SQL statement that displays all the information about the real estate table.

2. Question

Write a SQL statement that will select the city column from the real estate table.

3. Question

Select all the different values from the commission column in the real estate table.

4. Question

Write a SQL statement that will select all records where the city column has the value “Paris”.

5. Question

From the following table, write a SQL query to find real estate agents whose commission is 0.11.

6. Question

From the following table, write a SQL query to find orders that are delivered by a salesman with ID. 801.

7. Question

Use the NOT keyword to select all records where City is NOT “London”.

8. Question

Select all records where the City column has the value ‘Paris’ and the commission column has the value 0.14.

9. Question

Write a SQL statement to find the Winners in the field of “Economics” since 1980. Return only the winner and country.

10. Question

Select all records where the Country column has the value ‘Italy’ or ‘USA’.

11. Question

From the following table, write a SQL query to retrieve all the details of the real estate agents whose first names match with the string ‘Nick’.

12. Question

Assuming you have the column ‘CustomerName’ in the Customers table. Insert a new record with the value “Nick Burger”.

13. Question

Write a SQL statement that will select all records from the Agents table where the ‘Address’ column is empty.

14. Question

Write a SQL statement that will select all records from the Agents table where the ‘Address’ column is NOT empty.

15. Question

Delete all the records from the Agents table where the City value is ‘Paris’.