On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Relational Database Design Set 2

Q1 | The relation employee(ID,name,street,Credit,street,city,salary) is decomposed intoemployee1 (ID, name)employee2 (name, street, city, salary) This type of decomposition is called
  • Lossless decomposition
  • Lossless-join decomposition
  • All of the mentioned
  • None of the mentioned
Q2 | Inst_dept (ID, name, salary, dept name, building, budget) is decomposed intoinstructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under
  • Lossy-join decomposition
  • Lossy decomposition
  • Lossless-join decomposition
  • Both Lossy and Lossy-join decomposition
Q3 | There are two functional dependencies with the same set of attributes on the left side of the arrow:A->BC A->BThis can be combined as
  • A->BC
  • A->B
  • B->C
  • None of the mentioned
Q4 | Consider a relation R(A,B,C,D,E) with the following functional dependencies:ABC -> DE andD -> AB The number of superkeys of R is:
  • 2
  • 7
  • 10
  • 12
Q5 | Which, if any, of the two queries above will correctly (in SQL2) get the desired set ofemployee ID’s?
  • Both I and II
  • I only
  • II only
  • Neither I nor I
Q6 | Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively(again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in theresult of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?
  • m = min(r,s)
  • 0 <= m <= r + s
  • min(r,s) <= m <= max(r,s)
  • 0 <= m <= min(r,s)
Q7 | Which of the following is not a key?
  • A
  • E
  • B, C
  • D
Q8 | If a relation is in BCNF, then it is also in
  • 1 NF
  • 2 NF
  • 3 NF
  • All of the above
Q9 | What action does ⋈ operator perform in relational algebra
  • Output specified attributes from all rows of the input relation and remove duplicate tuples from the output
  • Outputs pairs of rows from the two input relations that have the same value on all attributes that have the same name
  • Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)
  • Return rows of the input relation that satisfy the predicate
Q10 | Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible
  • Both the statements are true
  • Statement 1 is correct but Statement 2 is false
  • Statement 1 is false but Statement 2 is correct
  • Both the statements are false
Q11 | The____condition allows a general predicate over the relations being joined.
  • On
  • Using
  • Set
  • Where
Q12 | Which of the join operations do not preserve non matched tuples?
  • Left outer join
  • Right outer join
  • Inner join
  • Natural join
Q13 | The normal form which satisfies multivalued dependencies and which is in BCNF is
  • 4 NF
  • 3 NF
  • 2 NF
  • All of the mentioned
Q14 | Which of the following is a tuple-generating dependencies?
  • Functional dependency
  • Equality-generating dependencies
  • Multivalued dependencies
  • Non-functional dependency
Q15 | The main task carried out in the __________ is to remove repeating attributes toseparate tables.
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • Fourth Normal Form
Q16 | Which forms has a relation that possesses data about an individual entity?
  • 2NF
  • 3NF
  • 4NF
  • 5NF
Q17 | Which of the following has each related entity set has its own schema and there is anadditional schema for the relationship set?
  • A many-to-many relationship set
  • A multivalued attribute of an entity set
  • A one-to-many relationship set
  • None of the mentioned
Q18 | Fifth Normal form is concerned with
  • Functional dependency
  • Multivalued dependency
  • Join dependency
  • Domain-key
Q19 | n which of the following, a separate schema is created consisting of that attribute andthe primary key of the entity set.
  • A many-to-many relationship set
  • A multivalued attribute of an entity set
  • A one-to-many relationship set
  • None of the mentioned
Q20 | In 2NF
  • No functional dependencies (FDs) exist
  • No multivalued dependencies (MVDs) exist
  • No partial FDs exist
  • No partial MVDs exist
Q21 | Which of the following is related to information?
  • Data
  • Communication
  • Knowledge
  • All of these
Q22 | Data is:
  • A piece of fact
  • Metadata
  • Information
  • None of these.
Q23 | Which of the following is element of the database?
  • Data
  • Constraints and schema
  • Relationships
  • All of these.
Q24 | What represent a correspondence between the various data elements?
  • Data
  • Constraints
  • Relationships
  • Schema
Q25 | Which of the following is an advantage of using database system?
  • Security enforcement
  • Avoidance of redundancy
  • Reduced inconsistency
  • All of these.