Python and CSV files Practice Test — Class 12 Computer Science

12th Standard Computer Science — Python and CSV files: Online Practice Test

Pick how many questions you want and set a time limit, then start. You'll get your score at the end with the correct answer and an explanation for every question. Free, in Tamil and English — 25 questions available.

Set up your test

Number of questions

Time limit

Time remaining00:00

A CSV file is also known as a ....

A.Flat File B.3D File C.String File D.Random File

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

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

A.py B.xls C.csv D.os

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

A.Text mode B.Binary mode C.xls mode D.csv mode

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

A.next() B.skip() C.omit() D.bounce()

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

What is the output of the following program? import csv d=csv.reader(open('c:\\PYPRG\\ch13\\city.csv')) next(d) for row in d: print(row) if the file called 'city.csv' contains the following details: chennai,mylapore mumbai,andheri

A.['chennai', 'mylapore'] B.['mumbai', 'andheri'] C.['chennai'] D.['chennai', 'mylapore', 'mumbai', 'andheri']

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

A.listreader() B.reader() C.tuplereader() D.DictReader()

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

A.Editing B.Appending C.Modification D.Alteration

Q10

What will be written inside the file test.csv using the following program? import csv D = [['Exam'],['Quarterly'],['Halfyearly']] csv.register_dialect('M',lineterminator = '\n') with open('c:\\pyprg\\ch13\\line2.csv', 'w') as f: wr = csv.writer(f,dialect='M') wr.writerows(D) f.close()

A.Exam Quarterly Halfyearly B.Exam Quarterly Halfyearly C.Exam, Quarterly, Halfyearly D.Exam Quarterly Halfyearly on a single line

Q11

Which of the following file extensions is used for saving a Comma-Separated Values file?

A..xls B..xlsx C..csv D..txt

Q12

What is another name commonly used to refer to a CSV file because of its plain, tabular structure?

A.Binary File B.Flat File C.Relational File D.Rich Text File

Q13

If a specific field in a CSV file contains a comma as part of its actual data, how should that field be formatted?

A.Enclosed in single quotes B.Enclosed in double-quotes C.Preceded by a backslash D.Separated by semicolons

Q14

When field data in a CSV file contains double-quotes as part of its actual value, how is it represented under standard formatting rules?

A.Enclosed in single quotes B.Doubled, and the entire field is enclosed in double-quotes C.Replaced with single quotes D.Preceded by a slash symbol

Q15

Which Python module provides the built-in library functions to parse and process CSV files?

A.sys B.os C.csv D.excel

Q16

What is the default file opening mode when using the built-in open() function in Python?

A.'w' B.'a' C.'rt' D.'rb'

Q17

Which block statement is recommended to open files in Python to ensure they are automatically closed even if an exception occurs?

A.with B.open C.try...except D.import

Q18

Which method of the csv.writer class is used to write a single row of data into a CSV file?

A.writerow() B.writerows() C.write() D.writeline()

Q19

Which class of the Python csv module reads a CSV file and maps its data rows to dictionaries instead of lists?

A.csv.reader B.csv.DictReader C.csv.DictWriter D.csv.writer

Q20

What subclass of dictionary does the csv.DictReader class return by default for each row it iterates over in Python?

A.list B.tuple C.OrderedDict D.set

Q21

How can the default OrderedDict returned by csv.DictReader be converted into a standard Python dictionary?

A.Using the list() function B.Using the dict() function C.Using the tuple() function D.Using the set() function

Q22

Which formatting parameter of csv.register_dialect() is set to True to remove whitespaces immediately following a delimiter?

A.skipinitialspace B.quoting C.escapechar D.doublequote

Q23

Which built-in Python function can be used to skip the header row of a CSV file before sorting or processing its data rows?

A.skip() B.next() C.pop() D.advance()

Q24

To sort a CSV file based on multiple columns, which operator function is passed as a key in the sorted() function?

A.operator.sortby() B.operator.itemgetter() C.operator.getter() D.operator.field()

Q25

Which of the following line terminators are accepted by Python's CSV module for terminating rows?

A.Only \n B.Only \r\n C.\r\n, \n, or \r D.Any custom string including tab characters

More for this chapter

About this Python and CSV files test

This free online practice test covers Python and CSV files from the 12th Standard Computer Science (Samacheer Kalvi) syllabus. Choose the number of questions and an optional time limit, then answer and submit — everything is checked in your browser, with the correct answers and a worked explanation shown at the end. For the full solutions to every question in this set, see the solved MCQs page.

More chapters in Computer Science

View all