DBMS Tutorial Point
Google Mera Naam Kya Hai-गूगल मेरा नाम क्या है? Friends, today we are going to tell you about a very interesting topic, do you also often ask Google what is my name Google Mera Naam Kya Hai, and all the time you want Google to tell your name, today you absolutely Have come to the … Read more
Consider a relation R(A, B, C, D) with the following functional dependencies: A -> (B, C, D), (A, D) -> (B, C) and (C, D) -> (A, B). Identify the candidate key(s). a) {A}b) {A}, {C, D}c) {A}, {C, D}, {A, D}d) {C, D} The database design prevents some data from being stored due to … Read more
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
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
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