Application of SQL DMO in SQL Server Skills Assessment

Aiming at the lack of SQL Server skills assessment system, this paper proposes a model of skills assessment of SQL Server. It analyzes two key technologies involved in the model: database information access based on SQL DMO and automatic marking of database skills operation. It focuses its analysis on the process and realization of accessing the database information by SQL DMO and discusses the evaluation rules of three different database operations, i.e. addition, deletion and modification. Compared with the system table method in terms of database information access, SQL DMO method is superior because it is simpler to implement technology and more comprehensive in accessing information.