GyanMul PrepLearn • Prepare • Grow • Together

GyanMul Prep · NEB +2 · Grade 12

Computer Science (Grade 12)

Everything on these tabs is Computer Science (Grade 12) only, within NEB +2 Grade 12.

Chapter 4 of 26 · Computer Science (Grade 12)

SQL: Data Definition and Data Manipulation

8 topics
Board exam — Database Management System, 8 marks across 4 chapters
12 solved questions

The language itself, split the way the board splits it: the commands that make and alter a structure, and the commands that put rows in and take answers out.

Practise this chapter Read solved questions

Topics

What the syllabus defines for this chapter

1Structured Query Language and its sub-languages
2Data Definition Language: CREATE, ALTER, DROP and TRUNCATE
3Data Manipulation Language: INSERT, UPDATE, DELETE and SELECT
4Differences between DDL and DML, with examples of each

GyanMul Prep · NEB +2 · Grade 12

Computer Science (Grade 12)

Everything on these tabs is Computer Science (Grade 12) only, within NEB +2 Grade 12.

Grade 12 subjects

Chapter 4 of 26 · Computer Science (Grade 12)

SQL: Data Definition and Data Manipulation

8 topics
Board exam — Database Management System, 8 marks across 4 chapters
12 solved questions

The language itself, split the way the board splits it: the commands that make and alter a structure, and the commands that put rows in and take answers out.

Practise this chapter Read solved questions

Topics

What the syllabus defines for this chapter

1Structured Query Language and its sub-languages
2Data Definition Language: CREATE, ALTER, DROP and TRUNCATE
3Data Manipulation Language: INSERT, UPDATE, DELETE and SELECT
4Differences between DDL and DML, with examples of each

5Data types in SQL and constraints: NOT NULL, UNIQUE, PRIMARY KEY, CHECK

6The SELECT statement: WHERE, ORDER BY, GROUP BY and HAVING

7Aggregate functions: COUNT, SUM, AVG, MAX and MIN

8Joining two tables; Data Control Language: GRANT and REVOKE