DBMS Tutorial Point
In this article, we will provide you with 30 DBMS MCQ questions and answers. These questions will help you test your knowledge of DBMS concepts. We will also provide you with the correct answers and explanations for each question. So, let’s get started! Functional dependency is a relationship between or amongA. EntitiesB. RowsC. AttributesD. TablesAns: … Read more
This post includes the latest 151 questions and answers related to the database management system. Latest MCQ questions. A relational database consists of a collection ofa) Tablesb) Fieldsc) Recordsd) Keyse) none of these A __ in a table represents a relationship among a set of values.a) Columnb) Keyc) Rowd) Entrye) none of these b The … Read more
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
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