12th Standard Syllabus & Materials

12th Standard

TN 12th Computer Applications மின்னணு தரவு பரிமாற்றம் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications மின் - வணிக பாதுகாப்பு அமைப்புகள் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications மின்னணு செலுத்தல் முறைகள் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications மின் - வணிகம் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications திறந்த மூல கருத்துருக்கள் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications வலையமைப்பு வடமிடல் Sample Question Papers Study Material - QB365 Set A

12th Standard Computer Science English Medium - Data Manipulation Through SQL 2 Mark Book Back Question Paper and Answer Key 2022 - 2023

Published on: 13/09/2022

QB365 provides a detailed and simple solution for every Possible Book Back Questions in Class 12 Computer Science Subject - Data Manipulation Through SQL , English Medium. It will help Students to get more practice questions, Students can Practice these question papers in addition to score best marks.

Download Tamil Nadu 12th Standard Computer Science question papers, model tests, one-mark questions, important questions, and public exam papers in PDF format. Free study materials and answer keys for TN State Board students.

Questions + Answers key

Take MCQ Computer Science Test

QB365 Student Learing Managemnet System

Std: 12th Standard - Computer Science

chapter: - Model Question paper

Visit QB365-SLMS - https://www.qb365.in/slms/ Complete Questions and Answers

Questions:

Generic 2

5 x 2 = 10

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

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

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

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

Mention the users who uses the Database.

Visit QB365-SLMS - https://www.qb365.in/slms/

Answers Key:

Generic 2

5 x 2 = 10

The fetchall() method is used to fetch all rows from the database table.
result = cursor. fetchall()

To populate the table "INSERT" command is passed to SQLite."execute" method executes the SQL command to perform some action.
Example:
Sql_command =" " INSERT INTO student (Rollno, Sname, Grade, Gender, Average, birth_date) values (NULL, "Akshay", "B", "M", "87.8", "2001-12-12");" " cursor.execute(sql_command)

If a column of a table is declared to be an INTEGER PRIMARY KEY, then whenever a NULL is used as an input for this column, the NULL will be automatically converted into an integer which will be one larger than the highest value so far used in that column.

Create a connection using connect() method and pass the nanie of the database file.
Example:
#connecting to the database
connection = sqlite3.connect ("Academy.db")
#cursor
cursor = connection.cursor()

Users of database can be human users or programmers, other programs or applications.