New ! Computer Science MCQ Practise Tests



12th Standard Computer Science English Medium Reduced Syllabus Important Questions with Answer key - 2021 Part - 1

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

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

      Multiple Choice Questions

    20 x 1 = 20
  1. The functions which cause side effects to the arguments passed are called

    (a)

    impure function

    (b)

    Partial Functions

    (c)

    Dynamic Functions

    (d)

    Pure functions

  2. A sequence of immutable objects is called

    (a)

    Built in

    (b)

    List

    (c)

    Tuple

    (d)

    Derived data

  3. Which of the following allow to name the various parts of a multi-item object?

    (a)

    Tuples

    (b)

    Lists

    (c)

    Classes

    (d)

    quadrats

  4. Which of the following is constructed by placing expressions within square brackets?

    (a)

    Tuples

    (b)

    Lists

    (c)

    Classes

    (d)

    quadrats

  5. Which of the following provides modularity?

    (a)

    Datatypes

    (b)

    Subroutines

    (c)

    Classes

    (d)

    Abstraction

  6. ________are the representation for Abstract Data types.

    (a)

    Objects

    (b)

    Classes

    (c)

    Functions

    (d)

    Lists

  7. Containers for mapping names of variables to objects is called

    (a)

    Scope

    (b)

    Mapping

    (c)

    Binding

    (d)

    Namespaces

  8. How the names are mapped with objects in programming language?

    (a)

    name == object

    (b)

    name:: object

    (c)

    name:= object

    (d)

    object:= name

  9. Which of the following is an example of data structures?

    (a)

    List

    (b)

    Tuple

    (c)

    Dictionary

    (d)

    All of these.

  10. A _________ in Python is known as a "sequence datatype"

    (a)

    List

    (b)

    Set

    (c)

    Dictionary

    (d)

    Tuples

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

    (a)

    Constructor and Classes

    (b)

    Constructor and Object

    (c)

    Classes and Objects

    (d)

    Constructor and Destructor

  12. Which of the following is valid syntax for crating objects?

    (a)

    objectname = classname ()

    (b)

    objectname: classname ()

    (c)

    objectname = classname

    (d)

    classname = Objectname ()

  13. ______ and_____ are the key features of object oriented programming.

    (a)

    List and tuples

    (b)

    Set and dictionary

    (c)

    Classes and objects

    (d)

    Variables and methods

  14. The process of creating object is called as ___________

    (a)

    Class definition

    (b)

    Class declaration

    (c)

    Class instantiation

    (d)

    Class objects

  15. Which of the following provided an interface to perform various operations to create a database, storing and updating data?

    (a)

    SQL

    (b)

    DBA

    (c)

    DBMS

    (d)

    Algebra

  16. The basic structure of data in relational model is

    (a)

    Tables

    (b)

    rows

    (c)

    columns

    (d)

    tuples

  17. Object model stores the data in the form of

    (a)

    objects

    (b)

    attributes and methods

    (c)

    classes and inheritance

    (d)

    all of these

  18. In ____________ data model, the data stores in the form of classes and inheritance.

    (a)

    Hierarchical

    (b)

    Entity relationship

    (c)

    Object

    (d)

    Network

  19. The data in RDBMS, is stored in database objects called

    (a)

    Queries

    (b)

    Languages

    (c)

    Relations

    (d)

    Tables

  20. Which of the following is way to read a CSV file?

    (a)

    read ()

    (b)

    reader ()

    (c)

    dictreader ()

    (d)

    b and c

    1. 2 Marks

    16 x 2 = 32
  21. Name the built - in number objects in python.

  22. Write a python program to generate the squares of even numbers between 1 and 10 using the concept of list comprehensions.

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

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

  25. What is the difference between SQL and MYSQL?

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

  27. What is SQL?

  28. Write the syntax of creating table in database.

  29. What is CSV File?

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

  31. Why CSV file is known as flat file?

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

  33. What is a cursor in SQL and databases?

  34. Write the placeholders which supported by SQlite3 module Execute.

  35. How the SQL DISTINCT class is helpful to you?

  36. List the types of Visualizations in Matplotlib.

    1. 3 Marks

    16 x 3 = 48
  37. Differentiate Concrete data type and abstract datatype.

  38. Write a note on Data Abstraction.

  39. List the manipulation manipulated effectively through data structures by algorithm.

  40. How will you represent Octal, hexadecimal and long integer data?

  41. Identity which is a DBMS and RDBMS software from the following.
    (i) SQlite
    (ii) Foxpro
    (iii) MySQL
    (iv) Dbase

  42. Write the importance of using data model.

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

  44. Write a SQL statement using DISTINCT keyword.

  45. List the data types used in SQL.

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

  47. What is SQLite?What is it advantage?

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

  49. Write the sqlite steps to connect the database.

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

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

  52. Write a python code to display the following plot.

    1. 5 Marks

    13 x 5 = 65
  53. Explain the representation of Abstract datatype using rational numbers.

  54. Explain the different types of data model.

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

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

  57. Write the processing skills of SQL.

  58. Differentiate Excel file and CSV file.

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

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

  61. Write a program to set data at runtime and writing it in a CSV file.

  62. 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
  63. Explain in detail the types of pyplots using Matplotlib.

  64. Explain the various buttons in a matplotlib window.

  65. Write a python code to display the following, plot.

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

Reviews & Comments about 12th Standard Computer Science English Medium Reduced Syllabus Important Questions with Answer key - 2021 Part - 1

Write your Comment