DBMS Sample Test2

30 Questions | Total Attempts: 670

SettingsSettingsSettings
Please wait...
DBMS Sample Test2

This test is to test your normalization concepts


Questions and Answers
  • 1. 
        Write the candidate keys (type answer in lowercase) Acct_id Cust_id State_code Bal 100 C1 AZ 10000 200 C2 CA 65675 423 C1 MN 45646 111 C3 AZ 456456 100 C6 MN 65675 800 C2 TX 12133 500 C3 IL 123123
  • 2. 
    Write the primary  key (type answer in lowercase) Acct_id Cust_id State_code Bal 100 C1 AZ 10000 200 C2 CA 65675 423 C1 MN 45646 111 C3 AZ 456456 100 C6 MN 65675 800 C2 TX 12133 500 C3 IL 123123
  • 3. 
    The number of Fully FD’s >= No of FD’s   in a relation     
    • A. 

      True

    • B. 

      False

  • 4. 
    When a relation is in 3NF implies the relation does not have any insert anomalies 
    • A. 

      True

    • B. 

      False

  • 5. 
    Foreign key should be unique          
    • A. 

      True

    • B. 

      False

  • 6. 
    A relation is in 2NF implies all the determinants should be primary key
    • A. 

      True

    • B. 

      False

  • 7. 
    { C1, C2 } -----> { C3}  implies C1, C2  dependent on C3  
    • A. 

      True

    • B. 

      False

  • 8. 
    No of unique keys >= No of primary keys in a relation 
    • A. 

      True

    • B. 

      False

  • 9. 
    A NOT NULL constraint can have duplicate values 
    • A. 

      True

    • B. 

      False

  • 10. 
         C1----> C5  then what is determinant and dependent here?
    • A. 

      C1 Determinant C2 Dependent

    • B. 

      C2 Determinant C1 Dependent

    • C. 

      Both are dependent

    • D. 

      Both are Determinant

    • E. 

      None of the above

  • 11. 
    Referential  integrity should be maintained for each table  in RDBMS      
    • A. 

      True

    • B. 

      False

  • 12. 
    A relation is in  nNF implies it should be in (n-1)NF   
    • A. 

      True

    • B. 

      False

  • 13. 
    FD is also called left irreducible dependency      
    • A. 

      True

    • B. 

      False

  • 14. 
    Normal forms applied at the logical level        
    • A. 

      True

    • B. 

      False

  • 15. 
    If a column is a candidate key then it should be a super key
    • A. 

      True

    • B. 

      False

  • 16. 
    If a relation is in 2NF means update anomaly is eliminated
    • A. 

      True

    • B. 

      False

  • 17. 
    In a table If a primary key is composite then implies foreign key in that table is also composite
    • A. 

      True

    • B. 

      False

  • 18. 
    A table can have more than one foreign keys
    • A. 

      True

    • B. 

      False

  • 19. 
    In a relation all functional dependents should become a fully functional dependencies implies
    • A. 

      All the determinants are candidate keys

    • B. 

      All determinants consists of only one column

    • C. 

      The relation is in 3NF

    • D. 

      There are more than one candidate key

  • 20. 
    Dependent  is Primary key  implies
    • A. 

      There are more than one candidate key

    • B. 

      The relation contains full FD's

    • C. 

      There are more than one alternative keys

    • D. 

      There is only one super key

  • 21. 
        The above relation is in --------------      
    • A. 

      3NF

    • B. 

      BCNF

    • C. 

      2NF

    • D. 

      None of the above

  • 22. 
     Is the relation is in 3NF?
    • A. 

      Yes

    • B. 

      No

    • C. 

      Can't say

  • 23. 
    What is the attribute/s which acts as both determinant and dependent?(Type your answer in lower case)
  • 24. 
    Does the below table design contains any insert anomoly  movie_id movie_name Director_id Dir_name M1 ABC D1       KKK M2 DEF D2 EEE  M3 AAA D1   LLL M4 BBB D3 YYY M5 CCC D5 QQQ M6 DDD D4 MMM M7 EEE D5  PAS
    • A. 

      Yes

    • B. 

      No

    • C. 

      Can'y say

  • 25. 
    Ship(BoatId, NbrOfPools, YearMade, Tonage, CompanyId, CompanyName) The only functional dependencies for this table are: BoatId --> NbrOfPools, YearMade, Tonage, CompanyId, CompanyName CompanyId --> CompanyName CompanyName --> CompanyId Which Normal form is the Ship table in?
    • A. 

      1NF

    • B. 

      2NF

    • C. 

      3NF

    • D. 

      BCNF

    • E. 

      Can't say

Related Topics