Advertisement

Possibilities for Correcting SQL Exercises Automatically

  • Gabriella Baksa-HaskóEmail author
Conference paper
  • 20 Downloads
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 1135)

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.

Keywords

SQL Data dictionary Evaluation 

References

  1. 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. 2.
    Date, C.J.: An Introduction to Database Systems, 8th edn. Pearson/Addison Wesley (2004)Google Scholar
  3. 3.
    Elmasri, R., Navathe, S.: Fundamentals of Database Systems, 6th edn. Addison-Wesley Publishing Company, Boston (2010)zbMATHGoogle Scholar
  4. 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. 5.
    Oracle: Oracle Database Online Documentation 12c Release 1 (12.1). https://docs.oracle.com/database/121/index.htm

Copyright information

© Springer Nature Switzerland AG 2020

Authors and Affiliations

  1. 1.Corvinus University of BudapestBudapestHungary

Personalised recommendations