Every Book Back multiple-choice question from Data manipulation through SQL (12th Standard Computer Science, Samacheer Kalvi) — each with the correct option highlighted and a clear, worked explanation. Free to read in English and Tamil.
Q1
Which of the following is an organized collection of data?
- A. DatabaseCorrect
- B. DBMS
- C. Information
- D. Records
Explanation. A database is defined as a structured or organized repository of related data, which is stored and accessed electronically from a computer system.
Q2
SQLite falls under which database system?
- A. Flat file database system
- B. Relational Database systemCorrect
- C. Hierarchical database system
- D. Object oriented Database system
Explanation. SQLite is a lightweight, serverless relational database system that stores its structured data in standard files on the system disk.
Q3
Which of the following is a control structure used to traverse and fetch the records of the database?
- A. Pointer
- B. Key
- C. CursorCorrect
- D. Insertion point
Explanation. A cursor is a database control structure that enables traversal over the records of a query result set and allows fetching those records sequentially.
Q4
Any changes made in the values of the record should be saved by the command
- A. Save
- B. Save As
- C. CommitCorrect
- D. Oblige
Explanation. In SQL databases, the commit transaction command is used to permanently save all changes made during the current transaction to the database.
Q5
Which of the following executes the SQL command to perform some action?
- A. execute()Correct
- B. key()
- C. cursor()
- D. run()
Explanation. The execute method of the cursor object is used in Python's sqlite3 library to run SQL statements and perform database operations.
Q6
Which of the following function retrieves the average of a selected column of rows in a table?
- A. Add()
- B. SUM()
- C. AVG()Correct
- D. AVERAGE()
Explanation. The AVG function is an aggregate function in SQL that computes and returns the average value of a numeric column.
Q7
The function that returns the largest value of the selected column is
- A. MAX()Correct
- B. LARGE()
- C. HIGH()
- D. MAXIMUM()
Explanation. The MAX aggregate function in SQL processes a column of values and returns the maximum or largest value found among them.
Q8
Which of the following is called the master table?
- A. sqlite_masterCorrect
- B. sql_master
- C. main_master
- D. master_main
Explanation. The sqlite_master table is a system table in SQLite that automatically defines and stores database schema information for all tables, indexes, and triggers.
Q9
The most commonly used statement in SQL is
- A. cursor
- B. selectCorrect
- C. execute
- D. commit
Explanation. The SELECT query is the most frequently executed statement in SQL as it retrieves and displays specified data from one or more tables.
Q10
Which of the following keyword avoid the duplicate?
- A. DistinctCorrect
- B. Remove
- C. Where
- D. GroupBy
Explanation. The DISTINCT keyword in a SELECT statement filters out identical rows from a query result set, ensuring only unique values are returned.
About these Data manipulation through SQL questions
These are the Book Back multiple-choice questions for Data manipulation through SQL from the Tamil Nadu State Board (Samacheer Kalvi) 12th Standard Computer Science syllabus. Each question shows the correct option and an original, step-by-step explanation so you understand the method, not just the answer. Use the answer key above to jump to any question, then take the practice test to check yourself under exam-like conditions.
Frequently asked questions
How many MCQs are there in Data manipulation through SQL?
This chapter has 10 book-back multiple-choice questions, each with the correct answer and a step-by-step explanation.
Are these 12th Standard Computer Science MCQs free to practise online?
Yes. Every question, answer and explanation here is free, and you can also take them as a timed practice test.
Where can I find the Data manipulation through SQL book-back answers?
The correct option for each question is highlighted on this page with a worked explanation, plus a quick answer-key summary at the top.
