New ! Computer Applications MCQ Practise Tests

Introduction to Database Management System Model Question Paper 1

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. The structure representing the organizational view of entire database is known as __________ in MySQL database.

    (a)

    Schema

    (b)

    Schema

    (c)

    Instance

    (d)

    Table

  4. DBMS provides to ___________ data

    (a)

    create

    (b)

    retrieve

    (c)

    update

    (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. What is view in SQL?

  8. What is Relationship and List its types.

  9. State few advantages of Relational databases.

  10. What is XAMPP?

  11. What is meant by the Designing of databases?

  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. What are the roles of Database administrator?

  16. What are the major parts to form a database

  17. What are the major the functions performed using SQL?

  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 1

Write your Comment