50 DBMS MCQs with Answers

Let R1 (a, b, c) and R2 (x, y, z) be two relations in which a is the foreign key of R1 that refers to the primary key of R2 . Consider following four options. (a)Insert into R 1 (b)Insert into R 2 (c)Delete from R 1 (d)Delete from R 2 Which of the following is correct about the referential integrity constraint with respect to above?

Operations (a) and (b) will cause violation. Operations (b) and (c) will cause violation. Operations (c) and (d) will cause violation. Operations (d) and (a) will cause violation.

How to express that some person keeps animals as pets?

A view of database that appears to an application program is known as Virtual table None of these Which operation is used to extract specified columns from a table? Substitute (a) and (b) happens (a) and (d) happens (a) and (c) happens (b) and (c) happens In functional dependency Armstrong inference rules refers to Reflexivity, Augmentation and Decomposition Transitivity, Augmentation and Reflexivity Augmentation, Transitivity, Reflexivity and Decomposition Reflexivity, Transitivity and Decomposition Which of the following statements is FALSE about weak entity set? Weak entities can be deleted automatically when their strong entity is deleted.

Weak entity set avoids the data duplication and consequent possible inconsistencies caused by duplicating the key of the strong entity.

A weak entity set has no primary keys unless attributes of the strong entity set on which it depends are included

Tuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F = G, A -> BC, B -> CFH, E -> A, F -> EG> is a set of functional dependencies (FDs) so that F+ is exactly the set of FDs that hold for R. How many candidate keys does the relation R have?

In RDBMS, different classes of relations are created using __________ technique to prevent modification anomalies.

Functional Dependencies Data integrity Referential integrity Normal Forms

There are 50 questions to complete.

Last Updated : Take a part in the ongoing discussion View All Discussion

Corporate & Communications Address:- A-143, 9th Floor, Sovereign Corporate Tower, Sector- 136, Noida, Uttar Pradesh (201305) | Registered Address:- K 061, Tower K, Gulshan Vivante Apartment, Sector 137, Noida, Gautam Buddh Nagar, Uttar Pradesh, 201305

GFG App on Play StoreGFG App on App Store