Data manipulation through SQL Practice Test

12th Standard Computer Science — Data manipulation through SQL: 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

Which of the following is an organized collection of data?

A.Database B.DBMS C.Information D.Records

SQLite falls under which database system?

A.Flat file database system B.Relational Database system C.Hierarchical database system D.Object oriented Database system

Which of the following is a control structure used to traverse and fetch the records of the database?

A.Pointer B.Key C.Cursor D.Insertion point

Any changes made in the values of the record should be saved by the command

A.Save B.Save As C.Commit D.Oblige

Which of the following executes the SQL command to perform some action?

A.execute() B.key() C.cursor() D.run()

Which of the following function retrieves the average of a selected column of rows in a table?

A.Add() B.SUM() C.AVG() D.AVERAGE()

The function that returns the largest value of the selected column is

A.MAX() B.LARGE() C.HIGH() D.MAXIMUM()

Which of the following is called the master table?

A.sqlite_master B.sql_master C.main_master D.master_main

The most commonly used statement in SQL is

A.cursor B.select C.execute D.commit

Q10

Which of the following keyword avoid the duplicate?

A.Distinct B.Remove C.Where D.GroupBy

Q11

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

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

Q12

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.

Q13

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.

Q14

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.

Q15

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

Q16

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

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

Q17

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

Q18

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

Q19

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 (/)

Q20

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

Q21

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

Q22

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.

Q23

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.

Q24

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

Q25

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