New ! Computer Science MCQ Practise Tests

12th Standard Computer Science English Medium Reduced Syllabus Model Question paper With Answer Key- 2021 Part -2

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 02:45:00 Hrs
Total Marks : 100

        Part I

        Answer all the questions.

        Choose the most suitable answer from the given four alternatives and write the option code with the corresponding answer.

    15 x 1 = 15
  1. Which of the following provides modularity?

    (a)

    Datatypes

    (b)

    Subroutines

    (c)

    Classes

    (d)

    Abstraction

  2. Which of the following are functions that build the abstract datatypet?

    (a)

    Constructors

    (b)

    Destructors

    (c)

    Selectors

    (d)

    All of these

  3. ________are the representation for Abstract Data types.

    (a)

    Objects

    (b)

    Classes

    (c)

    Functions

    (d)

    Lists

  4. ___________is a selective restriction of access to data in a program?

    (a)

    Control variable

    (b)

    System authentication

    (c)

    Access control

    (d)

    Module

  5. How many components required to find the space required by an algorithm?

    (a)

    4

    (b)

    3

    (c)

    6

    (d)

    2

  6. Pick odd one in connection with collection data type

    (a)

    List

    (b)

    Tuple

    (c)

    Dictionary

    (d)

    Loop

  7. What is the use of type() function in python?

    (a)

    To create a Tuple

    (b)

    To know the type of an element in tuple.

    (c)

    To know the data type of python object

    (d)

    To create a list.

  8. Which of the following DBMS components controls everything in a database?

    (a)

    Hardware

    (b)

    Square

    (c)

    Methods

    (d)

    Procedures

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

  10. Which of the following creates an object which maps data to a dictionary?

    (a)

    listreader()

    (b)

    reader()

    (c)

    tuplereader()

    (d)

    DicReader ()

  11. Making some changes in the data of the existing file or adding more data is called

    (a)

    Editing

    (b)

    Appending

    (c)

    Modification

    (d)

    Alteration

  12. Which of the following is not a scripting language?

    (a)

    JavaScript

    (b)

    PHP

    (c)

    Perl

    (d)

    HTML

  13. Which is a programming language designed for integrating and communicating with other programming languages?

    (a)

    Modular language

    (b)

    Procedural language

    (c)

    Scripting language

    (d)

    Procedural language

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

    (a)

    List installed packages

    (b)

    list command

    (c)

    Install PIP

    (d)

    packages installed

  15. Identify the right type of chart using the following hints.
    Hint 1: This chart is often used to visualize a trend in data over intervals of time.
    Hint 2: The line in this type of chart is often drawn chronologically.

    (a)

    Line chart

    (b)

    Bar chart

    (c)

    Pie chart

    (d)

    Scatter plot

    1. Part II

      Answer all the questions. Question no. 21 is compulsory.


    6 x 2 = 12
  16. Name the four collections of data types in python programming language.

  17. Differentiate data and itiformation.

  18. Write a note on data query language.

  19. How will assign a default value for the table field in a data base?

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

  21. List some scripting language

    1. Part III

      Answer all the  questions. Question no. 23 is compulsory.


    6 x 3 = 18
  22. List the components of DBMS

  23. Write the different categories of SQL commands.

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

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

  26. What is SQLite?What is it advantage?

  27. List the classes used in the SQL SELECT statement.

    1. Part IV

      Answer all the questions.


    5 x 5 = 25
  28. 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.

  29. Write the processing skills of SQL.

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

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

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

*****************************************

TN 12th Standard Computer Science free Online practice tests

Reviews & Comments about 12th Standard Computer Science English Medium Reduced Syllabus Model Question paper With Answer Key- 2021 Part -2

Write your Comment