Tamil Nadu Board of Secondary EducationHSC Science Class 12th
Advertisement Remove all ads

Tamil Nadu Board Samacheer Kalvi solutions for Class 12th Computer Science Answers Guide chapter 15 - Data manipulation through SQL [Latest edition]

Chapters

Class 12th Computer Science Answers Guide - Shaalaa.com
Advertisement Remove all ads
Advertisement Remove all ads
Advertisement Remove all ads

Chapter 15: Data manipulation through SQL

Evaluation - Part - IEvaluation - Part - IIEvaluation - Part - IIIEvaluation - Part - IV
Advertisement Remove all ads
Evaluation - Part - I [Page 317]

Tamil Nadu Board Samacheer Kalvi solutions for Class 12th Computer Science Answers Guide Chapter 15 Data manipulation through SQLEvaluation - Part - I [Page 317]

Evaluation - Part - I | Q 1. | Page 317

Which of the following is an organized collection of data?

  • Database

  • DBMS

  • Information

  • Records

Evaluation - Part - I | Q 2. | Page 317

SQLite falls under which database system?

  • Flat file database system

  • Relational Database system

  • Hierarchical database system

  • Object-oriented Database system

Evaluation - Part - I | Q 3. | Page 317

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

  • Pointer

  • Key

  • Cursor

  • Insertion point

Evaluation - Part - I | Q 4. | Page 317

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

  • Save

  • Save As

  • Commit

  • Oblige

Evaluation - Part - I | Q 5. | Page 317

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

  • execute()

  • key()

  • cursor()

  • run()

Evaluation - Part - I | Q 6. | Page 317

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

  • Add()

  • SUM()

  • AVG()

  • AVERAGE()

Evaluation - Part - I | Q 7. | Page 317

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

  • MAX()

  • LARGE()

  • HIGH()

  • MAXIMUM()

Evaluation - Part - I | Q 8. | Page 317

Which of the following is called the master table?

  • sqlite_master

  • sql_master

  • main_master

  • master_main

Evaluation - Part - I | Q 9. | Page 317

The most commonly used statement in SQL is ______

  • cursor

  • select

  • execute

  • commit

Evaluation - Part - I | Q 10. | Page 317

Which of the following clause avoid the duplicate?

  • Distinct

  • Remove

  • Where

  • GroupBy

Evaluation - Part - II [Page 318]

Tamil Nadu Board Samacheer Kalvi solutions for Class 12th Computer Science Answers Guide Chapter 15 Data manipulation through SQLEvaluation - Part - II [Page 318]

Evaluation - Part - II | Q 1. | Page 318

Mention the users who use the Database.

Evaluation - Part - II | Q 2. | Page 318

Which method is used to connect a database? Give an example.

Evaluation - Part - II | Q 3. | Page 318

What is the advantage of declaring a column as “INTEGER PRIMARY KEY”

Evaluation - Part - II | Q 4. | Page 318

Write the command to populate the record in a table. Give an example.

Evaluation - Part - II | Q 5. | Page 318

Which method is used to fetch all rows from the database table?

Evaluation - Part - III [Page 318]

Tamil Nadu Board Samacheer Kalvi solutions for Class 12th Computer Science Answers Guide Chapter 15 Data manipulation through SQLEvaluation - Part - III [Page 318]

Evaluation - Part - III | Q 1. | Page 318

What is SQLite?What is its advantage?

Evaluation - Part - III | Q 2. | Page 318

Mention the difference between fetchone() and fetchmany().

Evaluation - Part - III | Q 3. | Page 318

What is the use of the Where Clause?

Evaluation - Part - III | Q 3. | Page 318

Give a python statement Using the where clause.

Evaluation - Part - III | Q 4. | Page 318

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

Evaluation - Part - III | Q 5. | Page 318

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

Evaluation - Part - IV [Pages 318 - 319]

Tamil Nadu Board Samacheer Kalvi solutions for Class 12th Computer Science Answers Guide Chapter 15 Data manipulation through SQLEvaluation - Part - IV [Pages 318 - 319]

Evaluation - Part - IV | Q 1. | Page 318

Write in brief about SQLite and the steps used to use it.

Evaluation - Part - IV | Q 2. | Page 318

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
Evaluation - Part - IV | Q 3. | Page 319

The hat is the use of the HAVING clause. Give an example python script.

Evaluation - Part - IV | Q 4. | Page 319

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
Evaluation - Part - IV | Q 5. (i) | Page 319

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.

Evaluation - Part - IV | Q 5. (ii) | Page 319

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

Chapter 15: Data manipulation through SQL

Evaluation - Part - IEvaluation - Part - IIEvaluation - Part - IIIEvaluation - Part - IV
Class 12th Computer Science Answers Guide - Shaalaa.com

Tamil Nadu Board Samacheer Kalvi solutions for Class 12th Computer Science Answers Guide chapter 15 - Data manipulation through SQL

Tamil Nadu Board Samacheer Kalvi solutions for Class 12th Computer Science Answers Guide chapter 15 (Data manipulation through SQL) include all questions with solution and detail explanation. This will clear students doubts about any question and improve application skills while preparing for board exams. The detailed, step-by-step solutions will help you understand the concepts better and clear your confusions, if any. Shaalaa.com has the Tamil Nadu Board of Secondary Education Class 12th Computer Science Answers Guide solutions in a manner that help students grasp basic concepts better and faster.

Further, we at Shaalaa.com provide such solutions so that students can prepare for written exams. Tamil Nadu Board Samacheer Kalvi textbook solutions can be a core help for self-study and acts as a perfect self-help guidance for students.

Concepts covered in Class 12th Computer Science Answers Guide 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 Tamil Nadu Board Samacheer Kalvi Class 12th solutions Data manipulation through SQL exercise by students are an easy way to prepare for the exams, as they involve solutions arranged chapter-wise also page wise. The questions involved in Tamil Nadu Board Samacheer Kalvi Solutions are important questions that can be asked in the final exam. Maximum students of Tamil Nadu Board of Secondary Education Class 12th prefer Tamil Nadu Board Samacheer Kalvi Textbook Solutions to score more in exam.

Get the free view of chapter 15 Data manipulation through SQL Class 12th extra questions for Class 12th Computer Science Answers Guide and can use Shaalaa.com to keep it handy for your exam preparation

Advertisement Remove all ads
Share
Notifications

View all notifications


      Forgot password?
View in app×