Structured Query Language Book Back Questions

12th Standard EM

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 00:45:00 Hrs
Total Marks : 30
    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 command to delete a table is

    (a)

    DROP

    (b)

    DELETE

    (c)

    DELETE ALL

    (d)

    ALTER TABLE

  4. Queries can be generated using

    (a)

    SELECT

    (b)

    ORDER BY

    (c)

    MODIFY

    (d)

    ALTER

  5. The clause used to sort data in a database

    (a)

    SORT BY

    (b)

    ORDER BY

    (c)

    GROUP BY

    (d)

    SELECT

  6. 3 x 2 = 6
  7. Write a query that selects all students whose age is less than 18 in order wise.

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

  9. What is the difference between SQL and MySQL?

  10. 3 x 3 = 9
  11. Write any three DDL commands.

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

  13. Write a SQL statement using DISTINCT keyword.

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

  16. Construct the following SQL statements in the student table-
    (i) SELECT statement using GROUP BY clause.
    (ii) SELECT statement using ORDER BY clause.

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

TN 12th Standard EM Computer Science free Online practice tests

Reviews & Comments about 12th Computer Science - Structured Query Language Book Back Questions

Write your Comment