VELAMMAL MATRIC. HR. SEC.
SCHOOL, THENI
(A Matric-JEE/NEET/CA Integrated Hr. Sec. School) R
Std : XII (Mat-CS) Strengthening Exam (2025-26) Marks : 70
Sub : Computer Science Time : 3 hrs
Date: _____________ Invigilator’s Sign: ____________ Exam No : ___________
PART – A
Choose the most appropriate of the four given answers:
15 x 1 = 15
1. Which command lets to change the structure of the table?
a. SELECT b. ORDER BY c. MODIFY d. ALTER
2. Queries can be generated using
a. SELECT b. ORDER BY c. MODIFY d. ALTER
3. The clause used to sort data in a database
a. SORT BY b. ORDER BY c. GROUP BY d. SELECT
4. Which of the following mode is used when dealing with non-text files
like image or exe files?
(A) Text mode (B) Binary mode (C) xls mode
(D) csv mode
5. Making some changes in the data of the existing file or adding more
data is called
(A)Editing (B) Appending (C)Modification (D) Alteration
6. Which of the following is a string used to terminate lines produced
by writer()method of csv module?
(A) Line Terminator (B) Enter key
(C) Form feed (D) Data Terminator
7. Importing C++ program in a Python program is called
(A) wrapping (B) Downloadin (C) Interconnecting (D) Parsing
8. A framework for interfacing Python and C++ is
(A) Ctypes (B) SWIG (C) Cython (D) Boost
9. What does __name__ contains ?
(A) c++ filename (B) main() name
(C) python filename (D) os module name
10. Which of the following is a control structure used to traverse and
fetch the records of the database?
(A) Pointer (B) Key (C) Cursor (D) Insertion
point
11. Which of the following executes the SQL command to perform some
action?
A) execute() (B) key() (C) cursor() (D) run()
12. The function that returns the largest value of the selected column is
(A) MAX() (B) LARGE() (C) HIGH() (D) MAXIMUM()
13. Which of the following module should be imported to visualize data
and information in Python?
a. csv b. getopt c. mysql d. matplotlib
14. ........... is a type of chart which displays information as a series of
data points connected by straight line segments.
a. csv b. Pie chart c. Bar chart d. All the above
15. Which is a python package used for 2D graphics?
a) [Link] b) [Link]
c) [Link] d) [Link]
PART–B
Answer ANY SIX questions. Question No. 24 is compulsory:
6 x 2 = 12
16. Differentiate Unique and Primary Key constraint.
17. Which component of SQL lets insert values in tables and which lets
to create a table??
18. Mention the two ways to read a CSV file using Python
19. What is the use of next() function?
20. What is the use of modules?
21. What is the use of cd command. Give an example.
22. Which method is used to fetch all rows from the database table?
23. Which method is used to connect a database? Give an example.
24. What is the advantage of declaring a column as “INTEGER PRIMARY
KEY”
PART–C
Answer ANY SIX questions. Question No. 33 is compulsory:
6 x 3 = 18
25. Write a SQL statement using DISTINCT keyword.
26. What is a constraint? Write short note on Primary key constraint.
27. Write a Python program to modify an existing file.
28. What is the difference between reader()method and DictReader()
class?
29. What is MinGW? What is its use?
30. What is [Link]? What does it contain?
31. What is SQLite? What is it advantage?
32. Write any three uses of data visualization
33. Write the difference between the following functions
[Link]([1,2,3,4]), [Link]([1,2,3,4] , [1,4,9,16])
PART–D
Answer all the questions: 5x5=
25
34. a) Consider the following employee table. Write SQL commands for
the qtns.(i) to (v).
(i) To display the details of all employees in descending order of pay.
(ii) To display all employees whose allowance is between 5000 and
7000.
(iii) To remove the employees who are mechanic.
(iv) To add a new row.
(v) To display the details of all employees who are operators.
(OR)
b) What are the components of SQL? Write the commands in each.
35. a) Write the rules to be followed to format the data in a CSV file..
(OR)
b) Differentiate Excel file and CSV file.
36. a) Write any 5 features of Python.
(OR)
b) What is the purpose of sys,os,getopt module in [Link].
37. a) i) Explain each word of the following command.
Python <[Link]> -<i> <C++ filename without cpp extension>
ii) Write a Python program to execute the following c++ coding
#include <iostream>
using namespace std;
int main()
{ cout<<“WELCOME”;
return(0);
} The above C++ program is saved in a file
[Link]
(OR)
b) Write in brief about SQLite and the steps used to use it.
38. a) Write a SQL statement to create a table for employee having any
five fields and create a
table constraint for the employee table.
(OR)
b)Explain the various buttons in a matplotlib window.