Class 12 Informatics Practice Daily Assigment No 1.

Hello student We started new series in this series we will gives you daily questions from previous year papers question which helps you better understand the which type of questions will be asked in your upcoming Informatics practice examination. Daily we give you 3 question as assignment you have to do in your copy as assignment and we will upload a video on youtube in which I explain each and every function.

Q1. Write Command each of the following question.

a.Write command to compute sum of every column of the TABLE.

b.Write command to compute mean of column Rainfall

c.Write command to compute average maxTemp, Rainfall for first 5 rows

 

City	MaxTemp	MinTemp	Rainfall
DELHI	40	32	24.1
BANGLURU	31	25	36.2
CHENNAI	35	27	40.8
MUMBAI	29	21	35.2
KOLKATA	39	23	41.8

       

Q2. is_connected() is the MYSQL function to :

(i) establish a connection to a mysql database from python.

(ii) verify whether the python application is connected to mysql database.

(iii) traverse through records in mysql database. 

(iv) None of the above

Q3. Shewani has recently started working in MySQL. Help her in understanding the difference between the following :

(i)Where and having clause

(ii)Count(column_name) and count(*)

How do you pass informatics practices? Which book is best for Informatics Practices Class 12? What is informatics practices subject? Is informatics practices a major subject in CBSE? class 12 previous year paper informatics practice cbse class 12 informatics practices question paper (with answer key) sample paper class 12 informatics practices 2021 informatics practices class 12 question bank pdf ip sample paper class 12 term 1 ip sample paper class 12 2022 ip sample paper class 12 2021 term 2 ip sample paper 2019-20 2018 ip board paper