dbms-mcqs - Set (5)

Correct Answer: Orange && Worng Answer: Red

1. When a primary key is define in the table, DBMS automatically creates a _______ on a primary key column.

  • (A). Unique Index
  • (B). Sequence
  • (C). Trigger
  • (D). Synonym
    • View Answer

    Explanation: Not Avilable

    2. Which normal form is the partial dependency removed ?

  • (A). First
  • (B). Second
  • (C). Third
  • (D). BCNF
    • View Answer

    Explanation: Not Avilable

    3. Which is major data structure used in RDBMS ?

  • (A). Trees
  • (B). Stacks
  • (C). Graph
  • (D). Array
    • View Answer

    Explanation: Not Avilable

    4. The view of Total Database content is :

  • (A). Conceptual view
  • (B). Internal view
  • (C). External view
  • (D). Physical view
    • View Answer

    Explanation: Not Avilable

    5. Which is not Aggregate function ?

  • (A). Count
  • (B). Avg
  • (C). Create
  • (D). Max
    • View Answer

    Explanation: Not Avilable

    6. Under which category do the commands CREATE and ALTER belong to :

  • (A). DML
  • (B). DDL
  • (C). UML
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    7. ACID stands for :

  • (A). Atomicity, Consistency, Isolation, Durability
  • (B). Atomicity, Concurrency, Isolation, Duplicity
  • (C). Aggregation, Consistency, Isolation, Durability
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    8. How many primary key can a table in database ?

  • (A). Only one
  • (B). At least one
  • (C). More than one
  • (D). Any number of
    • View Answer

    Explanation: Not Avilable

    9. Which of the following are properties of entities ?

  • (A). Groups
  • (B). Table
  • (C). Attributes
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    10. Relational Algebra is :

  • (A). DDL
  • (B). Meta Language
  • (C). Procedural Query Language
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    11. The statement in SQL which allows to change the definition of table is :

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

    Explanation: Not Avilable

    12. Count function in SQL returns the number of :

  • (A). Values
  • (B). District Values
  • (C). Groups
  • (D). Columns
    • View Answer

    Explanation: Not Avilable

    13. In an ER diagram Entity set is represented by

  • (A). Ellipse
  • (B). Square
  • (C). Rectangle
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    14. The language used in application program to request data from DBMS is referred as :

  • (A). DML
  • (B). DDL
  • (C). VOL
  • (D). SOL
    • View Answer

    Explanation: Not Avilable

    15. The number of attributes in a relation is called its _______

  • (A). Rows
  • (B). Columns
  • (C). Degree
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    16. Which of the following is not a type of Database ?

  • (A). Hierarchical
  • (B). Relational
  • (C). Network
  • (D). Transition
    • View Answer

    Explanation: Not Avilable

    17. SELECT* from employee is what type of statement:

  • (A). DML
  • (B). DDL
  • (C). View
  • (D). Integrity Constraint
    • View Answer

    Explanation: Not Avilable

    18. The full form of DDL is :

  • (A). Dynamic Data Language
  • (B). Detailed Data Language
  • (C). Data Definition Language
  • (D). Data Definition Language
    • View Answer

    Explanation: Not Avilable

    19. Which database is closest to the users:

  • (A). External
  • (B). Internal
  • (C). Physical
  • (D). Conceptual
    • View Answer

    Explanation: Not Avilable

    20. Which of the following is comparison operator in SQL ?

  • (A). =
  • (B). LIKE
  • (C). BETWEEN
  • (D). All 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