2nd puc computer science fill in the blanks with answers | 2nd puc computer science fill in the blanks

2nd puc computer science fill in the blanks with answers,2nd puc computer science fill in the blanks,2nd puc computer science database concepts fill in the blanks,2nd puc computer science fill in the blanks 2023,2nd puc computer science fill in the blanks with answers pdf,2nd puc computer science fill in the blanks pdf download,2nd puc computer science fill in the blanks question bank,2nd puc computer science fill in the blanks pdf,2nd puc fill in the blanks

Chapter 2 

File Handling in Python 

FILL IN THE BLANKS WITH APPROPRIATE WORDS GIVEN IN THE BRACKET

1. Secondary storage media are used to permanently store data for later access in ____

ANSWER= Solid State Drive

2. A file is a named location on ________ storage media where data is permanently stored.

ANSWER= Secondary

3. A text file consists of __________ readable characters.

ANSWER= human

4. Text files store data using bytes for ________ schemes.

ANSWER= ASCII

5. The system frees the memory allocated to it using the _______ method.

ANSWER= close()



FILL IN THE BLANKS WITH APPROPRIATE WORDS GIVEN IN THE BRACKET

1. The ________ method is used to read a specified number of bytes of data from a data file.

ANSWER= read())

2. The _________ method reads all the lines and returns the lines along with newline character as a list of strings.

ANSWER= readlines()

3. The ________ method reads one complete line from a file.

ANSWER= readline()

4. Each program is stored on the secondary device as a ____________

ANSWER= file

5. Each line of a text file is terminated by a special character, called _________ .

ANSWER= End of Line (EOL)



FILL IN THE BLANKS WITH APPROPRIATE WORDS GIVEN IN THE BRACKET

1. The ________ method writes a single string to a file.

ANSWER= write

2. The ________ method writes multiple strings to a file.

ANSWER= writelines

3. The default End of line character is python is _________

ANSWER= \n

4. The Python function used to open a file for writing data is _________.

ANSWER= open()

5. The write() method is used to write a __________ to a file in Python.

ANSWER= string



FILL IN THE BLANKS WITH APPROPRIATE WORDS GIVEN IN THE BRACKET

1. The writelines() method is used to write __________ strings to a file

ANSWER= multiple

2. To serialize and deserialize Python objects is used __________ module.

ANSWER= pickle

3. To convert (pickle) Python objects for writing data to a binary file, the ______ method is used.

ANSWER= dump()

4. To load (unpickling) data from a binary file, the __________ method is used

ANSWER= load()

5. The _________ method is used to return the current position of the file pointer in Python.

ANSWER= tell()



FILL IN THE BLANKS WITH APPROPRIATE WORDS GIVEN IN THE BRACKET

1. The ________ method is used to position the file object at a particular position in a file.

ANSWER= seek()

2. To create a text file, we use the ________ method.

ANSWER= open()

3. To clear the buffer and write the contents to the file, we use the method __________

ANSWER= flush()

Chapter 9 

Structured Query Language (SQL) 

FILL IN THE BLANKS WITH APPROPRIATE WORDS GIVEN IN THE BRACKET

1. A _______ is a collection of related tables used to store and manage data.

ANSWER= Database

2. MySQL is a ________ relational type of database management system.

ANSWER= Relational

3. The SQL command used to create a new table is ________.

ANSWER= CREATE TABLE

4. The ________ statement is used to modify the structure of an existing table.

ANSWER= ALTER TABLE

5. To insert new data into a table, we use the ________ statement.

ANSWER= INSERT INTO



FILL IN THE BLANKS WITH APPROPRIATE WORDS GIVEN IN THE BRACKET

1. The ______ clause is used to filter rows based on specific conditions.

ANSWER= WHERE

2. The ______ clause is used to eliminate duplicate values from the result set.

ANSWER= DISTINCT

3. The ______ statement is used to change existing data in a table.

ANSWER= UPDATE

4. The ______ operator is used to match values within a specified range.

ANSWER= BETWEEN

5. The ______ operator is used to match values from a given list.

ANSWER= IN



FILL IN THE BLANKS WITH APPROPRIATE WORDS GIVEN IN THE BRACKET

1. The ______ clause is used to sort the result of a query in ascending or descending order.

ANSWER= ORDER BY

2. The ______ operator is used for pattern matching using wildcards like % and _.

ANSWER= LIKE

3. A ______ in SQL performs a specific task and returns a single value.

ANSWER= function

4. _______ functions operate on individual rows and return one result per row.

ANSWER= Single-row

5. ______ functions operate on a group of rows and return a single result.

ANSWER= Group (aggregate)



FILL IN THE BLANKS WITH APPROPRIATE WORDS GIVEN IN THE BRACKET

1. The ______ clause is used to group rows that have the same values in specified columns.

ANSWER= GROUP BY

2. The ______ operation combines rows from two or more tables based on common fields.

ANSWER= JOIN

3. The SQL command used to remove a table from the database is _______.

ANSWER= DROP TABLE

4. IS NULL and IS NOT NULL are used to test _______ (null values).

ANSWER= empty or missing values

5. The _____ clause is used to apply conditions on grouped data after aggregation.

ANSWER= HAVING



FILL IN THE BLANKS WITH APPROPRIATE WORDS GIVEN IN THE BRACKET

1. ______ clause is used along with SELECT to avoid duplicate values in an SQL query.

ANSWER= DISTINCT

2. ______ operation is used to combine the selected rows of two tables at a time.

ANSWER= JOIN

3. ______ is a command which comes under DML.

ANSWER= UPDATE

4. _____ is an aggregate function in SQL.

ANSWER= SUM

5. ______ operator defines the range of values inclusive of boundary values.

ANSWER= BETWEEN

6. The function that converts string into uppercase is _______.

ANSWER= UPPER()

7. The result of 5 + NULL is _________.

ANSWER= NULL