New ! Computer Science MCQ Practise Tests

12th Standard Computer Science English Medium Database Concepts Reduced Syllabus Important Questions With Answer Key 2021

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:00:00 Hrs
Total Marks : 100

      Multiple Choice Questions


    15 x 1 = 15
  1. Who developed ER model?

    (a)

    Chen

    (b)

    EF Codd

    (c)

    Chend

    (d)

    Chand

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

    (a)

    Word Processor

    (b)

    Spreadsheet

    (c)

    Programming language

    (d)

    Database

  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 allows users to store, process and analyze data easily?

    (a)

    My SQL

    (b)

    Relational Algebra

    (c)

    Datamodels

    (d)

    DBMS

  5. Which of the following provided an interface to perform various operations to create a database, storing and updating data?

    (a)

    SQL

    (b)

    DBA

    (c)

    DBMS

    (d)

    Algebra

  6. Which of the following is not an example of DBMS?

    (a)

    Foxpro

    (b)

    Dbase

    (c)

    CoBoL

    (d)

    Ms-Access

  7. Which of the following makes the data more meaningful and connected in the database?

    (a)

    Information

    (b)

    Security

    (c)

    Relationship

    (d)

    Data models

  8. 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

  9. Which of the following DBMS components that manage databases to take backups, report generation?

    (a)

    Square

    (b)

    Hardware

    (c)

    Data

    (d)

    Procedures

  10. Which of the following used to write commands to update and delete data stored in database?

    (a)

    Procedures

    (b)

    Methods

    (c)

    Database Access language

    (d)

    Hardware/software

  11. Which of the following is a simple abstraction of complex real world data gathering environment?

    (a)

    Data redundancy

    (b)

    Data consistency

    (c)

    Data abstraction

    (d)

    Data model

  12. The basic structure of data in relational model is

    (a)

    Tables

    (b)

    rows

    (c)

    columns

    (d)

    tuples

  13. Who manages the complete database management system?

    (a)

    End user

    (b)

    DBA

    (c)

    DB designer

    (d)

    software developer

  14. Who are the one responsible for identifying the data to be stored in the data base?

    (a)

    DBA

    (b)

    Application programmers

    (c)

    End user

    (d)

    Database designers

  15. How many types of relationships used in a database?

    (a)

    3

    (b)

    5

    (c)

    2

    (d)

    4

    1. 2 Marks


    11 x 2 = 22
  16. Mention few examples of a database.

  17. List some examples of RDBMS.

  18. What is data consistency?

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

  20. What is normalization?

  21. What is database?

  22. Differentiate data and itiformation.

  23. List the characteristics of DBMS.

  24. List the types of RDBMS software.

  25. What is E F Codd rules?

  26. Write a note on
    (i) SELECT Operation
    (ii) PROJECT Operation

    1. 3 Marks


    11 x 3 = 33
  27. What is the difference between Select and Project command?

  28. What is the role of DBA?

  29. Explain Cartesian Product with a suitable example.

  30. Explain Object Model with example.

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

  32. What does the term database refers?

  33. Write a note on DBMS or write a note on a software that allows us to create, define and manipulate database.

  34. Write the advantages of DBMS.

  35. List the components of DBMS

  36. Write a note on database structure.

  37. Fill up the blank.
    (I) A table is known as a _____________
    (ii) A table row is known as a __________
    (iii) A table column is known as a ________

    1. 5 Marks


    6 x 5 = 30
  38. Explain the different types of data model.

  39. Explain the different types of relationship mapping.

  40. Differentiate DBMS and RDBMS.

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

  42. Explain the characteristics of DBMS.

  43. Explain the components of DBMS

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

TN 12th Standard Computer Science free Online practice tests

Reviews & Comments about 12th Standard Computer Science English Medium Database Concepts Reduced Syllabus Important Questions With Answer Key 2021

Write your Comment