Home / CSE MCQs / Oracle Database MCQs :: Oracle Database Planning Oracle Applications

CSE MCQs :: Oracle Database MCQs

  1. E-R model uses this symbol to represent weak entity set ?
  2. A.
    Dotted rectangle
    B.
    Diamond
    C.
    Doubly outlined rectangle
    D.
    None of the Mentioned

  3. Identify the criteria for designing database from the point of view of user
  4. A.
    No redundancy
    B.
    No inapplicable attributes
    C.
    Uniformity in naming & definitions of the data items
    D.
    All of the Mentioned

  5. The "curse of dimensionality relates to which problem of using operational data for BI reporting?
  6. A.
    Dirty data
    B.
    Inconsistent data
    C.
    Too much data
    D.
    Non-integrated data

  7. Business Intelligence (BI) reporting systems cannot do which of the following operations?
  8. A.
    Filter data
    B.
    Group data
    C.
    Modify data
    D.
    Both filter and group data

  9. What is true about Unique and primary key?
  10. A.
    Unique can have multiple NULL values but Primary can't have.
    B.
    Unique can have single NULL value but Primary can't have even single.
    C.
    Both can have duplicate values
    D.
    None of the Mentioned

  11. A table is in 3NF if it is in 2NF and if it has no ____________
  12. A.
    Functional Dependencies
    B.
    Transitive Dependencies
    C.
    Trivial Functional Dependency
    D.
    Multivalued Dependencies

  13. In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _________ key.
  14. A.
    Candidate
    B.
    Join
    C.
    Functional
    D.
    None of the Mentioned

  15. The language used application programs to request data from the DBMS is referred to as the
  16. A.
    DML
    B.
    DDL
    C.
    Query language
    D.
    All of the Mentioned

  17. Which of the following is the oldest database model?
  18. A.
    Relational
    B.
    Deductive
    C.
    Physical
    D.
    Network

  19. The relationship between DEPARTMENT and EMPLOYEE is a
  20. A.
    One-to-one relationship
    B.
    One-to-many relationship
    C.
    Many-to-many relationship
    D.
    Many-to-one relationship