Structured Query Language Model Question Paper

12th Standard EM

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:00:00 Hrs
Total Marks : 40
    5 x 1 = 5
  1. Which command lets to change the structure of the table?

    (a)

    SELECT

    (b)

    ORDER BY

    (c)

    MODIFY

    (d)

    ALTER

  2. The command to delete a table is

    (a)

    DROP

    (b)

    DELETE

    (c)

    DELETE ALL

    (d)

    ALTER TABLE

  3. Which of the following is a standard programming language to access and manipulate database?

    (a)

    MySQL

    (b)

    SQL

    (c)

    PHP

    (d)

    Python

  4. Which of the following is a collection of data entries?

    (a)

    Database

    (b)

    Table

    (c)

    Dbase

    (d)

    SQL

  5. Which of the following processing skills of SQL provides commands for defining relation schemes?

    (a)

    MySQL

    (b)

    DDL

    (c)

    DML

    (d)

    DCL

  6. 5 x 2 = 10
  7. Write the difference between table constraint and column constraint?

  8. What is the difference between SQL and MySQL?

  9. What is the use of WAMP?

  10. Define Data Manipulation Language.

  11. Define TCL.

  12. 5 x 3 = 15
  13. Write a SQL statement to modify the student table structure by adding a new field.

  14. Write any three DDL commands.

  15. How will set a primary key for more than one field? Explain with example.

  16. How will you generate queries and retrieve data from the table? Explain?

  17. Write the different categories of SQL commands.

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

  20. Explain ALTER command in detail.

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

TN 12th Standard EM Computer Science free Online practice tests

Reviews & Comments about 12th Computer Science - Structured Query Language Model Question Paper

Write your Comment