Home > Databases > Quizzes > Databases Exam Questions
Databases Exam Questions
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 0% Most missed: “Why would we want to use union or union all?”
Databases Exam Questions
Time left 00:00
25 Questions

1. How to make a single-line comment in Postgres?

2. How to make a comment in MySQL?

3. What is a schema?

4. What are the 2 constraints of a primary key?

5. How to run a script on Jupyter Notebook with Postgres instance?

6. What are CRUD operations?

7. How to start using a specific database in SQL?

8. How to get rid of a database in MySQL?

9. Does order matter in Outer joins?

10. The search speed of a B-Tree is usually about the same as

11. How to insert into a table in SQL?

12. Why would we want to use union or union all?

13. What is the basic form of a SQL query?

14. Why MySQL? (9)

15. What format should dates be in?

16. Most complex syntax for an inner join

17. Relational Database Model Design Principles (6)

18. What are columns called in relational databases?

19. How do we enforce a unique row constraint?

20. 4 properties of transactions

21. Why don't we make an index for every column?

22. How to look at the table structure in MySQL?

23. Each node in a b-tree stores an index entry that is made up of 2 things:

24. Does order matter in Inner joins?

25. What is a many-to-many relationship?