Advertisements
Chapters
2: Data Abstraction
3: Scoping
4: Algorithmic Strategies
5: Python - Variables and Operators
6: Control Structures
7: Python functions
8: Strings and String manipulation
9: Lists, Tuples, Sets and Dictionary
10: Python Classes and objects
11: Database Concepts
12: Structured Query Language (SQL)
13: Python and CSV files
14: Importing C++ programs in Python
▶ 15: Data manipulation through SQL
16: Data visualization using pyplot: line chart, pie chart and bar chart
![Samacheer Kalvi solutions for Computer Science [English] Class 12 TN Board chapter 15 - Data manipulation through SQL - Shaalaa.com](/images/computer-science-english-class-12-tn-board_6:5f2b1b2038084cf381bfa42c826a928c.jpg "Samacheer Kalvi solutions for Computer Science [English] Class 12 TN Board chapter 15 - Data manipulation through SQL")
Advertisements
Solutions for Chapter 15: Data manipulation through SQL
Below listed, you can find solutions for Chapter 15 of Tamil Nadu Board of Secondary Education Samacheer Kalvi for Computer Science [English] Class 12 TN Board.
Samacheer Kalvi solutions for Computer Science [English] Class 12 TN Board 15 Data manipulation through SQL Evaluation [Pages 317 - 319]
Part I - Choose the best answer
Which of the following is an organized collection of data?
Database
DBMS
Information
Records
SQLite falls under which database system?
Flat file database system
Relational Database system
Hierarchical database system
Object-oriented Database system
Which of the following is a control structure used to traverse and fetch the records of the database?
Pointer
Key
Cursor
Insertion point
Any changes made in the values of the record should be saved by the command.
Save
Save As
Commit
Oblige
Which of the following executes the SQL command to perform some action?
execute()
key()
cursor()
run()
Which of the following function retrieves the average of a selected column of rows in a table?
Add()
SUM()
AVG()
AVERAGE()
The function that returns the largest value of the selected column is ______
MAX()
LARGE()
HIGH()
MAXIMUM()
Which of the following is called the master table?
sqlite_master
sql_master
main_master
master_main
The most commonly used statement in SQL is ______
cursor
select
execute
commit
Which of the following clause avoid the duplicate?
Distinct
Remove
Where
GroupBy
Part II - Answer the following questions (2 Marks)
Mention the users who use the Database.
Which method is used to connect a database? Give an example.
What is the advantage of declaring a column as “INTEGER PRIMARY KEY”
Write the command to populate the record in a table. Give an example.
Which method is used to fetch all rows from the database table?
Part III - Answer the following questions (3 Marks)
What is SQLite?What is its advantage?
Mention the difference between fetchone() and fetchmany().
What is the use of the Where Clause?
Give a python statement Using the where clause.
Read the following details Based on that write a python script to display department-wise records
database name:- organization.db
Table name:- Employee
Columns in the table:- Eno, EmpName, Esal, Dept
Read the following details Based on that write a python script to display records in descending order of
Eno
database name:- organization.db
Table name:- Employee
Columns in the table:- Eno, EmpName, Esal, Dept
Part IV - Answer the following questions (5 Marks)
Write in brief about SQLite and the steps used to use it.
Write the Python script to display all the records of the following table using fetchmany().
| Icode | ItemName | Rate |
| 1003 | Scanner | 10500 |
| 1004 | Speaker | 3000 |
| 1005 | Printer | 8000 |
| 1008 | Monitor | 15000 |
| 1010 | Mouse | 700 |
The hat is the use of the HAVING clause. Give an example python script.
Write a Python script to create a table called ITEM with the following specifications.
Add one record to the table.
Name of the database:- ABC
Name of the table:- Item
Column name and specification:-
| Icode | :- | integer and act as primary key |
| Item Name | :- | The character with a length of 25 |
| Rate | :- | Integer |
| Record to be added | :- | 1008, Monitor, 15000 |
Consider the following table Supplier and item. Write a python script for the following Question?
| SUPPLIER | ||||
| Suppno | Name | City | Icode | SuppQty |
| S001 | Prasad | Delhi | 1008 | 100 |
| S002 | Anu | Bangalore | 1010 | 200 |
| S003 | Shahid | Bangalore | 1008 | 175 |
| S004 | Akila | Hydrabad | 1005 | 195 |
| S005 | Girish | Hydrabad | 1003 | 25 |
| S006 | Shylaja | Chennai | 1008 | 180 |
| S007 | Lavanya | Mumbai | 1005 | 325 |
Display Name, City, and Itemname of suppliers who do not reside in Delhi.
Consider the following table Supplier and item. Write a python script for the following Question?
| SUPPLIER | ||||
| Suppno | Name | City | Icode | SuppQty |
| S001 | Prasad | Delhi | 1008 | 100 |
| S002 | Anu | Bangalore | 1010 | 200 |
| S003 | Shahid | Bangalore | 1008 | 175 |
| S004 | Akila | Hydrabad | 1005 | 195 |
| S005 | Girish | Hydrabad | 1003 | 25 |
| S006 | Shylaja | Chennai | 1008 | 180 |
| S007 | Lavanya | Mumbai | 1005 | 325 |
Increment the SuppQty of Akila by 40
Solutions for 15: Data manipulation through SQL
Samacheer Kalvi solutions for Computer Science [English] Class 12 TN Board chapter 15 - Data manipulation through SQL
Shaalaa.com has the Tamil Nadu Board of Secondary Education Mathematics Computer Science [English] Class 12 TN Board Tamil Nadu Board of Secondary Education solutions in a manner that help students grasp basic concepts better and faster. The detailed, step-by-step solutions will help you understand the concepts better and clarify any confusion. Samacheer Kalvi solutions for Mathematics Computer Science [English] Class 12 TN Board Tamil Nadu Board of Secondary Education 15 (Data manipulation through SQL) include all questions with answers and detailed explanations. This will clear students' doubts about questions and improve their application skills while preparing for board exams.
Further, we at Shaalaa.com provide such solutions so students can prepare for written exams. Samacheer Kalvi textbook solutions can be a core help for self-study and provide excellent self-help guidance for students.
Concepts covered in Computer Science [English] Class 12 TN Board chapter 15 Data manipulation through SQL are Database, Creating a Database Using SQLite, SQL Query Using Python, SQLite, The SQL and, or and Not Operators, Querying a Date Column, Aggregate Functions, Updating a Record, Deletion Operation, Data Input by User, Using Multiple Table for Querying, Integrating Query with CSV File, Table List.
Using Samacheer Kalvi Computer Science [English] Class 12 TN Board solutions Data manipulation through SQL exercise by students is an easy way to prepare for the exams, as they involve solutions arranged chapter-wise and also page-wise. The questions involved in Samacheer Kalvi Solutions are essential questions that can be asked in the final exam. Maximum Tamil Nadu Board of Secondary Education Computer Science [English] Class 12 TN Board students prefer Samacheer Kalvi Textbook Solutions to score more in exams.
Get the free view of Chapter 15, Data manipulation through SQL Computer Science [English] Class 12 TN Board additional questions for Mathematics Computer Science [English] Class 12 TN Board Tamil Nadu Board of Secondary Education, and you can use Shaalaa.com to keep it handy for your exam preparation.
