SAMPLE PAPER
XII COMP.SCI(083)
Maximum Marks-35 Time- 2.Hrs
General Instructions
The question paper is divided into 3 sections – A, B and C
Section A, consists of 7 questions (1-7). Each question carries 2 marks.
Section B, consists of 3 questions (8-10). Each question carries 3 marks.
Section C, consists of 3 questions (11-13). Each question carries 4 marks.
Internal choices have been given for question numbers 7, 8 and 12.
Section –A
Each question carries 2 marks
1.What is the difference between push ( ) and pop( ) . (2)
2. Give postfix of the following expression. (2)
A* (B+(C+D) * (E+F)/G)*H
3.(a) Expand the term . (1)
ARPANET, Wi-Fi, HTTP
(b)In specific, if systems use separate protocols, which one of
the following devices is used to link two systems ? (1)
(a) Repeater (b) Gateway
(c) Bridge (d) Hub
4. Differentiate the terms primary key and candidate key. (2)
5. Difference between ALTER AND UPDATE commands in SQL.
(2)
6. Rakesh wants to increase the price of some of the products
, by 20 % of his store whose price is less than 200. Assuming the
following structure , what will be the query ? (2)
PNo PName Quantity Price
P001 Biscuits 02 25
P002 Dettol 03 45
P003 Handwashsoap 04 78
7.(a) What are the functions of ALTER TABLE command ?
(1)
(b) Write the syntax of the conditions given below. (1)
(i) Add a column
(ii) DELETE a column from the table.
OR
(a) If the value in the column is repeatable , how do you find
out the unique values ? (1)
(b) What is the purpose of GROUP BY clause in MYSQL ? How is
it different from ORDER BY clause ? (1)
Section –B
Each question carries 3 marks
8. Coach Anuj stores the distance covered and name of the participants in a Dictionary named Races.
Write a program with separate user defined functions to perform the following operations:
Push the names of the participants of the Dictionary onto a Stack, where the distance covered
is more than 100.
Pop and display the items present in the Stack. For Example:
If the Dictionary contains:
XII COMP.SCI(083)
Maximum Marks-35 Time- 2.Hrs
General Instructions
The question paper is divided into 3 sections – A, B and C
Section A, consists of 7 questions (1-7). Each question carries 2 marks.
Section B, consists of 3 questions (8-10). Each question carries 3 marks.
Section C, consists of 3 questions (11-13). Each question carries 4 marks.
Internal choices have been given for question numbers 7, 8 and 12.
Section –A
Each question carries 2 marks
1.What is the difference between push ( ) and pop( ) . (2)
2. Give postfix of the following expression. (2)
A* (B+(C+D) * (E+F)/G)*H
3.(a) Expand the term . (1)
ARPANET, Wi-Fi, HTTP
(b)In specific, if systems use separate protocols, which one of
the following devices is used to link two systems ? (1)
(a) Repeater (b) Gateway
(c) Bridge (d) Hub
4. Differentiate the terms primary key and candidate key. (2)
5. Difference between ALTER AND UPDATE commands in SQL.
(2)
6. Rakesh wants to increase the price of some of the products
, by 20 % of his store whose price is less than 200. Assuming the
following structure , what will be the query ? (2)
PNo PName Quantity Price
P001 Biscuits 02 25
P002 Dettol 03 45
P003 Handwashsoap 04 78
7.(a) What are the functions of ALTER TABLE command ?
(1)
(b) Write the syntax of the conditions given below. (1)
(i) Add a column
(ii) DELETE a column from the table.
OR
(a) If the value in the column is repeatable , how do you find
out the unique values ? (1)
(b) What is the purpose of GROUP BY clause in MYSQL ? How is
it different from ORDER BY clause ? (1)
Section –B
Each question carries 3 marks
8. Coach Anuj stores the distance covered and name of the participants in a Dictionary named Races.
Write a program with separate user defined functions to perform the following operations:
Push the names of the participants of the Dictionary onto a Stack, where the distance covered
is more than 100.
Pop and display the items present in the Stack. For Example:
If the Dictionary contains:
