dbms-mcqs - Set (2)

Correct Answer: Orange && Worng Answer: Red

1. The database schema is written in

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

    Explanation: Not Avilable

    2. In the architecture of a database system external level is the

  • (A). Physical level
  • (B). Logical level
  • (C). Conceptual level
  • (D). View level
    • View Answer

    Explanation: Not Avilable

    3. In a Hierarchical level model records are organized as

  • (A). Graph
  • (B). List
  • (C). Links
  • (D). Tree
    • View Answer

    Explanation: Not Avilable

    4. The language used in application programs to request data from the DBMS is refered to as the

  • (A). DML
  • (B). DDL
  • (C). VDL
  • (D). SDL
    • View Answer

    Explanation: Not Avilable

    5. Key to represent relationship between tables is called

  • (A). Primary key
  • (B). Secondary key
  • (C). Foreign key
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    6. Hierarchical model is also called

  • (A). Tree structure
  • (B). Plex structure
  • (C). Normalize structure
  • (D). Table structure
    • View Answer

    Explanation: Not Avilable

    7. Which of the system uses Multidimensional data analysis?

  • (A). DSS
  • (B). MIS
  • (C). ESS
  • (D). All of the above
    • View Answer

    Explanation: Not Avilable

    8. A view of database that appears to an application program is known as :

  • (A). Schema
  • (B). Subschema
  • (C). Virtual table
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    9. An abstraction concept for building composite object from their component object is called :

  • (A). Specialization
  • (B). Normalization
  • (C). Generalization
  • (D). Aggregation
    • View Answer

    Explanation: Not Avilable

    10. A set of objects that share a common structure and a common behavior is called

  • (A). Object
  • (B). Class
  • (C). Entity
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    11. Every weak entity set can be converted into a strong entity set by :

  • (A). Using generalization
  • (B). Adding appropriate attributes
  • (C). Using aggregation
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    12. The number of entities to which another entity can be associated via a relationship set is expressed as :

  • (A). Entity
  • (B). Cardinality
  • (C). Schema
  • (D). Attributes
    • View Answer

    Explanation: Not Avilable

    13. Relations produced from an ER model will always be in :

  • (A). First normal form
  • (B). Second normal form
  • (C). Third normal form
  • (D). Fourth normal form
    • View Answer

    Explanation: Not Avilable

    14. In ER model the details of the entities are hidden from the user. This process is called

  • (A). Generalization
  • (B). Specialization
  • (C). Abstraction
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    15. In a relational database a referential integrity constraint can be specified with the help of

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

    Explanation: Not Avilable

    16. 4NF is designed to cope with

  • (A). Transitive dependency
  • (B). Join dependency
  • (C). Multi valued dependency
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    17. Which command is used to remove all rows from a table ?

  • (A). Delete
  • (B). Remove
  • (C). Turncate
  • (D). Both (a) and (b)
    • View Answer

    Explanation: Not Avilable

    18. Which of the following is an aggregate function in SQL ?

  • (A). Union
  • (B). Like
  • (C). Group By
  • (D). Max
    • View Answer

    Explanation: Not Avilable

    19. Which command is used to add a column to an existing table ?

  • (A). Create
  • (B). Update
  • (C). Alter
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    20. A deadlock exists in the system if and only if the wait for graph :

  • (A). Has a cycle in it
  • (B). Has a path from first node to last node
  • (C). is a tree
  • (D). None of the above
    • 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