Introduction to Database Management System One Mark Questions

12th Standard EM

    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)

    PostgreSQL

    (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

    ()

    File system

  13. MySQL is a database management system founded by __________

    ()

    Monty Widenius

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

    ()

    Database Administrators

  15. _____________ is a web application written in PHP

    ()

    PHPMYADMIN

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

    ()

    PHPMYADMIN

  17. 5 x 1 = 5
  18. Hierarchical Database

  19. (1)

    Record

  20. Network Database

  21. (2)

    IMS

  22. Relational Database

  23. (3)

    Oracle

  24. Column

  25. (4)

    IDS

  26. Row

  27. (5)

    Attribute

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

TN 12th Standard EM Computer Applications free Online practice tests

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

Write your Comment