Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
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)
Date, C.J.: An Introduction to Database Systems, 8th edn. Pearson/Addison Wesley (2004)
Elmasri, R., Navathe, S.: Fundamentals of Database Systems, 6th edn. Addison-Wesley Publishing Company, Boston (2010)
ISO/IEC JTC 1/SC 32: Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation), The United States of America (ANSI) (2006)
Oracle: Oracle Database Online Documentation 12c Release 1 (12.1). https://docs.oracle.com/database/121/index.htm
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Switzerland AG
About this paper
Cite this paper
Baksa-Haskó, G. (2020). Possibilities for Correcting SQL Exercises Automatically. In: Auer, M., Hortsch, H., Sethakul, P. (eds) The Impact of the 4th Industrial Revolution on Engineering Education. ICL 2019. Advances in Intelligent Systems and Computing, vol 1135. Springer, Cham. https://doi.org/10.1007/978-3-030-40271-6_58
Download citation
DOI: https://doi.org/10.1007/978-3-030-40271-6_58
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-40270-9
Online ISBN: 978-3-030-40271-6
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)