Lessons
COMPUTER NETWORKING NOTES FOR CLASS XII – I
Computer Networking Quiz – I
COMPUTER NETWORKING NOTES FOR CLASS 12 – II
PreviewQ1. 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 …
Computer Networking Quiz – II
Computer Networking Quiz – III
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 …
Database Concepts Quiz
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 …
SQL Statements Quiz- I
SQL Statements Quiz-II
Class 12 Computer Science Practical File 2020-2021
PreviewClass 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
PreviewClass 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
Previewclass 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 …