Database Management System MCQs Set-12

PropellerAds
  1. 1. It is better to use files than a DBMS when there are
    • Stringent real-time requirements.
    • Multiple users wish to access the data.
    • Complex relationships among data.
    • All of the above.
  2. 2. The conceptual model is
    • dependent on hardware.
    • dependent on software.
    • dependent on both hardware and software .
    • independent of both hardware and software.
  3. 3. What is a relationship called when it is maintained between two entities?
    • Unary 
    • Binary
    • Ternary 
    • Quaternary
  4. 4. Which of the following operation is used if we are interested in only certain columns of a table?
    • Projection
    • SELECTION
    • UNION
    • JOIN
  5. 5. Which of the following is a valid SQL type?
    • CHARACTER 
    • NUMERIC
    • FLOAT 
    • All of the above
  6. 6. The RDBMS terminology for a row is
    • tuple
    • relation
    • attribute
    • degree
  7. 7. Which of the following operations need the participating relations to be union compatible?
    • UNION 
    • INTERSECTION
    • DIFFERENCEqq 
    • All of the above
  8. 8. The full form of DDL is
    • Dynamic Data Language
    • Detailed Data Language
    • Data Definition Language
    • Data Derivation Language
  9. 9. Which of the following is an advantage of view?
    • Data security
    • Derived columns
    • Hiding of complex queries
    • All of the above
  10. 10. Which of the following is a legal expression in SQL?
    • SELECT NULL FROM EMPLOYEE;
    • Select name from employee
    • Select name from employee WHERE SALARY = NULL;
    • None of the above

Practice Now – Database Management System Online tests