New ! Computer Science MCQ Practise Tests



Database Concepts Model Question Paper 1

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:00:00 Hrs
Total Marks : 50
    5 x 1 = 5
  1. Which of the following is an RDBMS?

    (a)

    Dbase

    (b)

    Foxpro

    (c)

    Microsoft Access

    (d)

    SQLite

  2. What symbol is used for SELECT statement?

    (a)

    σ

    (b)

    Π

    (c)

    X

    (d)

    Ω

  3. Which of the following is an organized collection of data, which can be stared and a cersed through computer system

    (a)

    Database

    (b)

    Worksheet

    (c)

    DBMS

    (d)

    Information

  4. Which of the following can be a software or hardware based, with one sole purpose of storiing data?

    (a)

    DBMS

    (b)

    Database

    (c)

    Object

    (d)

    SQL

  5. Which of the following divides the data in such a way that repetition of data is minimum in the database?

    (a)

    Segregation

    (b)

    Normalisation

    (c)

    Integrity

    (d)

    Consistency

  6. 5 x 2 = 10
  7. Mention few examples of a database.

  8. What is the difference between Hierarchical and Network data model?

  9. What is normalization?

  10. Differentiate data and information.

  11. List the types of RDBMS software.

  12. 5 x 3 = 15
  13. What is the role of DBA?

  14. Explain Object Model with example.

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

  16. Explain the data model that represent parent child relationship.

  17. Write a short note on the database model, in which relationship are created by dividing the object into entity.

  18. 4 x 5 = 20
  19. Explain the different types of data model.

  20. Differentiate DBMS and RDBMS.

  21. Explain the different operators in Relational algebra with suitable examples.

  22. Explain the components of DBMS.

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

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

Write your Comment