Structured Query Language (SQL) Model Question Paper

12th Standard EM

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:30:00 Hrs
Total Marks : 40
    5 x 1 = 5
  1. Which commands provide definitions for creating table structure, deleting relations, and modifying relation schemas.

    (a)

    DDL

    (b)

    `DML

    (c)

    DCL

    (d)

    DQL

  2. Which command lets to change the structure of the table?

    (a)

    SELECT

    (b)

    ORDER BY

    (c)

    MODIFY

    (d)

    ALTER

  3. The clause used to sort data in a database

    (a)

    SORT BY

    (b)

    ORDER BY

    (c)

    GROUP BY

    (d)

    SELECT

  4. Which of the following language was designed for managing and accessing data in RDBMS?

    (a)

    DBMS

    (b)

    DDL

    (c)

    DML

    (d)

    SQL

  5. The specific related information about every record in the table is maintained by

    (a)

    language

    (b)

    relation

    (c)

    tuple

    (d)

    field

  6. 8 x 2 = 16
  7. Differentiate Unique and Primary Key constraint

  8. Write the difference between table constraint and column constraint?

  9. What is the difference between SQL and MySQL?

  10. What is SQL?

  11. What is RDBMS?

  12. What is the use of WAMP?

  13. Define TCL.

  14. Write the syntax of creating table in database.

  15. 3 x 3 = 9
  16. Write any three DDL commands.

  17. Write the use of Savepoint command with an example.

  18. List the data types used in SQL.

  19. 2 x 5 = 10
  20. What are the components of SQL? Write the commands in each.

  21. Write a SQL statement to create a table for employee having any five fields and create a table constraint for the employee table.

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

TN 12th Standard EM Computer Science free Online practice tests

Reviews & Comments about 12th Standard Computer Science - Structured Query Language (SQL) Model Question Paper

Write your Comment