Test for DB specialist (SQL / MySQL)
• Questions are in English, we will appreciate if you will answer in English, but Czech answers are also
acceptable.
• Please do not use external information sources (books, internet, …).
• If you do not know the answer, please indicate this by writing “NA”.
• You have 1 hour to complete this test.
1. What is the difference between DML and DDL?
2. What is a “trigger”?
3. Describe differences between DELETE, TRUNCATE and DROP.
4. What is the difference between INNER JOIN and OUTER JOIN?
5. What is a Coalesce?
6. What is the difference between PRIMARY KEY and UNIQUE KEY?
7. We have this table:
Customer Insurance status Insurance Loss ratio [%]
Frantisek Vomacka Active POV 0.00
Jiri Svoboda Active HAV 35.02
Lenka Novakova Active, Active, Closed POV, HAV, Travel 69.13
Michal Krecek Closed Travel 0.00
Jana Mala Active POV 141.25
Tomas Brezovec Active, New Travel, POV 0.00
Please create a database structure to hold this data in the database and create a SELECT to read it
from your tables, or the SELECT as close as possible to it.
*
*