Data manipulation through SQL Additional Practice Test

12th Standard Computer Science — Data manipulation through SQL: Additional 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 — 15 questions available.

Set up your test

Number of questions

Time limit

Time remaining00:00

Which Python module is imported natively to work with SQLite databases?

A.mysql B.sqlite3 C.sql_db D.db_connection

When creating an SQLite database connection using sqlite3.connect("Academy.db"), what happens if the database file does not exist?

A.Python raises a FileNotFoundError. B.SQLite opens an in-memory database temporarily. C.Python automatically creates a new database file with that name. D.The connection fails with an AttributeError.

What is the primary purpose of a cursor object in Python's sqlite3 module?

A.To establish the physical connection to the database file. B.To automatically save all changes made to database records. C.To configure the database security and license keys. D.To traverse and fetch the records of the database.

In SQLite3, if a column is declared as INTEGER PRIMARY KEY and a NULL value is inserted into it, what does SQLite automatically do?

A.It raises an IntegrityError. B.It leaves the value as NULL in the database. C.It converts the NULL into an auto-incremented integer value. D.It assigns a random floating-point number.

Which cursor method in the sqlite3 module returns the next single row of a query result set, or None if no rows remain?

A.fetchall() B.fetchone() C.fetchmany() D.fetchnext()

Which symbol is used in Python to unpack database query results when printing them with the sep argument?

A.& B.% C.* D.#

Which attribute of the SQLite database connection object can be used to check the total number of database rows that have been modified, inserted, or deleted since the connection was opened?

A.total_changes B.total_rows C.changes_count D.modified_changes

Which keyword must be used in a Python script to permanently save any modifications made to SQLite database records?

A.save() B.commit() C.store() D.apply()

What type of placeholders does the sqlite3 module support for writing parameterized, secure SQL statements?

A.Ampersand style (&) and colon style (:) B.Dollar style (\$) and hash style (#) C.Question mark style (?) and named style (:name) D.Percentage style (%) and slash style (/)

Q10

Which built-in SQLite system table holds key information about the database structure and can be queried to list all user-created tables?

A.sql_master B.sqlite_master C.sqlite_schema D.database_tables

Q11

What does the first element (index 0) of each tuple inside a cursor's description attribute represent?

A.The data type of the column B.The total number of rows in the column C.The name of the column D.The maximum size of the column

Q12

If a student database table contains a column named Average with some NULL values, what is the behavior of the AVG(AVERAGE) aggregate function?

A.It raises an error due to the presence of NULL values. B.It includes NULL values in the calculation by treating them as zero. C.It ignores the NULL values completely during calculation. D.It returns NULL as the final average result.

Q13

Why are SQL statement strings in Python often enclosed inside triple quotes (""") when working with the sqlite3 module?

A.Because Python requires triple quotes for all database query commands. B.Because the SQL statement might contain single or double quotes within its values. C.To enable automatic execution of multiple statements simultaneously. D.To tell SQLite to compress the database file dynamically.

Q14

Which SQL clause can be used with aggregate functions in Python database queries but cannot be used in a standard SQL WHERE clause?

A.DISTINCT B.HAVING C.ORDER BY D.GROUP BY

Q15

When writing SQLite query results to a CSV file in Python, why is the replace() method commonly used during the subsequent reading of the CSV file?

A.To convert the plain text file back into a binary Excel sheet. B.To decrypt the database data that was written to the file. C.To eliminate the default newline character that ends each CSV record. D.To dynamically resize the columns of the spreadsheet.

More for this chapter

About this Data manipulation through SQL test

This free online practice test covers Data manipulation through SQL 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