Skip to main content
DevCrest
Register Now

Database Fundamentals assessment

Test what you learned across the Database Fundamentals path. Every answer comes with an explanation, and you can retry as often as you like.

This assessment covers

  • Describe tables, rows, columns and common SQL data types
  • Use primary keys and foreign keys to model relationships between tables
  • Retrieve data with SELECT, WHERE, ORDER BY and LIMIT
  • Filter precisely with AND, OR, IN, BETWEEN, LIKE and IS NULL
  • Translate everyday questions into correct SQL queries

Database Fundamentals assessment

8 questions • 70% to pass • Practice only, no certificate

  1. 1.In a relational table, what does one row represent?
  2. 2.What must be true of a primary key?
  3. 3.A table enrollments has a column student_id that references students(id). What is student_id?
  4. 4.Which clause sorts the result?
  5. 5.Which query returns the three highest marks?
  6. 6.How do you find rows where the email column has no value?
  7. 7.Which condition matches names starting with the letter S?
  8. 8.Is marks BETWEEN 60 AND 80 inclusive of 60 and 80?
0 of 8 answered