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 …