dbms-mcqs - Set (4)

Correct Answer: Orange && Worng Answer: Red

1. Dashed ellipse are used to represent which attribute ?

  • (A). Simple attribute
  • (B). Base attribute
  • (C). Derived attribute
  • (D). Descriptive attribute
    • View Answer

    Explanation: Not Avilable

    2. Data is ______ information?

  • (A). Raw
  • (B). Polished
  • (C). Computer output
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    3. Create table is the ______ command.

  • (A). DDL
  • (B). DML
  • (C). DQL
  • (D). DCL
    • View Answer

    Explanation: Not Avilable

    4. Which of the following is a database administrator’s function ?

  • (A). Database design
  • (B). Performing monitoring
  • (C). User coordination
  • (D). All of the above
    • View Answer

    Explanation: Not Avilable

    5. ER represents the relationship between

  • (A). Attributes
  • (B). DATA
  • (C). Entities
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    6. A candidate key is a subset of

  • (A). Primary key
  • (B). Foreign key
  • (C). Super key
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    7. The relational model represents the database as a collection of

  • (A). Entities
  • (B). Relations
  • (C). Database
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    8. The process of designating subgrouping within an entity set is called –

  • (A). Specialization
  • (B). Generalization
  • (C). Aggregation
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    9. The entity integrity constraint states that no primary key value can be

  • (A). Zero
  • (B). One
  • (C). Null
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    10. For each attribute there is set of permitted valued called

  • (A). Tuple
  • (B). Row
  • (C). Domain
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    11. Second normal form(2NF) is based on the concept of –

  • (A). Transitive
  • (B). Full functional dependency
  • (C). Both
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    12. Normalization is used for –

  • (A). Eliminating redundant data
  • (B). Providing security
  • (C). Maintenance of database
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    13. Decomposition should always be

  • (A). Lossy
  • (B). Lossless
  • (C). Both
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    14. A functional dependency is basically a constraint between sets of attributes from the database.

  • (A). Two
  • (B). Three
  • (C). Four
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    15. The lowest level of data abstraction is

  • (A). Logical
  • (B). Physical
  • (C). View
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    16. Double rectangles are used to represent ______ entity set.

  • (A). Strong
  • (B). Weak
  • (C). Double
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    17. Two phase lacking does not ensure freedom from ______

  • (A). Data security
  • (B). Deadlock
  • (C). Data loss
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    18. Which of the following is DCL command ?

  • (A). RENAME
  • (B). GRANT
  • (C). UPDATE
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    19. Which of the following operation is used if we are instrested in only certain columns of a table?

  • (A). Projection
  • (B). Selection
  • (C). Union
  • (D). Join
    • View Answer

    Explanation: Not Avilable

    20. DBMS helps achieve :

  • (A). Data independence
  • (B). Centralized control of data
  • (C). Neither (a) nor (b)
  • (D). Both (a) and (b)
    • View Answer

    Explanation: Not Avilable

    Categories

    C Programming MCQsC++ Programming MCQsJAVA MCQsVisual Basic MCQsData Structure MCQsSoftware Package MCQsComputer Organization and Architecture MCQsOperating System MCQsDigital Electronics MCQsDBMS MCQsSystem Analysis and Management Information System MCQsSystem Maintenance MCQsData Communication and Networking MCQsInternet & Web Technology MCQsSoftware Engineering MCQsManagement (Common) MCQsSystem Software MCQsComputer Graphics MCQsArtificial Intelligence & Expert System MCQsE-Commerce MCQsMultimedia MCQsPower Electronics MCQsTesting & Maintenance Electrical Machine MCQsAutomatic Control System MCQsAdvance Communication System MCQsDigital Electronics MCQs