New ! Computer Science MCQ Practise Tests



12th Standard Computer Science English Medium Python and CSV Files Reduced Syllabus Important Questions With Answer Key 2021

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:00:00 Hrs
Total Marks : 100

      Multiple Choice Questions


    15 x 1 = 15
  1. The expansion of CRLF is

    (a)

    Control Return and Line Feed

    (b)

    Carriage Return and Form Feed

    (c)

    Control Router and Line Feed

    (d)

    Carriage Return and Line Feed

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

    (a)

    listreader()

    (b)

    reader()

    (c)

    tuplereader()

    (d)

    DictReader ()

  3. Which of the following gives the python programmer the ability to parse CSV files?

    (a)

    CSV data

    (b)

    CSV module

    (c)

    CSV sheet

    (d)

    CSV flat file

  4. Fields containing line breaks denoted by

    (a)

    CSV

    (b)

    XLS

    (c)

    CLRF

    (d)

    CRLF

  5. In Excel, the default CSV files should open automatically by

    (a)

    Single click

    (b)

    Right click

    (c)

    Double click

    (d)

    None of these

  6. How many ways to read a CSV file?

    (a)

    2

    (b)

    3

    (c)

    4

    (d)

    Only one

  7. Which of the following is not a mode used while opening a file?

    (a)

    P

    (b)

    W

    (c)

    r

    (d)

    a

  8. CSV file can be opened in

    (a)

    Text mode

    (b)

    Binary mode

    (c)

    Application mode

    (d)

    a or b

  9. How many rows at a time the writerrow( ) method writes in a CSV file?

    (a)

    1

    (b)

    2

    (c)

    3

    (d)

    many

  10. Which method is used to write all the data at once?

    (a)

    write

    (b)

    writer ( )

    (c)

    writerow ( )

    (d)

    allrow ( )

  11. Which method will free up the resources that were tied with the file?

    (a)

    free ( )

    (b)

    open ( )

    (c)

    resources ( )

    (d)

    close ( )

  12. ________ provides a module named CSV using this several operations on the CSV file can be done.

    (a)

    Ms-Exeel

    (b)

    Python

    (c)

    Text editor

    (d)

    Open offiee calc

  13. __________ has a garbage collector to clean up unreferenced objects.

    (a)

    CSV

    (b)

    Excel

    (c)

    Python

    (d)

    Open office

  14. A ________ is a string used to terminate lines produced by writer ( )

    (a)

    Line

    (b)

    Custom Delimiters

    (c)

    Line Terminator

    (d)

    Quotes

  15. python's CSV module only accepts ________ as line terminator.

    (a)

    \r

    (b)

    \n

    (c)

    \a

    (d)

    \r or \n

    1. 2 Marks


    10 x 2 = 20
  16. What is CSV File?

  17. What is use of next() function?

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

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

  20. How the CSV file operation takes place in python?

  21. What is the use of close ( ) method?

  22. Whatis dialect ?

  23. How will you read CSV file into a dictionary?

  24. What is an Ordered Dict?

  25. Write is purpose of using skipinitialspace parameter.

    1. 3 Marks


    10 x 3 = 30
  26. Write a note on open() function of python. What is the difference between the two methods?

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

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

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

  30. How will you create CSV normal file?

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

  32. Write the syntax of reader( ).

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

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

  35. Write a program to create a new normal CSV file to store data.

    1. 5 Marks


    7 x 5 = 35
  36. Write a program to read the CSV file through python using reader ( ) method.

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

  38. Write a program to read the CSV file and store A column value in A list for sorting.

  39. How will you sort more than one column in a CSV file? Explain with an example.

  40. Write a program to read CSV file with a line Terminator.

  41. How will you write Dictionary into CSV file with custom dialects?

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

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

Reviews & Comments about 12th Standard Computer Science English Medium Python and CSV Files Reduced Syllabus Important Questions With Answer Key 2021

Write your Comment