New ! Computer Science MCQ Practise Tests

12th Standard Computer Science Study material & Free Online Practice Tests - View Model Question Papers with Solutions for Class 12 Session 2020 - 2021
TN Stateboard [ Chapter , Marks , Book Back, Creative & Term Based Questions Papers - Syllabus, Study Materials, MCQ's Practice Tests etc..]

Computer Science Question Papers

12th Standard Computer Science English Medium - Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a python code to display the following, plot.

  • 2)

    Write the key differences between Histogram and bar graph.

  • 3)

    Write s python code to display to following plot.
    Program

  • 4)

    How will you plot two lines? Give an example with output.

  • 5)

    What is bar chart? Explain with an example coding.

12th Standard Computer Science English Medium - Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain in detail the types of pyplots using Matplotlib.

  • 2)

    Explain the various buttons in a matplotlib window.

  • 3)

    Explain the purpose of the following functions:
    a. plt.xlabel
    b. plt.ylabel
    c. plt.title
    d. plt.legend()
    e. plt.show()

12th Standard Computer Science English Medium - Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a python code to display the following plot.

  • 2)

    Write a python code to display the following plot.

  • 3)

    List the buttons in matlibplot window.

  • 4)

    Read the following code. What does the following represents.
    (i) Labels
    (ii) Usage
    (iii) X ticks
    (iv) Range
    (v) Show

  • 5)

    What is the output for the following coding:

12th Standard Computer Science English Medium - Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Draw the output for the following data visualization plot.
    import matplotlib.pyplot as plt
    plt.bar([1,3,5,7,9],[5,2,7,8,2], label="Example one")
    plt.bar([2,4,6,8,10],[8,6,2,5,6], label="Example two", color='g')
    plt.legend()
    plt.xlabel('bar number')
    plt.ylabel('bar height')
    plt.title('Epic Graph in Another Line! Whoa')
    plt.show()

  • 2)

    Write any three uses of data visualization.

  • 3)

    Write the coding for the following:
    a. To check if PIP is Installed in your PC.
    b. To Check the version of PIP installed in your PC.
    c. To list the packages in matplotlib.

  • 4)

    Write the plot for the following pie chart output.

12th Standard Computer Science English Medium - Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is Infographics data visualization?

  • 2)

    What is Dashboard?

  • 3)

    What is matplotlib?

  • 4)

    Define scatter plot.

  • 5)

    Write note or Box plot.

12th Standard Computer Science English Medium - Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Define: Data Visualization.

  • 2)

    List the general types of data visualization.

  • 3)

    List the types of Visualizations in Matplotlib.

  • 4)

    How will you install Matplotlib?

  • 5)

    Write the difference between the following functions: plt.plot([1,2,3,4]), plt.plot([1,2,3,4], [1,4,9,16]).

12th Standard Computer Science English Medium - Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which kind of data encoded visually communicate a quantitative message

  • 2)

    The numerical data is encoded using

  • 3)

    Which of the following is not a type of Data Visualization?

  • 4)

    Which of the following is the representation of information in a graphic format?

  • 5)

    Which of the following is a collection of resources assembled to create a single unified visual display?

12th Standard Computer Science English Medium - Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which is a python package used for 2D graphics?

  • 2)

    Identify the package manager for Python packages, or modules.

  • 3)

    Read the following code: Identify the purpose of this code and choose the right option from the following.
    C:\Users\YourName\AppData\Local\Programs\Python\Python36-32\Scripts>pip –version

  • 4)

    Read the following code: Identify the purpose of this code and choose the right option from the following.
    C:\Users\Your Name\AppData\Local\Programs\Python\Python36-32\Scripts>pip list

  • 5)

    To install matplotlib, the following function will be typed in your command prompt. What does “-U”represents?
    Python –m pip install –U pip

12th Standard Computer Science English Medium - Data Manipulation Through SQL 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain briefly about SELECT Query.

  • 2)

    Explain in detail about fetching records from the table.

  • 3)

    Explain in detail about various clauses in SQL.

  • 4)

    Explain the SQL operators with clauses in detail.

  • 5)

    Explain in detail about aggregate functions with an example.

12th Standard Computer Science English Medium - Data Manipulation Through SQL 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write in brief about SQLite and the steps used to use it.

  • 2)

    Write the Python script to display all the records of the following table using fetchmany()

    Icode ItemName Rate
    1003 Scanner 10500
    1004 Speaker 3000
    1005 Printer 8000
    1008 Monitor 15000
    1010 Mouse 700

     

  • 3)

    hat is the use of HAVING clause. Give an example python script

  • 4)

    Write a Python script to create a table called ITEM with following specification.
    Add one record to the table.
    Name of the database :- ABC
    Name of the table :- Item
    Column name and specification :-

    I code :- Integer and act as primary key
    Item Name :- Character with length 25
    Rate :- Integer
    Record to be added :- 1008, Monitor, 15000
  • 5)

    Consider the following table Supplier and item .Write a python script for (i) to (ii)

    SUPPLIER
    Suppno Name City Icode SuppQty
    S001 Prasad Delhi 1008 100
    S002 Anu Bangalore 1010 200
    S003 Shahid Bangalore 1008 175
    S004 Akila Hydrabad 1005 195
    S005 Girish Hydrabad 1003 25
    S006 Shylaja Chennai 1008 180
    S007 Lavanya Mumbai 1005 325

    i) Display Name, City and Itemname of suppliers who do not reside in Delhi.
    ii) Increment the SuppQty of Akila by 40

12th Standard Computer Science English Medium - Data Manipulation Through SQL 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain how the SELECT statement can be used along with GROUP BY class.

  • 2)

    Write the sqlite steps to connect the database.

  • 3)

    Explain how a connect to be made to a database (Academy through python SQlite3.

  • 4)

    What is the use of aggregate functions used along with SELECT statement? What are they?

  • 5)

    What is the purpose of using
    (i) COUNT ( )
    (ii) AVG ( )
    (iii) SUM ( )
    (iv) MAX ( )
    (v) MIN ( )

12th Standard Computer Science English Medium - Data Manipulation Through SQL 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is SQLite?What is it advantage?

  • 2)

    Mention the difference between fetchone() and fetchmany()

  • 3)

    What is the use of Where Clause.Give a python statement Using the where clause.

  • 4)

    Read the following details. Based on that write a python script to display department wise records
    database name:- organization.db
    Table name:- Employee
    Columns in the table:- Eno, EmpName, Esal, Dept

  • 5)

    Read the following details.Based on that write a python script to display records in desending order of
    Eno
    database name :- organization.db
    Table name :- Employee
    Columns in the table :- Eno, EmpName, Esal, Dept

12th Standard Computer Science English Medium - Data Manipulation Through SQL 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is a cursor in SQL and databases?

  • 2)

    What is the reason behind defining a SQL command with triple quotes?

  • 3)

    What is master table?

  • 4)

    How will you sort the data in a table in an ordered way?

  • 5)

    What is the use of AND, OR operators combined with WHERE clause?

12th Standard Computer Science English Medium - Data Manipulation Through SQL 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Mention the users who uses the Database.

  • 2)

    Which method is used to connect a database? Give an example.

  • 3)

    What is the advantage of declaring a column as “INTEGER PRIMARY KEY”

  • 4)

    Write the command to populate record in a table. Give an example.

  • 5)

    Which method is used to fetch all rows from the database table?

12th Standard Computer Science English Medium - Data Manipulation Through SQL 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of following is fast, flexible and easy to work?

  • 2)

    Which method is SQlite is used create a connection with a database file created?

  • 3)

    Which method has a major role in working with python?

  • 4)

    The SQlite command opens the already created database is

  • 5)

    Which of the following is a command to open the already created database from the statement connection = sqlite3.connect ("ABC.db")

12th Standard Computer Science English Medium - Data Manipulation Through SQL 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of the following is an organized collection of data?

  • 2)

    SQLite falls under which database system?

  • 3)

    Which of the following is a control structure used to traverse and fetch the records of the database?

  • 4)

    Any changes made in the values of the record should be saved by the command

  • 5)

    Which of the following executes the SQL command to perform some action?

12th Standard Computer Science English Medium - Importing C++ Programs in Python 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain the commands for wrapping C++ code.

  • 2)

    Write a python program to execute the following C++ program.
    /*. To check whether the number is palindrome or not using while Ioop.*/
    // Now select File →New in Notepad and type the C++ program
    #include < iostream >
    using namespace std;
    intmain ( )
    {
    int n, num, digit, rev = 0;
    cout<<  "Enter a positive number: ";
    cin >>num;
    n= num;
    while(num)
    {digit = num % 10;
    rev = (rev * 10) + digit;
    num = num / 10; }
    cout<< "The reverse of the number is: " << rev <<endl;
    if(n == rev)
    cout< < "The number is a palindrome";
    else
    cout << "The number is not a palindrome";
    return 0;
    }
    // Save this file as pali_cpp.cpp

  • 3)

    Write a python program to execute the following C++ program.
    Transpose of a matrix(2 D array) C++ program:
    #include < iostream >
    using namespace std;
    int main ( )
    {
    int a[3][3], i, j;
    for(i=0; i< 3; i++)
    {
    for(j=0; j<3; j++)
    {cout<< "enter the value for
    array["<< i+ 1<< "]"<< " ["<< j+ 1<< "] :";
    cin >>a[i][j];
      }
    }
    system ("cIs");
    cout<< "\n\nOriginal Array\n";
    for(i=0; i<3; i++) {
    for(j=0; j<3; j++ )
    cout<< a[i][j]«' ';
    cout<< endl; }
    cout<< "\n\n The Transpose of Matrix\n";
    for (int i = 0; i < 3; i++)

      for (int j = 0; j < 3; j++)
    cout<< a[j][i]<< ' ';
    cout<< endl;

    return 0;
    }
    // Save this file as trans_cpp.cpp

  • 4)

    Write a python program to execute the following C++ program.
    C++ program:
    /*Write a C++ program using a user defined
    function to function cube of a number. */
    // Now select File⇾New in Notepad and type the C++ program
    #include
    using namespace std;
    // Function declaration
    int cube(int num),
    int main( )
    {
    int num;
    int c;
    cout<< "Enter any number: "<<endl;
    cin >>num;
    c = cube(num);
    cout<< "Cube of" << num<<  " is "<< c;
    return 0;
    }
    //Function to find cube of any number
    int cube(int num)
    {
    return (num * num * num);
    }
    // Save this file as cube_file.cpp

  • 5)

    Write a python program to execute the following C++ program
    To implement Multilevel Inheritance:
    // C++ program to implement Multilevel Inheritance
    // Now select File ⟶New in Notepad and type the C++ program
    c++ Program.
    #include < iostream >
    using namespace std;
    // base class
    class Vehicle
    {
    public:
    Vehicle ( )
    {
    cout<< "This is a Vehicle" << endl;
    }
    };
    class threeWheeler: public Vehicle
    { public:
    three Wheeler ( )
    {
    cout << "Objects with 3 wheels are vehicles" << endl;
      }
    };
    // sub class derived from two base classes
    class Auto: public threeWheeler{
    public: 
    Auto ( )

    cout<< "Auto has 3 Wheels"<< endl;
    };
    // main function
    int main ( )
    {
    //creating object of sub class will invoke the constructor of base classes
    Auto obj;
    return 0;
    }
    // Save this file as inheri_cpp.cpp

12th Standard Computer Science English Medium - Importing C++ Programs in Python 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write any 5 features of Python.

  • 2)

    Explain each word of the following command.
    Python  < filename.py > - < i > <C++ filename without cpp extension>

  • 3)

    What is the purpose of sys, os, getopt module in Python.Explain.

  • 4)

    Write the syntax for getopt( ) and explain its arguments and return values.

  • 5)

    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 welcome.cpp

12th Standard Computer Science English Medium - Importing C++ Programs in Python 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a note on
    (i) sys module
    (ii) OS module
    (iii) getopt module

  • 2)

    List the commonly used python interfaces.

  • 3)

    How to import modules in python?

  • 4)

    Write an algorithm for executing C++ program pali_cpp.cpp using python program.pall.py.

  • 5)

    Write short notes on python language.

12th Standard Computer Science English Medium - Importing C++ Programs in Python 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Differentiate PYTHON and C++.

  • 2)

    What are the applications of scripting language?

  • 3)

    What is MinGW? What is its use?

  • 4)

    Identify the module, operator, definition name for the following
    welcome.display().

  • 5)

    What is sys.argv? What does it contain?

12th Standard Computer Science English Medium - Importing C++ Programs in Python 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Differentiate static typed language and dynamic typed language.

  • 2)

    List some scripting language

  • 3)

    What is garbage collection in python?

  • 4)

    What is the use of GNU C complier?

  • 5)

    How will you execute C++ program through python using MinGW interface? Give example

12th Standard Computer Science English Medium - Importing C++ Programs in Python 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is the theoretical difference between Scripting language and other programming language?

  • 2)

    Differentiate compiler and interpreter.

  • 3)

    Write the expansion of (i) SWIG (ii) MinGW

  • 4)

    What is the use of modules?

  • 5)

    What is the use of cd command. Give an example.

12th Standard Computer Science English Medium - Importing C++ Programs in Python 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of the following are general purpose programming language?

  • 2)

    Which of the following is not general purpose language?

  • 3)

    Which of the following is not a compiled statically typed language?

  • 4)

    In which language datatype or not required while declare variable?

  • 5)

    Which of the following can act both as scripting and general purpose language?

12th Standard Computer Science English Medium - Importing C++ Programs in Python 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of the following is not a scripting language?

  • 2)

    Importing C++ program in a Python program is called

  • 3)

    The expansion of API is

  • 4)

    A framework for interfacing Python and C++ is

  • 5)

    Which of the following is a software design technique to split your code into separate parts?

12th Standard Computer Science English Medium - Python and CSV Files 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a program to read the CSV file through python using reader ( ) method.

  • 2)

    Write a program to read the CSV file which contains spaces after the delimiter.

  • 3)

    Write a program to read the CSV file with user defined delimiter.

  • 4)

    Write a program to read a specific column in a CSV file.

  • 5)

    Write a program to read the CSV file and store it in a list.

12th Standard Computer Science English Medium - Python and CSV Files 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Differentiate Excel file and CSV file.

  • 2)

    Tabulate the different mode with its meaning.

  • 3)

    Write the different methods to read a File in Python.

  • 4)

    Write a Python program to write a CSV File with custom quotes.

  • 5)

    Write the rules to be followed to format the data in a CSV file.

12th Standard Computer Science English Medium - Python and CSV Files 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    How will you create CSV normal file?

  • 2)

    How will you save the CSV file in MS-Excel?

  • 3)

    Write the syntax of reader( ).

  • 4)

    Write a program to read a file with default delimiter comma.

  • 5)

    What are the different ways of reading a CSV file using reader ( ) method?

12th Standard Computer Science English Medium - Python and CSV Files 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a note on open() function of python. What is the difference between the two methods?

  • 2)

    Write a Python program to modify an existing file.

  • 3)

    Write a Python program to read a CSV file with default delimiter comma (,).

  • 4)

    What is the difference between the write mode and append mode.

  • 5)

    What is the difference between reader() and DictReader() function?

12th Standard Computer Science English Medium - Python and CSV Files 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Why CSV file is known as flat file?

  • 2)

    What is the use of CSV file?

  • 3)

    How will prefect the CSV File data contains common by itself?

  • 4)

    Expand
    (i) CSV 
    (ii) CRLF

  • 5)

    How the CSV file operation takes place in python?

12th Standard Computer Science English Medium - Python and CSV Files 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is CSV File?

  • 2)

    Mention the two ways to read a CSV file using Python.

  • 3)

    Mention the default modes of the File.

  • 4)

    What is use of next() function?

  • 5)

    How will you sort more than one column from a csv file?Give an example statement.

12th Standard Computer Science English Medium - Python and CSV Files 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    A CSV file is also known as a ….

  • 2)

    The expansion of CRLF is

  • 3)

    Which of the following module is provided by Python to do several operations on the CSV files?

  • 4)

    Which of the following mode is used when dealing with non-text files like image or exe files?

  • 5)

    The command used to skip a row in a CSV file is

12th Standard Computer Science English Medium - Python and CSV Files 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    A CSV file is also known as a ….

  • 2)

    The expansion of CRLF is

  • 3)

    Which of the following module is provided by Python to do several operations on the CSV files?

  • 4)

    Which of the following mode is used when dealing with non-text files like image or exe files?

  • 5)

    The command used to skip a row in a CSV file is

12th Standard Computer Science English Medium - Structured Query Language (SQL) 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write the processing skills of SQL.

  • 2)

    Explain ALTER command in detail.

  • 3)

    Write a note on
    (i) TRUNCATE command.
    (ii) DROP TABLE command.

  • 4)

    Explain TCL commands in detail.

  • 5)

    Explain the data types available in SQL.

12th Standard Computer Science English Medium - Structured Query Language (SQL) 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write the different types of constraints and their functions.

  • 2)

    Consider the following employee table. Write SQL commands for the qtns.(i) to (v).

    EMP CODE NAME DESIG PAY ALLOWANCE
    S1001 Hariharan Supervisor 29000 12000
    P1002 Shaji Operator 10000 5500
    P1003 Prasad Operator 12000 6500
    C1004 Manjima Clerk 8000 4500
    M1005 Ratheesh Mechanic 20000 7000

    (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.

  • 3)

    What are the components of SQL? Write the commands in each.

  • 4)

    Construct the following SQL statements in the student table-
    (i) SELECT statement using GROUP BY clause.
    (ii) SELECT statement using ORDER BY clause.

  • 5)

    Write a SQL statement to create a table for employee having any five fields and create a table constraint for the employee table.

12th Standard Computer Science English Medium - Structured Query Language (SQL) 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    How the data in RDBMs is stored? Explain.

  • 2)

    List the types of constraints.

  • 3)

    Write the function performed by DDL.

  • 4)

    Define Data Control Language and also list the command under this.

  • 5)

    Write the syntax for the following commands.
    (i) INSERT
    (ii) DELETE
    (iii) UPDATE

12th Standard Computer Science English Medium - Structured Query Language (SQL) 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is a constraint? Write short note on Primary key constraint.

  • 2)

    Write a SQL statement to modify the student table structure by adding a new field.

  • 3)

    Write any three DDL commands.

  • 4)

    Write the use of Savepoint command with an example.

  • 5)

    Write a SQL statement using DISTINCT keyword.

12th Standard Computer Science English Medium - Structured Query Language (SQL) 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Expand
    (i) SQL
    (ii) DBMS
    (iii) RDBMS

  • 2)

    What is SQL?

  • 3)

    List few RDBMS packages.

  • 4)

    What is RDBMS?

  • 5)

    How will you create database and work with the database? Give example.

12th Standard Computer Science English Medium - Structured Query Language (SQL) 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a query that selects all students whose age is less than 18 in order wise.

  • 2)

    Differentiate Unique and Primary Key constraint

  • 3)

    Write the difference between table constraint and column constraint?

  • 4)

    Which component of SQL lets insert values in tables and which lets to create a table?

  • 5)

    What is the difference between SQL and MYSQL?

12th Standard Computer Science English Medium - Structured Query Language (SQL) 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of the following is a standard programming language to access and manipulate database?

  • 2)

    Which of the following language was designed for managing and accessing data in RDBMS?

  • 3)

    SQL stands for

  • 4)

    SQL originally called as

  • 5)

    Latest SQL standard as of now is

12th Standard Computer Science English Medium - Structured Query Language (SQL) 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which commands provide definitions for creating table structure, deleting relations, and modifying relation schemas.

  • 2)

    Which command lets to change the structure of the table?

  • 3)

    The command to delete a table is

  • 4)

    Queries can be generated using

  • 5)

    The clause used to sort data in a database

12th Standard Computer Science English Medium - Database Concepts 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain the components of DBMS.

  • 2)

    Explain in detail about components of DBMS.

12th Standard Computer Science English Medium - Database Concepts 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain the different types of data model.

  • 2)

    Explain the different types of relationship mapping.

  • 3)

    Differentiate DBMS and RDBMS.

  • 4)

    Explain the different operators in Relational algebra with suitable examples.

  • 5)

    Explain the characteristics of DBMS.

12th Standard Computer Science English Medium - Database Concepts 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What does the term database refers?

  • 2)

    Write a note on DBMS or write a note on a software that allows us to create, define and manipulate database.

  • 3)

    Write the advantages of DBMS.

  • 4)

    List the components of DBMS

  • 5)

    Write a note on database structure.

12th Standard Computer Science English Medium - Database Concepts 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is the difference between Select and Project command?

  • 2)

    What is the role of DBA?

  • 3)

    Explain Cartesian Product with a suitable example.

  • 4)

    Explain Object Model with example.

  • 5)

    Write a note on different types of DBMS users.

12th Standard Computer Science English Medium - Database Concepts 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is database?

  • 2)

    Differentiate data and information.

  • 3)

    List the characteristics of DBMS.

  • 4)

    List the types of RDBMS software.

  • 5)

    What is E F Codd rules?

12th Standard Computer Science English Medium - Database Concepts 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Mention few examples of a database.

  • 2)

    List some examples of RDBMS.

  • 3)

    What is data consistency?

  • 4)

    What is the difference between Hierarchical and Network data model?

  • 5)

    What is normalization?

12th Standard Computer Science English Medium - Database Concepts 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of the following is an organized collection of data?

  • 2)

    Which of the following is an organized collection of data, which can be stared and a cersed through computer system

  • 3)

    Which of the following a data contain?

  • 4)

    In which of the following data organized in a way that, it can be easily accessed, managed and updated?

  • 5)

    Which of the following can be a software or hardware based, with one sole purpose of storiing data?

12th Standard Computer Science English Medium - Database Concepts 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is the acronym of DBMS?

  • 2)

    A table is known as

  • 3)

    Which database model represents parent-child relationship?

  • 4)

    Relational database model was first proposed by

  • 5)

    What type of relationship does hierarchical model represents?

12th Standard Computer Science English Medium - Python Classes and Objects 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a python program to check and print if the given number is odd or even using class.

  • 2)

    Write a program to check and print if the given number is negative or positive using class.

  • 3)

    Write a program to calculate area and circumference of a circle.

  • 4)

    Write a menu driven program that keeps record of books available in you school library.

  • 5)

    Write a program to accept a string and print the number of uppercase, lowercase, vowels, consonants and spaces in the given string.

12th Standard Computer Science English Medium - Python Classes and Objects 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a menu driven program to add or delete stationary items. You should use dictionary to store items and the brand.

12th Standard Computer Science English Medium - Python Classes and Objects 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a note on object.

  • 2)

    Write a note on self argument used in python class function.

  • 3)

    Write a python program to find total and average marks using class.

  • 4)

    Explain the working of the following program. class Sample:
    def _init_(self, num):
    print("Constructor of class Sample ...")
    self.num=num
    print("The value is :", num)
    S=Sample(10)

  • 5)

    Write the output of the following program.
    class Sample:
    num=0
    def _init_(self, var):
    Sample.num+=1
    self. var=var
    print("The object value is = ", var)
    print("The count of object created Sample.num) =",
    S1=Sample(15)
    S2=Sample(35)
    S3=Sample(45)

12th Standard Computer Science English Medium - Python Classes and Objects 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What are class members? How do you define it?

  • 2)

    Write a class with two private class variables and print the sum using a method.

  • 3)

    Find the error in the following program to get the given output?
    class Fruits:
    def __init__(self, f1, f2):
    self.f1 = f1
    self.f2 = f2
    def display(self):
    print("Fruit 1 = %s, Fruit 2 = %s" %(self.f1, self.f2))
    F = Fruits ('Apple', 'Mango')
    del F.display
    F.display()

  • 4)

    What is the output of the following program?
    class Greeting:
    def __init__(self, name):
    self.__name = name
    def display(self):
    print("Good Morning ", self.__name)
    obj=Greeting ('Bindu Madhavan')
    obj.display()

  • 5)

    How to define constructor and destructor in Python?

12th Standard Computer Science English Medium - Python Classes and Objects 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write the general form of declaring class in Python.

  • 2)

    Write the syntax for the following
    (i) Creating objects
    (ii) Accessing class members

  • 3)

    Differentiate python class function and ordinary function.

  • 4)

    Name the function which acts as a constructor and destructor.

  • 5)

    Write a program in python that illustrate the use of constructor.

12th Standard Computer Science English Medium - Python Classes and Objects 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is class?

  • 2)

    What is instantiation?

  • 3)

    What is the output of the following program?
    Class Sample:
    __num=10
    def disp(self):
    print(self.__num)
    S=Sample()
    S.disp()
    print(S.__num)

  • 4)

    How will you create constructor in Python?

  • 5)

    What is the purpose of Destructor?

12th StandardComputer Science English Medium - Python Classes and Objects 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of the following is not an object oriented language?

  • 2)

    Which of the following called as instances of a class or class variable?

  • 3)

    Functions of the class are called as

  • 4)

    In Python, every class name followed by

  • 5)

    Which of the following with a valid class definition?

12th StandardComputer Science English Medium - Python Classes and Objects 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of the following are the key features of an Object Oriented Programming language?

  • 2)

    Functions defined inside a class:

  • 3)

    Class members are accessed through which operator?

  • 4)

    Which of the following method is automatically executed when an object is created?

  • 5)

    A private class variable is prefixed with

12th StandardComputer Science English Medium - Lists, Tuples, Sets and Dictionary 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    How will access all elements of a list? Write the execution table example.

  • 2)

    How will you access elements of a list using for loop? Explain with an example.

  • 3)

    Write a program to create a list of numbers in the range 1 to 10. Then delete all the odd numbers from the list and print the final list.

  • 4)

    Explain remove (), pop () and clear () used in list with an example.

  • 5)

    Explain the detail about some important list function with an example.
    (i) copy ()
    (ii) count ()
    (iii) index ()
    (iv) reverse ()

12th StandardComputer Science English Medium - Lists, Tuples, Sets and Dictionary 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What the different ways to insert an element in a list. Explain with suitable example.

  • 2)

    What is the purpose of range( )? Explain with an example.

  • 3)

    What is nested tuple? Explain with an example.

  • 4)

    Explain the different set operations supported by python with suitable example.

12th StandardComputer Science English Medium - Lists, Tuples, Sets and Dictionary 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a program that creates a list of numbers from 1 to 20 that are divisible by 4.

  • 2)

    Write a program to swap two values using tuple assignment.

  • 3)

    How will you create a set using list or tuple? Give an example.

  • 4)

    How will you find the length of a list? Explain with an example.

  • 5)

    Fill up the following program to get the output TECM.
    list = ['T', 'E', 'C', 'M']
    i=0
    (i) while _________:
    (ii) ________ (MySubject[i], ________)
    (iii) ____ i = i + 

12th StandardComputer Science English Medium - Lists, Tuples, Sets and Dictionary 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What are the advantages of Tuples over a list?

  • 2)

    Write a shot note about sort( ).

  • 3)

    What will be the output of the following code?
    list = [2**x for x in range(5)]
    print (list)

  • 4)

    Explain the difference between del and clear( ) in dictionary with an example.

  • 5)

    List out the set operations supported by python.

12th Standard Computer Science English Medium - Lists, Tuples, Sets and Dictionary 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Name the four collections of data types in python programming language.

  • 2)

    Write the syntax of creating list. Give example.

  • 3)

    What is nested list? Give example.

  • 4)

    Fill up the following to get the output:
    10,23.41,75
    Marks = [10.23,41,75]

  • 5)

    Write a program to print all elements in the list using reverse, indexing.

12th Standard Computer Science English Medium - Lists, Tuples, Sets and Dictionary 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is List in Python?

  • 2)

    How will you access the list elements in reverse order?

  • 3)

    What will be the value of x in following python code?
    List 1 = [2, 4, 6[1, 3, 5]]
    x = len (List 1)

  • 4)

    Differentiate del with remove( ) function of List.

  • 5)

    Write the syntax of creating a Tuple with n number of elements.

12th Standard Computer Science English Medium - Lists, Tuples, Sets and Dictionary 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    How many collection of datatypes in python?

  • 2)

    Which of the following is not datatype in Python?

  • 3)

    Which of the following is an ordered collection of values?

  • 4)

    Which of the following datatype enclosed with [ ]?

  • 5)

    In list, the negative index number begin with

12th Standard Computer Science English Medium - Lists, Tuples, Sets and Dictionary 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Pick odd one in connection with collection data type

  • 2)

    Let list1=[2,4,6,8,10], then print(List1[-2]) will result in

  • 3)

    Which of the following function is used to count the number of elements in a list?

  • 4)

    If List=[10,20,30,40,50] then List[2]=35 will result

  • 5)

    If List=[17,23,41,10] then List.append(32) will result

12th Standard Computer Science English Medium - Strings and String Manipulations 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a python program to check whether the given string is palindrome or not.

  • 2)

    Write a python program to print the following pattern
    *
    **
    ***
    ****
    *****

  • 3)

    Write a python program to display the number of vowels and consonants in the given string.

  • 4)

    Explain how will you create and access characters in a string with an example?

  • 5)

    Explain in detail about modification and deletion of a string with an example.

12th Standard Computer Science English Medium - Strings and String Manipulations 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain about string operators in python with suitable example.

12th Standard Computer Science English Medium - Strings and String Manipulations 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    How the positive and negative subscript values are assigned? Give example.

  • 2)

    Write a program to accept a string and print it in reverse order.

  • 3)

    Write the syntax and example of using string characters.

  • 4)

    Write the usage of the following format string characters.
    (i) % c
    (ii) % d (or) % i
    (iii) % s

  • 5)

    Fill in the blanks.

      Format character Usage
    i) ________ Unsigned decimal integer
    ii) %0 _______
    iii) _______ Hexadecimal integer
    iv) %i _______

12th Standard Computer Science English Medium - Strings and String Manipulations 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a Python program to display the given pattern
    C O M P U T E R
    C O M P U T E
    C O M P U T
    C O M P U
    C O M P
    C O M
    C O
    C

  • 2)

    Write a short about the followings with suitable example:
    (a) capitalize( )
    (b) swapcase( )

  • 3)

    What will be the output of the given python program?
    str1 = "welcome"
    str2 = "to school"
    str3 = str1[:2] + str2[len(str2)-2:]
    print (str3)

  • 4)

    What is the use of format( )? Give an example.

  • 5)

    Write a note about count( ) function in python.

12th Standard Computer Science English Medium - Strings and String Manipulations 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    How will you manipulate the strings?

  • 2)

    What it means "String in phython are immutable"?

  • 3)

    Write a python a program to print your name 10 times.

  • 4)

    Write the output for the following if strl = "THIRIKKURAL"
    (i) print (strl [0])
    (ii) print (strl [0:5])
    (ill) print (strl [:5])
    (iv) Print (strl [6:])

  • 5)

    Write the general format of slice operation.

12th Standard Computer Science English Medium - Strings and String Manipulations 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is String?

  • 2)

    Do you modify a string in Python?

  • 3)

    How will you delete a string in Python?

  • 4)

    What will be the output of the following python code?
    str1 = “School”
    print(str1*3)

  • 5)

    What is slicing?

12th Standard Computer Science English Medium - Strings and String Manipulations 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of the following is used to handle array of characters in python?

  • 2)

    String are enclosed with

  • 3)

    Which of the following allows creation of multiline strings

  • 4)

    Find the output for the following print ('Greater Chennai cooperation's student')

  • 5)

    String index values are also called as

12th Standard Computer Science English Medium - Strings and String Manipulations 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of the following is the output of the following python code?
    str1="TamilNadu"
    print(str1[::-1])

  • 2)

    What will be the output of the following code?
    str1 = "Chennai Schools"
    str1[7] = "-"

  • 3)

    Which of the following operator is used for concatenation?

  • 4)

    Defining strings within triple quotes allows creating:

  • 5)

    Strings in python:

12th Standard Computer Science English Medium - Python Functions 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain different types arguments used in python with an example.

  • 2)

    Write a python program to find HCF of two numbers using recursion.

  • 3)

    Write a python program to find Fibonacci series of n terms using recursion.

  • 4)

    Explain how you will call a function and passing a parameters in function?

  • 5)

    Explain in detail about various functional arguments with its example.

12th Standard Computer Science English Medium - Python Functions 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain the different types of function with an example.

  • 2)

    Explain the scope of variables with an example.

  • 3)

    Explain the following built-in functions.
    (a) id ()
    (b) chr ()
    (c) round ()
    (d) type ()
    (e) pow ()

  • 4)

    Write a Python code to find the L.C.M. of two numbers.

  • 5)

    Explain recursive function with an example.

12th Standard Computer Science English Medium - Python Functions 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    When do you call the function to perform a specify task?

  • 2)

    Write the advantages of user-defined functions.

  • 3)

    Write a note on "Required arguments".

  • 4)

    How will you invoke the function after, the parameters are recognized by their parameter names? Explain with an example.

  • 5)

    How python takes a default value in the function call? Explain with an example.

12th Standard Computer Science English Medium - Python Functions 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write the rules of local variable.

  • 2)

    Write the basic rules for global keyword in python.

  • 3)

    What happens when we modify global variable inside the function?

  • 4)

    Differentiate ceil() and floor() function?

  • 5)

    Write a Python code to check whether a given year is leap year or not.

12th Standard Computer Science English Medium - Python Functions 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    How the statements in a black are written in python?

  • 2)

    What is meant by block in python?

  • 3)

    How the nested block are indented?

  • 4)

    Write the output of the following program.

  • 5)

    Differentiate parameters and arguments.

12th Standard Computer Science English Medium - Python Functions 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is function?

  • 2)

    Write the different types of function.

  • 3)

    What are the main advantages of function?

  • 4)

    What is meant by scope of variable? Mention its types.

  • 5)

    Define global scope.

12th Standard Computer Science English Medium - Python Functions 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of the following is used, if you don't need to type all the python code for the same task again and again:

  • 2)

    Which of the following avoids repetition and makes high degree of code reusing?

  • 3)

    Which of the following provides better modularity for your python application

  • 4)

    How many types of functions are there in python?

  • 5)

    Functions that calls itself are known as

12th Standard Computer Science English Medium - Python Functions 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    A named blocks of code that are designed to do one specific job is called as

  • 2)

    A Function which calls itself is called as

  • 3)

    Which of the following keyword is used to begin the function block?

  • 4)

    Which function is called anonymous un-named function

  • 5)

    Which of the following keyword is used to exit a function block?

12th Standard Computer Science English Medium - Control Structures 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain Jump statement in python.

  • 2)

    Write a program in python to display the following output.
    1
    1 2
    1 2 3
    1 2 3 4
    1 2 3 4 5

  • 3)

    Write a program in python to display he following output.
    1
    2 2
    3 3 3
    4 4 4 4
    5 5 5 5 5

  • 4)

    Write a program in python to display the following output.
    (i) 5 5 5 5 5
    4 4 4 4
    3 3 3
    2 2
    1
    (ii) 1 2 3 4 5
    1 2 3 4
    1 2 3
    1 2
    1

  • 5)

    Explain briefly about the alternative statement with its syntax and flowchart.

12th Standard Computer Science English Medium - Control Structures 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a detail note on for loop.

  • 2)

    Write a detail note on if..else..elif statement with suitable example.

  • 3)

    Write a program to display all 3 digit odd numbers.

  • 4)

    Write a program to display multiplication table for a given number.

12th Standard Computer Science English Medium - Control Structures 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a note on sequential statement with an example.

  • 2)

    List the types of alternative or branching statement in python.

  • 3)

    Write a note on simple if statement with an example.

  • 4)

    Write a python program to print all numbers from 10 to 15 using while loop.

  • 5)

    Draw a flowchart that illustrates the working of while loop.

12th Standard Computer Science English Medium - Control Structures 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write a program to display
    A
    A B
    A B C
    A B C D
    A B C D E

  • 2)

    Write note on if..else structure.

  • 3)

    Using if..else..elif statement write a suitable programs to display largest of 3 numbers.

  • 4)

    Write the syntax of while loop.

  • 5)

    List the differences between break and continue statements.

12th Standard Computer Science English Medium - Control Structures 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What is meant by alternative or branching?

  • 2)

    Draw a flow chart that defines the execution of if-else statement.

  • 3)

    Write a program in python to check if the accepted number even or odd.
    a = int(input("Enter any number:"))
    if a%2==0:
    print (a, "is an even number")
    else:
    print (a, "is an odd number")

  • 4)

    Write the syntax of alternative method to write complete if-else.

  • 5)

    Write a program in python to check if the accepted number us even or odd (use alternate method of if-else).

12th Standard Computer Science English Medium - Control Structures 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    List the control structures in Python.

  • 2)

    Write note on break statement.

  • 3)

    Write is the syntax of if..else statement.

  • 4)

    Define control structure.

  • 5)

    Write note on range () in loop.

12th Standard Computer Science English Medium - Control Structures 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Which of the following are the executable segments that yield the result?

  • 2)

    Find the odd man out.

  • 3)

    Find the odd man out

  • 4)

    Which of the following is used to alter the control flow of the process depending on the state of the process?

  • 5)

    How many important control structures in python?

12th Standard Computer Science English Medium - Control Structures 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    How many important control structures are there in Python?

  • 2)

    elif can be considered to be abbreviation of

  • 3)

    What plays a vital role in Python programming?

  • 4)

    Which statement is generally used as a placeholder?

  • 5)

    The condition in the if statement should be in the form of

12th Standard Computer Science English Medium - Python - Variables and Operators 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write the output for the following python code..
    x=10
    x+=20
    print ("The x + = 20 is =",x)
    x-=5
    print ("The x -= 5 is = ",x)
    x*=5
    print ("The x *= 5 is = ",x)
    x/=2
    print ("The x/ = 2 is = ",x)
    x%=3
    print ("The x %= 3 is = ",x)
    x**=2
    print ("The x **= 2 is = ",X)
    x//=3
    print ("The x//= 3 is = ",x)

  • 2)

    Explain briefly about Python data types with an example.

12th Standard Computer Science English Medium - Python - Variables and Operators 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Describe in detail the procedure Script mode programming.

  • 2)

    Explain input() and print() functions with examples.

  • 3)

    Discuss in detail about Tokens in Python.

12th Standard Computer Science English Medium - Python - Variables and Operators 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write the key features of Python.

  • 2)

    Differentiate two ways in which Python programs can be written.

  • 3)

    Write the function of the following
    (i) Ctrl + N
    (ii) Ctrl + S
    (iii) F5

  • 4)

    Fill in the blanks.
    >>> city = \(\overset { (1) }{ \_ \_ \_ \_ \_ } \) ("Enter your City")
    Enter your city \(\overset { (2) }{ \_ \_ \_ \_ \_ } \)
    >>> print ("I am from", \(\overset { (3) }{ \_ \_ \_ \_ \_ } \))
    I am from Chennai

  • 5)

    Fill up the blanks to get the following output from Python code given.
    Output:
    Enter Number 1: 34
    Enter Number 2: 70
    The Sum = 104
    Code:
    X = \(\overset { (1) }{ \_ \_ \_ \_ \_ } \) (input ("Enter Number 1:"))
    Y = \(\overset { (2) }{ \_ \_ \_ \_ \_ } \) (\(\overset { (3) }{ \_ \_ \_ \_ \_ } \) ("Enter Number 2 :"))
    \(\overset { (4) }{ \_ \_ \_ \_ \_ } \) ("The sum =", \(\overset { (5) }{ \_ \_ \_ \_ \_ } \))

12th Standard Computer Science English Medium - Python - Variables and Operators 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Write short notes on Arithmetic operator with examples.

  • 2)

    What are the assignment operators that can be used in Python?

  • 3)

    Explain Ternary operator with examples.

  • 4)

    Write short notes on Escape sequences with examples.

  • 5)

    What are string literals? Explain.

12th Standard Computer Science English Medium - Python - Variables and Operators 2 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    How will you develop and run Python code?

  • 2)

    How many ways the Python shell can be used?

  • 3)

    How the interactive mode of Python shell can be used as simple calculator?

  • 4)

    How will you invoke python IDLE?

  • 5)

    How will you know the python IDLE working in interactive mode?

12th Standard Computer Science English Medium - Python - Variables and Operators 2 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    What are the different modes that can be used to test Python Program?

  • 2)

    Write short notes on Tokens.

  • 3)

    What are the different operators that can be used in Python?

  • 4)

    What is a literal? Explain the types of literals?

  • 5)

    Write short notes on Exponent data?

12th Standard Computer Science English Medium - Python - Variables and Operators 1 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Python language was released in

  • 2)

    IDLE expansion is

  • 3)

    In Python, How many ways programs can be written?

  • 4)

    In Python, the script mode programs can be stored with the extension.

  • 5)

    Which of the following mode cannot be written Python program?
    (i) Interactive mode
    (ii) Script mode
    (iii) Calculator mode
    (iv) Executable mode

12th Standard Computer Science English Medium - Python - Variables and Operators 1 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Who developed Python?

  • 2)

    The Python prompt indicates that Interpreter is ready to accept instruction.

  • 3)

    Which of the following shortcut is used to create new Python Program?

  • 4)

    Which of the following character is used to give comments in Python Program?

  • 5)

    This symbol is used to print more than one item on a single line.

12th Standard Computer Science English Medium - Algorithmic Strategies 5 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain Best, worst and Average case efficiency of an algorithm with an example.

  • 2)

    Explain complexity of an algorithm.

  • 3)

    Define efficiency of an algorithm? How the efficiency of an algorithm was determined?

  • 4)

    Differentiate Algorithm and program

  • 5)

    Explain the selection sort Algorithm with an example.

12th Standard Computer Science English Medium - Algorithmic Strategies 5 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    Explain the characteristics of an algorithm.

  • 2)

    Discuss about Linear search algorithm.

  • 3)

    What is Binary search? Discuss with example

  • 4)

    Explain the Bubble sort algorithm with example.

  • 5)

    Explain the concept of Dynamic programming with suitable example.

12th Standard Computer Science English Medium - Algorithmic Strategies 3 Mark Creative Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    List the manipulation manipulated effectively through data structures by algorithm.

  • 2)

    Design an algorithm to find square of the given number and display the result.

  • 3)

    Write a note on time/space trade off

  • 4)

    Write a note on two factors in which space required by an algorithm is decided.

  • 5)

    Write the different factors in which the time efficiency of an algorithm its measured

12th Standard Computer Science English Medium - Algorithmic Strategies 3 Mark Book Back Question Paper and Answer Key 2022 - 2023 - by Study Materials - View & Read

  • 1)

    List the characteristics of an algorithm.

  • 2)

    Discuss about Algorithmic complexity and its types.

  • 3)

    What are the factors that influence time and space complexity.

  • 4)

    Write a note on Asymptotic notation.

  • 5)

    What do you understand by Dynamic programming?

View all

TN Stateboard Education Study Materials

TN Stateboard Updated Class 12th Computer Science Syllabus

Function

Introduction - Function with respect to Programming language - Interface vs Implementation - Pure functions

Data Abstraction

Data Abstraction - Introduction - Abstract Data Types - Constructors and Selectors - Representation of Abstract datatype using Rational numbers - Lists, Tuples - Data Abstraction in Structure

Scoping

Introduction - Variable Scope - LEGB rule - Types of Variable Scope - Module

Algorithmic Strategies

Introduction to Algorithmic strategies - Complexity of an Algorithm - Efficiency of an algorithm - Algorithm for Searching Techniques - Sorting Techniques - Dynamic programming

Python -Variables and Operators

Introduction - Key features of Python - Programming in Python - Input and Output Functions - Comments in Python - Indentation - Tokens - Python Data types

Control Structures

Introduction - Control Structures

Python functions

Introduction - Defining Functions - Calling a Function - Passing Parameters in Functions - Function Arguments - Anonymous Functions - The return Statement - Scope of Variables - Functions using libraries - Python recursive functions

Strings and String manipulations

Introduction - Creating Strings - Accessing characters in a String - Modifying and Deleting Strings - String Operators - String Formatting Operators - Formatting characters - The format( ) function - Built-in String functions - Membership Operators

Lists, Tuples, Sets and Dictionary

Introduction to List - Tuples - Sets - Dictionaries

Python Classes and objects

Introduction - Defining classes - Creating Objects - AccessingClass Members - Class Methods - Constructor and Destructor in Python - Public and Private Data Members

Database Concepts

Data - Information - Database - Database Management System (DBMS) - Database Structure - Data Model - Difference between DBMS and RDBMS - Types of Relationships - Relational Algebra in DBMS

Structured Query Language (SQL)

Introduction to SQL - Role of SQL in RDBMS - Processing Skills of SQL - Creating Database - Components of SQL - Data Types - SQL Commands and their Functions

Python and CSV files

Introduction - Difference between CSV and XLS file formats - Purpose of CSV File - Creating a CSV file using Notepad (or any text editor - Create a CSV File using Microsoft Excel - Read and Write a CSV file using Python - Writing Data into Different Types in CSV Files

Importing C++ programs in Python

Introduction - Scripting Language - Applications of Scripting Languages - Features of Python over C++ - Importing C++ Files in Python - Python Program to import C++ - Python program Executing C++ Program using control statement - How Python is handling the errors in C++ - Python program Executing C++ Program Containing Arrays - Python program Executing C++ Program Containing Functions - Python program to illustrate the inheritance of a Class

Data manipulation through SQL

Introduction - SQLite - Creating a Database using SQLite - SQL Query Using Python - The SQL AND, OR and NOT Operators - Querying A Date Column - Aggregate Functions - Updating A Record - Deletion Operation - Data input by User - Using Multiple Table for Querying - Integrating Query With CSV File - Table List

Data visualization using pyplot: line chart, pie chart and bar chart

Data Visualization Definition - Getting Started - Special Plot Types

TN StateboardStudy Material - Sample Question Papers with Solutions for Class 12 Session 2020 - 2021

Latest Sample Question Papers & Study Material for class 12 session 2020 - 2021 for Subjects Maths, Chemistry, Physics, Biology, Business Maths, Economics, Commerce, Accountancy, History, Computer Applications, Computer Technology, English, உயிரியல், கணினி பயன்பாடுகள், கணினி அறிவியல், வணிகக் கணிதம், வணிகவியல், பொருளியல், கணிதவியல், வேதியியல், இயற்பியல், கணினி தொழில்நுட்பம், வரலாறு, கணக்குப்பதிவியல், தமிழ் in PDF form to free download [ available question papers ] for practice. Download QB365 Free Mobile app & get practice question papers.

More than 1000+ TN Stateboard Syllabus Sample Question Papers & Study Material are based on actual Board question papers which help students to get an idea about the type of questions that will be asked in Class 12 Final Board Public examinations. All the Sample Papers are adhere to TN Stateboard guidelines and its marking scheme , Question Papers & Study Material are prepared and posted by our faculty experts , teachers , tuition teachers from various schools in Tamilnadu.

Hello Students, if you like our sample question papers & study materials , please share these with your friends and classmates.

Related Tags