NEB Class 12 • Computer Science • DBMS • Practice Set

DDL, DML & Database Models Practice Set: NEB 12 Computer

Master DDL, DML and Database Models through clear concepts, representations, a reliable answer method and exam-focused practice.

ConceptsWorked reasoningNEB practice

Worked practice

Build the result from meaning, not memory

A database model defines how data and relationships are represented. DDL creates or changes schema objects, while DML retrieves and modifies stored rows; constraints preserve valid states.

Worked example

CREATE TABLE Student(id INT PRIMARY KEY,name VARCHAR(80)); defines structure, while INSERT INTO Student VALUES(1,’Asha’); adds a row.

The governing relationship is DDL examples: CREATE, ALTER, DROP. DML examples: SELECT, INSERT, UPDATE, DELETE. Use primary and foreign keys to express identity and references. Check the convention, geometry or boundary condition before calculation.

Independent practice ladder

Define the key physical quantities and give their SI units.
Draw and label the relevant wave, ray, mode or energy diagram.
Recalculate the worked example after changing one input by a factor of two.
Explain the result without equations.
Create a Nepal-relevant situation such as a classroom speaker, musical pipe, optical slit or thermal machine.
Compare two cases and predict the larger output before calculating.
Find and repair one deliberately wrong sign, node or unit.
Write a three-mark answer and a five-mark answer.

Answer protocol: diagram → known data → principle → symbolic equation → SI substitution → result → physical check. Using DELETE when DROP is intended or vice versa, omitting a WHERE clause in an update, confusing a table row with a column, or ignoring referential integrity.

NEB answer method

Model → evidence → equation → check

First identify the system and what the question asks. Label the diagram, apparatus or reaction with SI quantities, then state the principle before selecting an equation. Solve symbolically where possible and check units, limiting cases and chemical or physical meaning.

Stage	Question	Evidence
Model	What is idealised?	Assumption stated
Representation	Which diagram fits?	Labels or balanced equation
Calculation	Which relation follows?	Symbols then SI values
Evaluation	Does it make sense?	Unit, sign and trend check

Make the idea concrete in Nepal

Connect the model to a school laboratory, household technology, health, environment, energy or local material. The example should clarify the science rather than merely mention a place. Compare a prediction with an observation and record uncertainty.

Review the NEB Class 12 Computer Science revision roadmap and the complete Computer Science guide. For online or physical tuition, call 9846662070.

Frequently asked questions

Questions students ask about DDL, DML and Database Models

What is the central idea of DDL, DML and Database Models?+

A database model defines how data and relationships are represented. DDL creates or changes schema objects, while DML retrieves and modifies stored rows; constraints preserve valid states.

Which equation should I remember?+

DDL examples: CREATE, ALTER, DROP. DML examples: SELECT, INSERT, UPDATE, DELETE. Use primary and foreign keys to express identity and references.

How should I begin a numerical?+

Draw the situation, list known quantities in SI units, choose the governing relation symbolically, substitute once and finish with a unit and reasonableness check.

What is a common exam mistake?+

Using DELETE when DROP is intended or vice versa, omitting a WHERE clause in an update, confusing a table row with a column, or ignoring referential integrity.

How can I practise this topic?+

Alternate one concept explanation, one diagram and two numericals. Revisit errors after a day instead of only rereading the solution.

Where can I get tuition support?+

For online or physical KTM Tuition classes, call 9846662070. After Grade 12, the MKS Education panel below gives preparation and pre-counselling contacts.

References and next steps

Scope checked against CDC Nepal; concept support from an institutional reference and OpenStax Science. Continue with the DDL, DML and Database Models cluster.

Continue planning