Possibilities for Correcting SQL Exercises Automatically
- 20 Downloads
In this study, we will present a method for evaluating DDL exercises in an exam situation. In relational database systems, we have not just our data in the database but the metadata about our objects as well in so-called data dictionary tables and views. If we give DDL exercises in an exam and students have to run their statements in a system, not just write them, then we can check the objects they made.
KeywordsSQL Data dictionary Evaluation
- 1.Baksa-Haskó, G.: Self-correcting test bank for SQL basics, in OGIK 2018 VÁLOGATOTT KÖZLEMÉNYEK, Alexander Alapítvány a Jövő Értelmiségéért (2018)Google Scholar
- 2.Date, C.J.: An Introduction to Database Systems, 8th edn. Pearson/Addison Wesley (2004)Google Scholar
- 4.ISO/IEC JTC 1/SC 32: Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation), The United States of America (ANSI) (2006)Google Scholar
- 5.Oracle: Oracle Database Online Documentation 12c Release 1 (12.1). https://docs.oracle.com/database/121/index.htm