Home Job Term 2 CBSE Class 12 Informatics Practices Syllabus 2022: CBSE 12th Board Exam 2022

Term 2 CBSE Class 12 Informatics Practices Syllabus 2022: CBSE 12th Board Exam 2022

by admin

Verify Time period 2 CBSE Class 12 Informatics Practices Syllabus 2022. It will be important for the preparation of the upcoming Time period 2 CBSE Class 12 IP board examination 2022 (Time period 2).

Verify Time period 2 CBSE Class 12 Informatics Practices Syllabus 2022. College students making ready for Time period 2 CBSE Class 12 Informatics Practices board examination 2022 ought to totally examine this CBSE Class 12  IP Syllabus 2022 & plan their research accordingly. Hyperlink to obtain PDF of Time period 2 CBSE Class 12 Informatics Practices Syllabus 2022 is given on the finish of this text.

CBSE Syllabus: 9th, 10th, 11th, 12th – Revised & Reduced (Term 2 & 1 – Combined): Science, Commerce, Arts!

Time period 2 CBSE Class 12 Informatics Practices Syllabus 2022:

Unit No.

Unit Title

Marks

2

Database Question utilizing SQL

25

3

Introduction to Pc Networks

10

 

Whole

35 Marks

Unit 2:

Database Question utilizing SQL

  • Math capabilities: POWER (), ROUND (), MOD ().
  • Textual content capabilities: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR

(), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM ().

  • Date Capabilities: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (),

DAYNAME (). Combination Capabilities: MAX (), MIN (), AVG (), SUM (), COUNT (); utilizing

COUNT (*).

  • Querying and manipulating knowledge utilizing Group by, Having, Order by.

Unit 3:

Introduction to Pc Networks

  • Introduction to networks, Varieties of community: LAN, MAN, WAN.
  • Community Units: modem, hub, change, repeater, router, gateway.
  • Community Topologies: Star, Bus, Tree, Mesh.
  • Introduction to Web, URL, WWW and its applications- Internet, e-mail, Chat, VoIP.
  • Web site: Introduction, distinction between a web site and webpage, static vs dynamic net web page, net server and internet hosting of a web site.
  • Internet Browsers: Introduction, generally used browsers, browser settings, add-ons and plug-ins, cookies.

Distribution of Sensible Marks

 

Subject

Marks

SQL queries (pen and paper)

7

Sensible File – 12 SQL Queries

2

Ultimate Undertaking Submission

3

Viva

3

Whole

15

Steered Sensible Checklist

Knowledge Administration

– Create a scholar desk with the scholar id, identify, and marks as attributes the place the scholar id is the first key.

– Insert the main points of a brand new scholar within the above desk.

– Delete the main points of a scholar within the above desk.

– Use the choose command to get the main points of the scholars with marks greater than 80.

– Discover the min, max, sum, and common of the marks in a scholar marks desk.

– Discover the whole variety of clients from every nation within the desk (buyer ID, buyer Title, nation) utilizing group by.

– Write a SQL question to order the (scholar ID, marks) desk in descending order of the marks.

For extra particulars, obtain the PDF of Time period 2 CBSE Class 12 Informatics Practices Syllabus 2022 from the hyperlink given under

Download Term 2 CBSE Class 12 Informatics Practices Syllabus 2022 (PDF)

Source link

You may also like

Leave a Comment