Page 321 - IT-802_class_12
P. 321
iii. This portal is a one point source to access all Indian Government websites at all levels and from all sectors. Name the portal. 1
iv. REEMA wants to arrange names of students in alphabetical order in the student table. Give the MYSQL command to create
a sorted list. 1
v. .................... is not an aggregate function. 1
(a) Sum() (b) Count() (c) Round() (d) Avg()
vi. Give one benefit of online reservation. 1
SECTION B: SUBJECTIVE TYPE QUESTIONS
Answer any 3 out of the given 5 questions on Employability Skills. (2 × 3 = 6 marks)
Answer each question in 20 – 30 words.
Q 7. Explain any two methods to deal with stress. ½ + 1½
Q 8. What are the essential components of effective written communication? 2
Q 9. Explain the concept of "eco-friendly consumerism." How does conscious consumer behavior influence market trends
and encourage sustainable production practices? 2
Q 10. Write down the steps to protect your spreadsheet in Calc? 2
Q 11. What are the two major functions performed by an Entrepreneur? 2
Answer any 3 out of the given 5 questions. (2 × 3 = 6 marks)
Q 12. Give the output of the following code segment- 1+1
public class main {
public static void main(String[] args) {
int day = 4;
switch (day) {
case 6:
System.out.println("Today is Saturday");
break;
case 7:
System.out.println("Today is Sunday");
break;
default:
System.out.println("Looking forward to the Weekend");
}
}
}
Q 13. Explain Drop table with Cascade command in My SQL. 1+1
Q 14. Explain any two operations performed on database. 2
Q 15. A hospital is making database of its doctors and patients. Doctor table includes doc code, idoc name, dept. Give
details of Patient Table along with its schema. 1+1
Q 16. Find error and rewrite the correct code 1+1
i == 0;
while (i < 5)
{ System.out.println(i)
i++;
Answer any 2 out of the given 3 questions. (3 × 2 = 6 marks)
Q 17. Complete the code in JAVA using a loop to print "Yes" 5 times: 1+1+1
______ (int i = 0; i < 5; _______ )
{
______(”yes”);
}
319
CBSE Sample Question Paper 319

