CBSE 2018
Question Paper Design
Class:
XII Subject: Informatics Practices
Q. No.
|
Topic/ Unit
|
Question Type
|
Marks
|
1
|
NETWORKING AND OPEN STANDARDS
|
a). Network Type & Communication Medium
|
2
|
b). Communication Media - Wired & Wireless Media Selection
|
2
|
||
c). Two examples of Open Source Operating System & Open Source Web
Browser
|
2
|
||
d). Expand – GSM – Mobile Communication,
IP – Web Technology
|
2
|
||
e). Device Name – Firewall & Switch
|
2
|
||
10
|
|||
2
|
PROGRAMMING IN JAVA
|
a). Variable Name – valid/ invalid
|
1
|
b). Data Type identification
|
1
|
||
c). Properties & Method or Swing Components (jButton)
|
2
|
||
d). HTML - <P> & <BR> tag
|
2
|
||
e). Difference b/w ComboBox & ListBox.
|
2
|
||
f). if to switch conversion
|
2
|
||
10
|
|||
3
|
RELATIONAL DATABASE MANAGEMENT SYSTEM
|
a). MySql – use & source
|
1
|
b).Identification & Correction of error – UPDATE
|
1
|
||
c). SQL Data Type – “ ”, ‘ ’
|
2
|
||
d). SQL OUTPUT – SELECT & AGGREGATE FUNCTIONS
|
2
|
||
e). SQL OUTPUT - TRANSACTION & SELECT
|
2
|
||
f).SQL SINGLE ROW FUNCTIONS – Date, String & Math
|
2
|
||
10
|
|||
4
|
PROGRAMMING IN JAVA
|
a). Identification of error – SWITCH
|
1
|
b). OUTPUT – While & JOptionPane, Operators
|
2
|
||
c). while to for loop Conversion
|
2
|
||
d). OUTPUT – values of variable after execution – if
|
2
|
||
e). OUTPUT - values of variable after execution – do while
|
2
|
||
f). GUI Problem – Use of for/ while/ if/ operators/ variables
CLEAR – setText(“”)/ setSelected(false)
EXIT – System.exit(0)
|
6
|
||
15
|
|||
5
|
RELATIONAL DATABASE MANAGEMENT SYSTEM
|
i). SELECT Query Where Clause
|
1
|
ii). SELECT Query – LIKE Clause
|
1
|
||
iii). SELECT Query – DISTINCT Clause
|
1
|
||
iv). SELECT Query – Use of + operator
|
1
|
||
v). SELECT Query – ORDER BY Clause
|
1
|
||
vi). SELECT Query – BETWEEN Clause
|
1
|
||
vii). SELECT Query – WHERE Clause & AGGREGATE Function
|
1
|
||
viii). SELECT Query – WHERE/ AGGREGATE Function/ GROUP BY
|
1
|
||
ix). OUTPUT – AGGREGATE Function/ WHERE
|
1
|
||
x). OUTPUT – AGGREGATE Function/ WHERE/ DISTINCT
|
1
|
||
10
|
|||
6
|
RELATIONAL DATABASE MANAGEMENT SYSTEM
|
a). CREATE TABLE
|
2
|
b). PRIMARY & FOREIGN Key with reason
|
2
|
||
c). i) JOIN – SELECT Query – BETWEEN Clause/ Where Clause
ii). JOIN – SELECT Query – LIKE Clause/ Where Clause
iii). UPDATE Query – Where Clause
|
2
2
2
|
||
10
|
|||
7
|
IT APPLICATIONS
|
a). e-governance – Advantage
|
2
|
b). e-learning – Advantage
|
1
|
||
c). Control Selection
|
2
|
||
5
|
|||
MAXIMUM MARKS:
|
70
|
||