Database Management System MCQs Set-5

PropellerAds
  1. 1. The full form of DDL is
    • Dynamic Data Language
    • Detailed Data Language
    • Data Definition Language
    • Data Derivation Language
  2. 2. Which of the following is an advantage of view?
    • Data security
    • Derived columns
    • Hiding of complex queries
    • All of the above
  3. 3. 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
  4. 4. A set of possible data values is called
    • attribute
    • degree
    • tuple
    • domain
  5. 5. Which of the operations constitute a basic set of operations for manipulating relational data?
    • Predicate calculus
    • Relational calculus
    • Relational algebra
    • None of the above
  6. 6. Which of the following is another name for weak entity?
    • Child
    • Owner
    • Dominant
    • All of the above
  7. 7. Which of the following database object does not physically exist?
    • base table
    • index
    • view
    • none of the above
  8. 8. Which of the following is record based logical model?
    • Network Model
    • Object oriented model
    • E-R Model
    • None of these
  9. 9. The natural join is equal to :
    • Cartesian Product
    • Combination of Union and Cartesian product
    • Combination of selection and Cartesian product
    • Combination of projection and Cartesian product
  10. 10. Which one of the following is not true for a view:
    • View is derived from other tables.
    • View is a virtual table.
    • A view definition is permanently stored as part of the database.
    • View never contains derived columns.

Practice Now – Database Management System Online tests