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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum