New ! Computer Applications MCQ Practise Tests

Introduction to Database Management System Model Question Paper

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Applications

Time : 01:00:00 Hrs
Total Marks : 50
    5 x 1 = 5
  1. __________ represents a “tuple” in a relational database?

    (a)

    Table

    (b)

    Row

    (c)

    Column

    (d)

    Object

  2. Communication is established with MySQL using

    (a)

    SQL

    (b)

    Network calls

    (c)

    Java

    (d)

    API’s

  3. Which is the MySQL instance responsible for data processing?

    (a)

    MySQL Client

    (b)

    MySQL Server

    (c)

    SQL

    (d)

    Server Daemon Program

  4. Which of the following are the limitations of system

    (a)

    Data Duplication

    (b)

    High Maintenance

    (c)

    Security

    (d)

    All of the above

  5. ___________ 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

  6. 5 x 2 = 10
  7. Define Single and multi valued attributes.

  8. What is view in SQL?

  9. What are the various methods to access file system?

  10. What do you mean by table in Relational database model?

  11. What is XAMPP?

  12. 5 x 3 = 15
  13. List any 5 privileges available in MySQL for the User.

  14. Write few commands used by DBA to control the entire database.

  15. List few commonly used databases.

  16. What are the major parts to form a database

  17. Write a short note on Row (or Record or tuple)

  18. 4 x 5 = 20
  19. List the basic concepts of ER Model with suitable example

  20. Explain the DDL command of their functions in SQL.

  21. Explain the following
    1. Primary Key
    2. Foreign Key
    3. Candidate Key
    4. Super Key
    5. Composite key

  22. Tabulate the ER diagram notations

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

TN 12th Standard Computer Applications free Online practice tests

Reviews & Comments about 12th Computer Applications - Introduction to Database Management System Model Question Paper

Write your Comment