Recognises a reserved word used as an identifier
https://knobit.org/id/knobit/K-811
Also as Turtle · JSON-LD · RDF/XML · AI benchmark on Skilirium
| Context functions | Result evaluation |
|---|---|
| Knobit creation methods | AI generated, human edited |
| Knobit types | Skill |
| LCG purposes | Assessing the learner's knowledge or skill state |
| LCG purposes | Selecting an assessment task or learning activity |
| action verb | Recognises en |
| applies knowledge | Explains SQL dialect differences |
| applies knowledge | Explains naming conventions for data model objects |
| assessment criterion | Flags the deficient case and passes the acceptable one. Deficient: A `dim_party` column named `current` for the current relationship owner: reserved in ISO 9075 and in Postgres Acceptable: `is_current_relationship`, with the reserved-word check run against every configured dialect rather than only the development one (`PHY-012`) en |
| assessment method | skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills) en |
| conforms to profile | https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1 |
| dcterms:identifier | K-811 |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| dcterms:source | Review checklist 05-ddl, row 11; ISO 9075; this skill en |
| expected result | The name, the engine reserving it and its replacement en |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/08-ddl/11 |
| rdfs:label | Recognises a reserved word used as an identifier en |
| schema:creativeWorkStatus | accepted |
| schema:isPartOf | Data modelling (DAMA-DMBOK2) |
| skos:altLabel | Reserved word as an identifier (generated DDL) en |
| skos:definition | A table or column name that is reserved on one of the configured targets. It can quote cleanly on four engines and fail on the fifth, or deploy everywhere and break the first hand-written query. en |
| skos:prefLabel | Recognises a reserved word used as an identifier en |
| target object | table or column name en |
Used by
| includes knobit | Generates DDL per target dialect and reviews it against model, engine, data and deployment |
|---|---|
| requires knobit | Generate and review DDL |