Class 11 Informatics Practices Notes

Lessons

class 11 IP Database Concepts notes

Length: 0 minutes

class 11 IP Database Concepts notes 1. What is database? It is a collection of related information. 2. What is Database Management Systems (DBMS)? It is a software to store and maintain data in the form of tables. We can easily create, modify, delete and view information from database. Examples: MySQL, SQLite, SQL Server, Oracle …

SQL based questions with answers for class 11 Informatics Practices

Length: 0 minutes

SQL based questions with answers for class 11 Informatics Practices 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 …