dbms-mcqs - Set (1)

Correct Answer: Orange && Worng Answer: Red

1. DBA stands for

  • (A). Data Bank Access
  • (B). Database Access
  • (C). Database Administrator
  • (D). Database Assistant
    • View Answer

    Explanation: Not Avilable

    2. In ER diagram, the total participation by entities is represented as ______

  • (A). Dashed line
  • (B). Rectangle
  • (C). Double rectangle
  • (D). Double line
    • View Answer

    Explanation: Not Avilable

    3. The feature that database allows to access only certain records in database is ______

  • (A). Queries
  • (B). Reports
  • (C). Forms
  • (D). Tables
    • View Answer

    Explanation: Not Avilable

    4. Which of the following is not a property of transactions?

  • (A). Atomicity
  • (B). Concurrency
  • (C). Isolation
  • (D). Durability
    • View Answer

    Explanation: Not Avilable

    5. Relational Algebra does not have

  • (A). Selection operator
  • (B). Projection operator
  • (C). Aggregation operator
  • (D). Division operator
    • View Answer

    Explanation: Not Avilable

    6. Tree structure are used to store data in

  • (A). Network model
  • (B). Relation model
  • (C). Hierarchical model
  • (D). File based system
    • View Answer

    Explanation: Not Avilable

    7. The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

  • (A). Procedural DML
  • (B). Non-procedural DML
  • (C). Procedural DDL
  • (D). Non-procedural DDL
    • View Answer

    Explanation: Not Avilable

    8. The rule that a value of a foreign key must appear as a value of some specific table is called a

  • (A). Referential constraint
  • (B). Index
  • (C). Integrity constraint
  • (D). Functional dependency
    • View Answer

    Explanation: Not Avilable

    9. In an ER diagram double lines indicate

  • (A). Total participation
  • (B). Multiple participation
  • (C). Cardinality N
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    10. Fifth Normal form is concerned with

  • (A). Functional dependency
  • (B). Multivalued dependency
  • (C). Join dependency
  • (D). Domain key
    • View Answer

    Explanation: Not Avilable

    11. The metadata is created by the

  • (A). DML compiler
  • (B). DML pre-processor
  • (C). DDL interpreter
  • (D). Query interpreter
    • View Answer

    Explanation: Not Avilable

    12. When an ER diagram is mapped to tables, the representation is redundant for

  • (A). Weak entity sets
  • (B). Weak relationship sets
  • (C). Strong entity sets
  • (D). Strong relationship sets
    • View Answer

    Explanation: Not Avilable

    13. If the closure of an attribute set is the entire relation then the attribute set is a

  • (A). Superkey
  • (B). Candidate key
  • (C). Primary key
  • (D). Not a key
    • View Answer

    Explanation: Not Avilable

    14. The keyword to eliminate duplicate rows from the query result in SQL is

  • (A). DISTINCT
  • (B). NO DUPLICATE
  • (C). UNIQUE
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    15. The information stored in the catalog of a database is called

  • (A). Distributed data
  • (B). Raw data
  • (C). Encapsulated data
  • (D). Meta
    • View Answer

    Explanation: Not Avilable

    16. The method of access which uses key transformation is known as

  • (A). Direct
  • (B). Hash
  • (C). Random
  • (D). Sequential
    • View Answer

    Explanation: Not Avilable

    17. Data independence means

  • (A). Data is defined separately and not included in programs
  • (B). Programs are not dependent on the physical attributes of data
  • (C). Programs are not dependent on the logical attributes of data
  • (D). Both (b) and (c)
    • View Answer

    Explanation: Not Avilable

    18. The statement in SQL which allows to change the definition of a table is

  • (A). Alter
  • (B). Update
  • (C). Create
  • (D). Select
    • View Answer

    Explanation: Not Avilable

    19. SET concept is used in

  • (A). Network model
  • (B). Hierarchical model
  • (C). Relational model
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    20. ______ produces the relation that has attributes of R1 and R2

  • (A). Cartesian product
  • (B). Difference
  • (C). Intersection
  • (D). Product
    • 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