12th Standard Syllabus & Materials

12th Standard

TN 12th English Poem - 6 - Incident of the French Camp Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th English Prose - 6 - On the Rule of the Road Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th English Prose - 5 - The Chair Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th English Supplementary - 4 - The Midnight Visitor Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th English Poem - 4 - Ulysses Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th English Prose - 4 - The Summit Sample Question Papers Study Material - QB365 Set A

12th Standard English Medium Computer Science Subject Data Manipulation Through SQL Creative 2 Mark Questions with Solution

Published on: 22/06/2021

QB365 provides detailed and simple solution for every Creative Questions in class 12 Computer Science Subject. It will helps to get more idea about question pattern in every Creative questions with solution.

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: - Creative Questions

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

Questions:

Generic 2

5 x 2 = 10

How the cursor object is created?

Write the placeholders which supported by SQlite3 module Execute.

Write a note or cursor. description.

How will you sort the data in a table in an ordered way?

What is the reason behind defining a SQL command with triple quotes?

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

Answers Key:

Generic 2

5 x 2 = 10

The cursor object is created by calling the cursor ( ) method of connection. The cursor is used to traverse the records from the result set.

Execute (sql[, parameters]) :
(i) Executes a single SQL statement. The SQL statement may be parameterized (i.e. placeholders instead of SQL literals).
(ii) The SQlite3 module supports two kinds of placeholders: question marks? ("qmark style") and named placeholders: name ("named style").

cursor. description contains the details of each column headings. It will be stored as a tuple and the first one that is 0(zero) index refers to the column name. Using this command you can display the table's Field names.

(i) The ORDER BY clause can be used along with the SELECT statement to sort the data of specific fields in an ordered way.
(ii) It is used to sort the result-set in ascending or descending order.

The reason behind the triple quotes is sometime the values in the table might contain single or double quotes.