dbms-mcqs - Set (3)

Correct Answer: Orange && Worng Answer: Red

1. The internal schema defines _____ data are organized in physical data storage.

  • (A). How and where
  • (B). View
  • (C). Domain
  • (D). Important
    • View Answer

    Explanation: Not Avilable

    2. The term _____ is used to refer a row.

  • (A). Attribute
  • (B). Tuple
  • (C). Field
  • (D). Instance
    • View Answer

    Explanation: Not Avilable

    3. What is the cardinality of a table with 100 rows and 10 columns?

  • (A). 10
  • (B). 100
  • (C). 1000
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    4. Which of the following is an integrity constraint?

  • (A). Domain Constraint
  • (B). Entity Integrity
  • (C). Referential Integrity
  • (D). All of above
    • View Answer

    Explanation: Not Avilable

    5. _____ is a many-to-one relationship between two sets of attributes of a given relation.

  • (A). Multi-valued dependency
  • (B). Functional dependency
  • (C). Temporal dependency
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    6. Which of the following is an attribute that holds multiple values for a single entity?

  • (A). Simple
  • (B). Composite
  • (C). Derived
  • (D). Multi-valued
    • View Answer

    Explanation: Not Avilable

    7. Which of the following is a top-down process?

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

    Explanation: Not Avilable

    8. A relation is in BCNF if and only if every determinant is :

  • (A). Primary key
  • (B). Super key
  • (C). Candidate key
  • (D). All of above
    • View Answer

    Explanation: Not Avilable

    9. DML is provided for

  • (A). Description of logical structure of database
  • (B). Addition of new structure in the database system
  • (C). Manipulation & processing of database
  • (D). Definition of physical structure of database system
    • View Answer

    Explanation: Not Avilable

    10. Which of the following is DML command?

  • (A). INSERT
  • (B). UPDATE
  • (C). DELETE
  • (D). All of the above
    • View Answer

    Explanation: Not Avilable

    11. The key word DISTINCT is not allowed for _____ function.

  • (A). COUNT()
  • (B). COUNT(*)
  • (C). SUM()
  • (D). AVG()
    • View Answer

    Explanation: Not Avilable

    12. _____ is a technique where transction logs are not required.

  • (A). Defered Update
  • (B). Immediate Update
  • (C). Shadow paging
  • (D). None of the above
    • View Answer

    Explanation: Not Avilable

    13. ODBC stands for

  • (A). Object Database Connectivity
  • (B). Oral Database Connectivity
  • (C). Oracle Database Connectivity
  • (D). Open Database Connectivity
    • View Answer

    Explanation: Not Avilable

    14. The Association between Department and Employee is :

  • (A). One-to-One
  • (B). One-to-Many
  • (C). Many-to-Many
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    15. Repeatation of data is called :

  • (A). Inconsistency
  • (B). Redundency
  • (C). Atomicity
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    16. In 2NF we remove :

  • (A). Repeating groups
  • (B). Transitive dependency
  • (C). Partial functional dependency
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    17. Which of the following is a valid SQL data type ?

  • (A). CHARACTER
  • (B). NUMERIC
  • (C). FLOAT
  • (D). All of the above
    • View Answer

    Explanation: Not Avilable

    18. Which keyword in the GRANT command gives priviledges to all valid users of the DBMS?

  • (A). ALL
  • (B). FULL
  • (C). PUBLIC
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    19. Which of the following is the process by which a user’s identity is checked?

  • (A). Authentication
  • (B). Authorization
  • (C). Access control
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    20. Which is not Aggregate function?

  • (A). COUNT()
  • (B). AVG()
  • (C). SUM()
  • (D). SELECT()
    • 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