What is Embedded SQL

What is embedded SQL, embedded SQL is the one that combines the high-level language with the DB language like SQL. It allows the application languages to communicate with DB and get the requested result. Embedded SQL is a super-set of Transact-SQL that lets you place Transact-SQL statements in application programs written in languages such as … Read more

DBMS GATE Questions 2018

In this article you will get DBMS GATE Questions 2018 with answers. 1. In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in R and that the cardinality of E1 is greater than the cardinality of E2. Which one … Read more

DBMS GATE Questions 2019

In this article you will get DBMS GATE Questions 2019 with answers. 1. Which one of the following statements is NOT correct about the B+ tree data structure used for creating an index of a relational database table? a. Each leaf node has a pointer to the next leaf nodeb. Non-leaf nodes have pointers to data recordsc. … Read more

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