1. The EXISTS keyword will be true if: Any row in the subquery meets the condition only All rows in the subquery fail the condition only Both of these two conditions are met Neither of these two conditions is met Explanation: EXISTS keyword checks for existance of a condition. 2. How many tables may be … Read more
1. To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL select command. A. ONLY B. UNIQUE C. DISTINCT D. SINGLE Answer: C 2. In the SQL language, the ________ statement is used to make table definitions. A. DQL B. DML C. DDL D. DCL Answer: C
Interface between an application program and the dbms The interface between an application program and the DBMS is usually provided by the Back end Data access API Front end Programmer Answer-Data access API
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
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
