12th Standard Syllabus & Materials
12th Standard
TN 12th Computer Applications மின்னணு தரவு பரிமாற்றம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின் - வணிக பாதுகாப்பு அமைப்புகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின்னணு செலுத்தல் முறைகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின் - வணிகம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications திறந்த மூல கருத்துருக்கள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications வலையமைப்பு வடமிடல் Sample Question Papers Study Material - QB365 Set A

Published on: 31/08/2020
12th Standard Computer Science English Medium Model 2 Mark Creative Questions (New Syllabus) 2020
Download Tamil Nadu 12th Standard Computer Science question papers, model tests, one-mark questions, important questions, and public exam papers in PDF format. Free study materials and answer keys for TN State Board students.
Questions + Answers key
Take MCQ Computer Science Test

1.
Differentiate IN and NOT IN keywords.
2.
Write the syntax of creating table with constraint.
3.
Define Data Manipulation Language.
4.
List few RDBMS packages.
5.
Differentiate lower () and is lower ().
6.
Write the general format of slice operation.
7.
List the characteristics of DBMS.
8.
Write the output for the following program.
9.
What is matplotlib?
10.
Write a note or cursor. description.
11.
How will you execute C++ program through python using MinGW interface? Give example
12.
Name the function which acts as a constructor and destructor.
13.
Write the syntax how break statement used in while loop.
14.
Write a program in python to check if the accepted number us even or odd (use alternate method of if-else).
15.
What is the use of dict( )?
16.
Differentiate text mode and binary mode.
17.
Write the syntax of append () and extend () function.
18.
What is nested list? Give example.
19.
Write a note on Big omega asymptotic notation.
20.
What is algorithmic solution?
21.
What is the purpose of using Input-output functions?
22.
What is the use of LEGB rule?
23.
From the statement P1 : = Preson(), What does P1 and person referred.
24.
Give an example of pure function.
25.
How will you create a set using list or tuple? Give an example.
1.
| IN Keyword | NOT IN keyword |
|---|---|
| The IN keyword is used to specify a list of values which must be matched with the record values. In other words it is used to compare a column with more than one value. It is similar to an OR condition. | The NOT IN keyword displays only those records that do not match in the list |
2.
The syntax for a table created with constraint is given as below
CREATE TABLE < table-name >
( < column namee-cdata type > [ < size > ]
< column constraint >,
( < column name > < data type > [ < size > ]
< column constraint >
< table constraint >( < column name >,
[ < column name > .... ]) .....
);
3.
(i) A Data Manipulation Language (DML) is a computer programming language used for adding (inserting), removing (deleting), and modifying (updating) data in a database. In SQL, the data manipulation language comprises the SQL-data change statements, which modify stored data but not the schema of the database table.
(ii) After the database schema has been specified and the database has been created, the data can be manipulated using a set of procedures which are expressed by DML.
4.
Oracle, MySQL, MS SQL Server, IBM DB2 and Microsoft Access are RDBMS packages.
5.
| lower() | Returns the exact copy of the string with all the letters in lowercase. |
>>> str1='SAVE EARTH' >>> print(str1.lower()) save eath |
| islower() | Returns True if the string is in lowercase. | >>> str1='welcome' >>> print (str1.islower()) True |
6.
General format of slice operation:
str[start:end]
Where start is the beginning index and end is the last index value of a character in the string. Python takes the end value less than one from the actual index specified.
7.
DBMS Supports Transactions : It allows us to better handle and manage data integrity in real world applications where multi-threading is extensively used.
8.
def display (a, b):
return a * * b
print (area (2, 5)
Output: 32
9.
Matplotlib is the most popular data visualization library in Python. It allows to create charts in few lines of code.
10.
cursor. description contains the details of each column headings. It will be stored as a tuple and the first one that is 0(zero) index refers to the column name. Using this command you can display the table's Field names.
11.
Executing C++Program through Python
(i) Double click the run terminal of MinGW
(ii) Go to the folder where the Python software is located (Python.exe) is located.
For example here "Python" is located in
12.
Constructor -( - - init - - ( ))
Destructor -(- - del - - ( ))
13.
while test expression:
#code inside while loop

14.
a = int (input("Enter any number :"))
x="even" if a%2==0 else "odd"
print (a, "is",x)
Output 1:
Enter any number 3
3 is odd
Output 2:
Enter any number: 22
22 is even
15.
The function dict ( ) is used to print the data in dictionary format without order
16.
| Text mode | Binary mode | |
| i) | The default is reading in text mode. | Binary mode returns bytes. |
| ii) | In this mode, while reading from the file the data would be in the format of strings. | This is the mode to be used when dealing with non-text files like image or exe files |
17.
Syntax:
List.append (element to be added)
List.extend ([elements to be added])
18.
(i) Mylist contains another list as an element. This type of list is known as "Nested List': Nested list is a list containing another list as an element.
(ii) Example: Mylist = [ "Welcome", 3.14, 10, [2,4,6] ]
19.
Big Omega is the reverse Big O, if Big O is used to describe the upper bound (worst - case) of a asymptotic function, Big Omega is used to describe the lower bound (best-case).
20.
An algorithm that yields expected output for a valid input is called an algorithmic solution
21.
The input () function helps to enter data at run time by the user and the output function print () is used to display the result of the program on the screen after execution.
22.
The LEGB rule is used to decide the order in which the scopes are to be searched for scope resolution. The scopes are listed below in terms of hierarchy (highest to lowest).
23.
Person is referred to as a class or a type, while p1 is referred to as an object or an instance.
24.
let square x
return: x * x
let i: = 0;
ifi < strlen> (s) then
-- Do something which doesn't affect s
++i
25.
A list or Tuple can be converted as set by using set( ) function. This is very simple procedure. First you have to create a list or Tuple then, substitute its variable within set( ) function as argument.
Example:
MyList= [2, 4, 6, 8, 10]
MySet=set(MyList)
print(MySet)
Output:
{2, 4, 6, 8, 10}
12th Standard Syllabus & Materials
12th Standard
TN 12th Computer Applications களப்பெயர் முறைமை (DNS) Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications வலையமைப்பு எடுத்துக்காட்டுகள் மற்றும் நெறிமுறைகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications கணினி வலையமைப்பு ஓர் அறிமுகம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications PHP-உடன் MySQL-ஐ இணைத்தல் Sample Question Papers Study Material - QB365 Set A
Tamilnadu Stateboard 12th Standard Subjects

Maths

Chemistry

Physics

Biology

Computer Science

Business Maths and Statistics

Economics

Commerce

Accountancy

History

Computer Applications

Biology

Computer Technology

Computer Applications

Computer Science

Business Maths and Statistics

Commerce

Economics

Maths

Chemistry

Physics

Computer Technology

History

Accountancy

Tamil

English

French
Tamilnadu Stateboard Standards