DBMS GATE Questions 2020

In this article you will get DBMS GATE Questions 2020 with answers. 1. Consider a relational database containing the following schema. The primary key of each table is indicated by underlying the constituent fields. SELECT s.sno, s.snameFROM Suppliers s, Catalogue cWHERE s.sno = c.sno ANDCost > (SELECT AVG (cost)FROM CatalogueWHERE pno = ‘P4’GROUP BY pno); The … Read more