API Interface for Analyzing the Correctness of DML Queries

Abstract

Although automated assessment tools have seen significant advancements in recent years, addressing the complexities of analyzing and correcting Data Manipulation Language commands remains a challenge. In educational settings, particularly at institutions like the Faculty of Computer Science and Management, University of Zilina, manual assessment processes can be time-consuming and prone to errors. In response to these challenges, this paper introduces a sophisticated tool aimed at streamlining the analysis and correction of DML commands within the EXAM system. This tool not only automates the tedious aspects of assessment but also offers functionalities such as API interface design, analysis of Oracle database functions, and integration with existing examination systems. By addressing these critical areas, the tool presents a promising solution to enhance educational assessment practices, ensuring accuracy, efficiency, and fairness in grading processes.

Keywords

• sql performance execution plan rewriting queries oracle database