Monalisa CS

6.58K subscribers

1.2K videos

Hi All , Welcome to Monalisa CS. A free Computer Science Lectures and GATE Computer Science & Information Technology , Data Science & Artificial Intelligence...

Latest Videos

GATE CS 2018 Question 12 Consider the following two tables and four queries in SQL.Book (isbn, bn

GATE CS 2017 Set 2 Question 46 Consider the following database table named top_Scorer.Consider

GATE CS 2017 Set 1 Question 23 Consider a database that has the relation schema EMP (EmpId, EmpNa

GATE CS 2016 Set 2 Question 52 Consider the following database table named water_schemes

Ch 3.13 Test for Empty Relations, exists & not exists DBMS lectures by @MonalisaCS​

GATE CS 2015 Set 3 Question 3 Consider the following relationCinema( theater , address , capacity

GATE CS 2015 Set 1 Question 27 Consider the following relationConsider the following SQL query.

GATE CS 2014 Set 3 Question 54 Consider the following relational schema employee (empId

GATE CS 2014 Set 2 Question 54 SQL allows duplicate tuples in relations, and correspondingly

GATE CS 2014 Set 1 Question 54 Given the following schema employees(emp-id, first-name,

GATE CS 2014 Set 1 Question 22 Given the following statements S1 A foreign key declaration

GATE CS 2012 Question 51 Consider the following relations A , B and C. How many tuples does the

GATE CS 2012 Question 15 Which of the following statements are TRUE about an SQL query

GATE CS 2011 Question 46 Database table by name Loan_Records is given below.What is the output of

GATE CS 2010 Question 19A relational schema for a train reservation database is given below.

GATE DA 2025 Question 47 Consider a database relation R with attributes ABCDEFG , and having the

GATE DA 2025 Question 46 Consider the following two relations, named Customer and Person in a

GATE DA 2024 Question 36 Given the relational schema R=(U,V,W,X,Y,Z) and the set of functional

GATE CS 2023 Question 51 Consider the following table named Student in a relational database.

GATE CS 2025 Set 1 Question 45Consider the following database tables of a sports league.player

GATE CS 2025 Set 2 Question 44 Consider the following relational schema Students (rollno

Ch 3.12 Nested Subqueries DBMS lectures by @MonalisaCS​

Ch 3.11 The Having Clause DBMS lectures by @MonalisaCS​

Ch 3.10 Aggregate Functions avg ,max,min,sum ,count DBMS lectures by @MonalisaCS​

Ch 3.9 Set Operations Union, Intersect, Except Null Values DBMS lectures by @Monalisa CS​

Ch 3.8 Order By Where Clause Predicates DBMS lectures by @Monalisa CS​

Ch 3.7 String Operations , Select DBMS lectures by @Monalisa CS​

Ch 3.6 The Rename Operation DBMS lectures by @Monalisa CS​

Ch 3.5 The Natural Join on Multiple Relations DBMS lectures by @Monalisa CS​

Ch 3.4 Queries on Multiple Relations DBMS lectures by @Monalisa CS​

Ch 3.13 Test for Empty Relations, exists & not exists DBMS lectures by @MonalisaCS

Ch 3.12 Nested Subqueries DBMS lectures by @MonalisaCS

Ch 3.11 The Having Clause DBMS lectures by @MonalisaCS

Ch 3.10 Aggregate Functions avg ,max,min,sum ,count DBMS lectures by @MonalisaCS

Ch 3.9 Set Operations Union, Intersect, Except Null Values DBMS lectures by @Monalisa CS

Ch 3.8 Order By Where Clause Predicates DBMS lectures by @Monalisa CS

Ch 3.7 String Operations , Select DBMS lectures by @Monalisa CS

Ch 3.6 The Rename Operation DBMS lectures by @Monalisa CS

Ch 3.5 The Natural Join on Multiple Relations DBMS lectures by @Monalisa CS

Ch 3.4 Queries on Multiple Relations DBMS lectures by @Monalisa CS