New ! Computer Science MCQ Practise Tests



Database Concepts Model Question Paper

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 02:00:00 Hrs
Total Marks : 50
    6 x 1 = 6
  1. What is the acronym of DBMS?

    (a)

    DataBase Management Symbol

    (b)

    Database Managing System

    (c)

    DataBase Management System

    (d)

    DataBasic Management System

  2. What type of relationship does hierarchical model represents?

    (a)

    one-to-one

    (b)

    one-to-many

    (c)

    many-to-one

    (d)

    many-to-many

  3. Which of the following is an RDBMS?

    (a)

    Dbase

    (b)

    Foxpro

    (c)

    Microsoft Access

    (d)

    SQLite

  4. A tuple is also known as

    (a)

    table

    (b)

    row

    (c)

    attribute

    (d)

    field

  5. Who developed ER model?

    (a)

    Chen

    (b)

    EF Codd

    (c)

    Chend

    (d)

    Chand

  6. Which of the following is an organized collection of data?

    (a)

    Word Processor

    (b)

    Spreadsheet

    (c)

    Programming language

    (d)

    Database

  7. 2 x 2 = 4
  8. Choose the incorrect statement from the following
    (a) IBM developed Hierarchical data model
    (b) EF Codd proposed the Relational database model
    (c) Network model represents the data in many to one relationships
    (d) Chen developed the ER model

  9. Choose the incorrect statement from the following
    (i) End users are the one who manage the license keys.
    (ii) DBA are the one who stores, retrieve, update and delete data.
    (iii) Choosing appropriate structures to represent data and store the data in the database is done by database designers.
    (iv) Application programmers are involved in developing and designing the parts of DBMS
    (a) i and ii
    (b) iii and iv
    (c) i and iii
    (d) ii and iv

  10. 6 x 2 = 12
  11. Mention few examples of a database.

  12. List some examples of RDBMS.

  13. What is data consistency?

  14. What is normalization?

  15. What is database?

  16. What is E F Codd rules?

  17. 6 x 3 = 18
  18. What is the difference between Select and Project command?

  19. What is the role of DBA?

  20. Explain Object Model with example.

  21. Write a note on different types of DBMS users.

  22. List the components of DBMS

  23. List the types of DBMS users.

  24. 2 x 5 = 10
  25. Explain the different types of data model.

  26. Differentiate DBMS and RDBMS.

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

Reviews & Comments about 12th Standard Computer Science - Database Concepts Model Question Paper

Write your Comment