HP Board Class 12 Syllabus 2022 Computer Science

Himachal Pradesh Board of School Education Dharamshala Class 10+2 Subject: Computer Science Marks Distribution for 2nd Term Examination March 2022 Sr. No. Name of Chapter Marks Allotted 1. Chapter 5, RDBMS Concepts and MYSQL 17 2. Chapter 6, PL/SQL 15 3. Chapter 7, Internet Business Applications 18 Total Marks 50( 20 Objective +30 Descriptive) Final Syllabus Name of Chapter Topics Basic of database systems, Problems in Traditional file Chapter 5, oriented approach, Three level architecture of DBMS, RDBMS Concepts Advantages and Disadvantages of RDBMS, SQL and MYSQL Statements: DDL Statements, DML Statements, DCL Statements, TCL Statements, and SQL Functions. Chapter 6, PL/SQL block structure, Basics of PL/SQL, Controlling PL/SQL Flow for Execution, If statements, IF-THEN-ELSE PL/SQL statement Execution Flow, IF-THEN-ELSEIF statement Execution Flow, LOOP Statement, Basic Loop, For Loop, While Loop. Chapter 7, Internet Business Concept of on line service-E-Commerce Practice, Net Applications Banking, Various kinds of online reservations such as railways, Hotels etc., Social Networking viz, Facebook etc.

Distribution of Marks Sr. No. Type of No. of Question Marks per Total Marks Questions Questions Number Question 1 True/False 10 Q1 1 10 2 Multiple 10 Q2 1 10 Choice questions 3 Very-Very 2 Q4 (a), Q6(a) 2 04 short Answer Questions 4 Very short 3 Q3(a), Q5(a), 3 09 Answer Q6(b) Questions 5 Short 3 Q4(b), Q5(b), 4 12 Answer Q6(c) Questions 6 Long 1 Q3(b) 5 05 Answer Questions Total 29 6 - 50 Note: 30% chapter wise syllabus deleted by HPBOSE has not been included for 2nd Term Examination March 2022 30% Reduced syllabus Name of Chapter Topics 1. Roles of DBA (page no. 165-166) Chapter 5, 2. Data Dictionary (page no. 167-169) RDBMS Concepts 3. Constraints (integrity const.) page no. 170-173 and MYSQL 4. Constraints (page no. 206-211) 5. Concept of Keys (page no. 212-214) Chapter 6, 1. 6.9 Triggers (page no. 243-244) 2. 6.10 Cursors (page no. 244-246) PL/SQL Chapter 7, Internet Business 1. 7.6 Online submission of forms (page no. 260-262) Applications 2. Customer support services (page no. 263-265) 3. Online marketing & shopping (page no. 265-266)