@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix knobit: <https://knobit.org/id/knobit/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix register: <https://knobit.org/id/register/> .
@prefix schema: <https://schema.org/> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .

knobit:K-825 a edu:Knobit ;
    rdfs:label "Recognises SQL reviewed without being run"@en ;
    dcterms:identifier "K-825" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    dcterms:source "Review checklist 05-ddl, row 25; Humble & Farley 2010; BCBS 239"@en ;
    skos:altLabel "SQL that has been read and never run (generated DDL)"@en ;
    skos:definition "A `.sql` signed off by reading it. Most engines do not wrap DDL in one transaction, so a script that fails on statement 40 of 60 leaves a half-built schema that looks deployable and is not. The review cannot find a failure the engine has never been asked for."@en ;
    skos:prefLabel "Recognises SQL reviewed without being run"@en ;
    edu:actionVerb "Recognises"@en ;
    edu:appliesKnowledge knobit:K-859 ;
    edu:assessmentCriterion "Flags the deficient case and passes the acceptable one. Deficient: Five dialects generated, Postgres run locally, and the Oracle and Databricks scripts approved by reading them; the Oracle deploy stops at the first check constraint over a `BOOLEAN`-derived `NUMBER(1)` column Acceptable: Every configured dialect executed against an empty database — a container or a scratch schema — in CI, with the drop script run afterwards. The gate for this stage is a green run, not a careful read"@en ;
    edu:assessmentMethod "skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills)"@en ;
    edu:contextFunction <https://knobit.org/def/contextFunction/resultEvaluation> ;
    edu:creationMethod <https://knobit.org/def/creationMethod/aiGeneratedHumanEdited> ;
    edu:expectedResult "The execution test it needs"@en ;
    edu:graphRelevance <https://knobit.org/def/graphRelevance/learnerState>,
        <https://knobit.org/def/graphRelevance/taskSelection> ;
    edu:knobitType <https://knobit.org/def/knobitType/skill> ;
    edu:targetObject "unexecuted DDL"@en ;
    schema:creativeWorkStatus "accepted" ;
    schema:isPartOf register:data-modelling .

edu:Knobit rdfs:label "Knobit"@en,
        "Knobit"@et .

knobit:K-859 rdfs:label "Explains testing DDL by execution and detecting drift"@en .