Scribd
Upload
2 views2 pages

Class XII Computer Science Sample Paper CBSE

The document outlines the structure of the CBSE Class XII Computer Science examination, detailing the sections, types of questions, and marks distribution. It includes various questions on Python programming, SQL commands, and RDBMS concepts. The exam is divided into multiple sections, including objective questions, short answer questions, and case studies.

Uploaded by

ashwin.duraisamy.001
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views2 pages

Class XII Computer Science Sample Paper CBSE

The document outlines the structure of the CBSE Class XII Computer Science examination, detailing the sections, types of questions, and marks distribution. It includes various questions on Python programming, SQL commands, and RDBMS concepts. The exam is divided into multiple sections, including objective questions, short answer questions, and case studies.

Uploaded by

ashwin.duraisamy.001
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

CBSE Class XII - Computer Science (083)

Time Allowed: 3 Hours


Maximum Marks: 70

SECTION A (1 x 20 = 20)

1. Which data type is immutable in Python?


2. What will be the output? L=[2,4,6] print(len(L))
3. Fill in the blank: ______ statement terminates a loop.
4. True/False: Dictionary allows duplicate keys.
5. Output: s='PYTHON' print(s[1:4])
6. Stack follows which principle?
7. Which SQL command is used to create a table?
8. True/False: pop() removes last element by default.
9. Which SQL function counts total records?
10. Output: L=[10,20,30]; [Link](40); print(L)
11. Assertion-Reason based question on GROUP BY and HAVING.
12. Fill in the blank: ______ removes all rows but keeps structure.
13. True/False: Tuples can be modified.
14. Output: for i in range(1,5,2): print(i,end=" ")
15. In RDBMS, a row is called ______.
16. Clause used with aggregate functions to group data.
17. Output: d={"A":5,"B":10}; print([Link]("C",0))
18. True/False: DROP permanently deletes table.
19. Stack insertion operation is called ______.
20. Primary Key cannot contain ______ values.

SECTION B (2 x 5 = 10)

21. Two differences between List and Tuple.


22. Differentiate DELETE and TRUNCATE.
23. Python code to push element into stack.
24. Output: s="DATABASE"; print(s[-5:-2])
25. SQL query to display average salary from EMP.

SECTION C (3 x 6 = 18)

26. Python program to count even numbers in a list.


OR
SQL query to display maximum salary.

27. Output based question with break statement.


OR
SQL queries on STUDENT table (SUM, AVG, WHERE).

28. Explain any three features of RDBMS.


OR
Explain push and pop operations of stack.

29. Identify error and correct SQL query:


SELECT Name Salary FROM Employee;
OR
Python program to display dictionary keys.

30. SQL query using GROUP BY for department-wise salary.


OR
Output based list slicing question.

SECTION D (4 x 4 = 16)

31. Python program to implement stack.


OR
Explain DDL and DML commands with examples.

32. SQL JOIN queries on EMP and DEPT tables.


OR
Python program to count frequency of list elements.

33. Output based list and pop question.


OR
Explain GROUP BY and HAVING with example.

34. SQL queries using SUM, AVG, COUNT on SALES.


OR
Python program to reverse a string.

SECTION E (Case Study - 6 Marks)

35. Table SALES(SID, Product, Amount, Region)


a) Total sales region-wise.
b) Regions having total sales > 50000.
c) Count products sold in each region.

You might also like