New ! Computer Applications MCQ Practise Tests



Introduction to Database Management System Book Back Questions

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Applications

Time : 00:45:00 Hrs
Total Marks : 30
    5 x 1 = 5
  1. Which language is used to request information from a Database?

    (a)

    Relational

    (b)

    Structural

    (c)

    Query

    (d)

    Compiler

  2. The _____ diagram gives a logical structure of the database graphically?

    (a)

    Entity-Relationship

    (b)

    Entity

    (c)

    Architectural Representation

    (d)

    Database

  3. Communication is established with MySQL using

    (a)

    SQL

    (b)

    Network calls

    (c)

    Java

    (d)

    API’s

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

    (a)

    MySQL Client

    (b)

    MySQL Server

    (c)

    SQL

    (d)

    Server Daemon Program

  5. The structure representing the organizational view of entire database is known as ______ in MySQL database.

    (a)

    Schema

    (b)

    View

    (c)

    Instance

    (d)

    Table

  6. 3 x 2 = 6
  7. Define Data Model and list the types of data model used.

  8. What are the ACID properties?

  9. What is Relationship and List its types.

  10. 3 x 3 = 9
  11. Explain on Evolution of DBMS.

  12. Discuss on Cardinality in DBMS.

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

  14. 2 x 5 = 10
  15. Discuss on various database models available in DBMS.

  16. Discuss in detail on various types of attributes in DBMS.

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

Reviews & Comments about 12th Standard Computer Applications - Introduction to Database Management System Book Back Questions

Write your Comment