New ! Computer Applications MCQ Practise Tests



Introduction to Database Management System One Mark Questions

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Applications

Time : 00:30:00 Hrs
Total Marks : 20
    10 x 1 = 10
  1. Which language is used to request information from a Database?

    (a)

    Relational

    (b)

    Structural

    (c)

    Query

    (d)

    Compiler

  2. The _____ diagram gives a logical structure of the database graphically?

    (a)

    Entity-Relationship

    (b)

    Entity

    (c)

    Architectural Representation

    (d)

    Database

  3. An entity set that does not have enough attributes to form primary key is known as

    (a)

    Strong entity set

    (b)

    Weak entity set

    (c)

    Identity set

    (d)

    Owner set

  4. Which of the following is a not a database? 

    (a)

    Oracle

    (b)

    PostgreSQL

    (c)

    SQLite

    (d)

    None of these

  5. DBMS provides to ___________ data

    (a)

    create

    (b)

    retrieve

    (c)

    update

    (d)

    all of the above

  6. Which of the following are the limitations of system

    (a)

    Data Duplication

    (b)

    High Maintenance

    (c)

    Security

    (d)

    All of the above

  7. ___________ is defined as the system's ability to recover all committed transactions during the failure of storage or the system

    (a)

    Durability

    (b)

    Consistency

    (c)

    Concurrency

    (d)

    All of the above

  8. Which of the following is a commercial relational models in use

    (a)

    Oracle

    (b)

    DB2

    (c)

    Postgre SQL

    (d)

    Both a and b

  9. A _________ is a "copy" of a primary key

    (a)

    Candidate Key

    (b)

    Super Key

    (c)

    Foreign Key

    (d)

    Composite Key

  10. A key With more than one attribute to identify rows uniquely in a table is called ___________

    (a)

    Candidate Key

    (b)

    Super Key

    (c)

    Foreign Key

    (d)

    Composite Key

  11. 5 x 1 = 5
  12. ________ is known a predecessor of database system

    A PHP Error was encountered

    Severity: Warning

    Message: A non-numeric value encountered

    Filename: material/details.php

    Line Number: 1002

    ()

    File system

  13. MySQL is a database management system founded by __________

    A PHP Error was encountered

    Severity: Warning

    Message: A non-numeric value encountered

    Filename: material/details.php

    Line Number: 1002

    ()

    Monty Widenius

  14. __________ who takes care of configuration, installation, performance, security and data backup.

    A PHP Error was encountered

    Severity: Warning

    Message: A non-numeric value encountered

    Filename: material/details.php

    Line Number: 1002

    ()

    Database Administrators

  15. _____________ is a web application written in PHP

    A PHP Error was encountered

    Severity: Warning

    Message: A non-numeric value encountered

    Filename: material/details.php

    Line Number: 1002

    ()

    PHPMYADMIN

  16. ___________ tool of MySQL is a web application written in PHP

    A PHP Error was encountered

    Severity: Warning

    Message: A non-numeric value encountered

    Filename: material/details.php

    Line Number: 1002

    ()

    PHPMYADMIN

  17. 5 x 1 = 5
  18. Hierarchical Database

  19. (1)

    IDS

  20. Network Database

  21. (2)

    IMS

  22. Relational Database

  23. (3)

    Attribute

  24. Column

  25. (4)

    Record

  26. Row

  27. (5)

    Oracle

*****************************************

Reviews & Comments about 12th Computer Applications Unit 3 Introduction to Database Management System One Mark Question Paper

Write your Comment