CBSE class 12 Computer Science notes

Lessons

COMPUTER NETWORKING NOTES FOR CLASS 12 – II

Preview

Q1. What is Network Topology and its types? Network Topology is the structure to organize and interconnect computers on a network . Different types of network topologies are: i. Bus Topology Bus topology is a network type in which every computer and network device is connected to single cable. Advantages Short cable length. It is …

Database Concepts Class 12 CBSE

1. What is database? Database is a collection of related information. 2. What is Database Management Systems (DBMS)? DBMS is a software to store and maintain data in the form of tables. We can easily create, modify, delete and view data from database. Examples: Ms-Access, MySQL, SQLite, Microsoft SQL Server, Oracle etc. 3. What is …

SQL commands For class XII CBSE

DDL commands of SQL There are three DDL commands of SQL. 1. Create Table This statement is used to create the structure of a table. We can specify the various fields along wih their data types, size and range of values which can be stored in those fields. We can also specify the constraints applied …

SQL based questions with answers

Q1. Write SQL queries on the basis of following table. Relation :  Student Name Class Fee Gender DOB Rahul XII 1200 M 2005-02-01 Mehul XII 1200 M 2004-12-11 Manisha XI 1050 F 2006-10-12 Sujoy XI 1050 M NULL Sonakshi XII 1200 F 2005-09-19 Suman X 950 F 2008-06-16 i. Display all records from table student. …

Output based SQL queries with answers

Q1. Write output of the SQL queries on the basis of following table. Relation :  Student Name Class Fee Gender DOB Rahul XII 1200 M 2005-02-01 Mehul XII 1200 M 2004-12-11 Manisha XI 1050 F 2006-10-12 Sujoy XI 1050 M NULL Sonakshi X 1200 F 2005-09-19 i. Select * from student; Rahul XII 1200 M …

Class 12 Computer Science Practical File 2020-2021

Preview

Class 12 Computer Science Practical File 2020-2021 Class 12 Computer Science Project File Python Programs 1. Program to add two numbers. x = int(input(‘Enter integer value:’)) print(‘Value entered:’, x) print(‘Type:’, type(x)) 2. Program to find simple interest. p = float(input(‘Enter principle’)) r = float(input(‘Enter rate’)) t = float(input(‘Enter time’)) i=p*r*t/100 print(“Interest=”,i) 3. Program to check …

Class 12 Computer Science Project File

Preview

Class 12 Computer Science Project File 2020-2021   Download Documentation Download Project Code [Copy code to python file] Class 12 Computer Science Practical File import os import csv def addrecord():     print(“Add a new Record”)     print(“================”)     f=open(‘students.csv’,’a’)     s=csv.writer(f)     rollno=int(input(‘Enter rollno=’))     name=input(‘Enter name=’)     marks=float(input(‘Enter marks=’))     rec=[rollno,name,marks]     s.writerow(rec)     …

class 12 computer science practical paper with solution

Preview

class 12 computer science practical paper with solution AISSCE Practical Examination 2021 COMPUTER SCIENCE (083) Time : 3 Hours                                                                                      M.M.  30   Q1.  A binary file “student.dat” has structure [Rollno,  Name, Class ].                                    7 a) Write a user defined function Create() to input data for a record and add to Student.dat . b) Write a function Display() in Python to …