New ! Computer Science MCQ Practise Tests



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

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

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

      Multiple Choice Questions


    20 x 1 = 20
  1. Which of the following is an organized collection of data?

    (a)

    Word Processor

    (b)

    Spreadsheet

    (c)

    Programming language

    (d)

    Database

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

  3. Which of the following a data contain?

    (a)

    Character

    (b)

    text

    (c)

    Word

    (d)

    Number

    (e)

    All of these

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

  5. Which of the following provides protection and security to the databases?

    (a)

    My SQL

    (b)

    DBMS

    (c)

    Oracel

    (d)

    CSV

  6. Which of the following is not a DBMS component?

    (a)

    Hardware/Square

    (b)

    Data

    (c)

    Procedures

    (d)

    Data model

  7. Which of the following DBMS components controls everything in a database?

    (a)

    Hardware

    (b)

    Square

    (c)

    Methods

    (d)

    Procedures

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

  9. How many types of data models are there?

    (a)

    4

    (b)

    3

    (c)

    5

    (d)

    7

  10. Which of fhe following is not a type of data model?

    (a)

    Hierarchical model

    (b)

    Entity Relationship model

    (c)

    Object model

    (d)

    Redundancey model

  11. Which database model is simple and easy to design logical view of database?

    (a)

    Hierarchical

    (b)

    Object

    (c)

    Relational

    (d)

    ER model

  12. DBA expansion is

    (a)

    Data Base Analyst

    (b)

    Data Base Administrators

    (c)

    Digital Bound Administrations

    (d)

    Database Analyser

  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. Each column in a table represents a ___________

    (a)

    Record

    (b)

    Data

    (c)

    Field

    (d)

    Method

  16. __________ database model is an extended form of hierarchical data model

    (a)

    object

    (b)

    Relational

    (c)

    ER model

    (d)

    Network

  17. __________ data model provides a clear modular structure of a data

    (a)

    object

    (b)

    Relational

    (c)

    Hierarchical/ER-model

    (d)

    All of these

  18. Doctor and Patient is an example of ________ database model

    (a)

    ER-model

    (b)

    Relation

    (c)

    Object

    (d)

    Hierarchical

  19. In ____________ data model, the data stores in the form of classes and inheritance.

    (a)

    Hierarchical

    (b)

    Entity relationship

    (c)

    Object

    (d)

    Network

  20. ___________ is a computer based record keeping system

    (a)

    Data model

    (b)

    Data relationships

    (c)

    DBMS

    (d)

    Entity relationship

    1. 2 Marks


    10 x 2 = 20
  21. Mention few examples of a database.

  22. List some examples of RDBMS.

  23. What is data consistency?

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

  25. What is database?

  26. Differentiate data and information.

  27. List the characteristics of DBMS.

  28. List the types of RDBMS software.

  29. What is E F Codd rules?

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

    1. 3 Marks


    10 x 3 = 30
  31. What does the term database refers?

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

  33. Write a note on database structure.

  34. Write the importance of using data model.

  35. List the types of data model.

  36. Write a short note on Relational data model.

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

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

  39. List the types of DBMS users.

  40. Write the symbol used for the following.
    (i) SELECT
    (ii) PROJECT
    (iii) Union
    (iv) Intersection
    (v) Difference
    (vi) PRODUCT

    1. 5 Marks


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

  42. Explain the different types of relationship mapping.

  43. Differentiate DBMS and RDBMS.

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

  45. Explain the characteristics of DBMS.

  46. Explain the components of DBMS.

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

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

Write your Comment