New ! Computer Science MCQ Practise Tests



Structured Query Language Three and Five Marks Questions

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 00:45:00 Hrs
Total Marks : 40
    5 x 3 = 15
  1. What is a constraint? Write short note on Primary key constraint.

  2. Write a SQL statement to modify the student table structure by adding a new field.

  3. Write any three DDL commands.

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

  5. Write a SQL statement using DISTINCT keyword.

  6. 5 x 5 = 25
  7. Write the different types of constraints and their functions.

  8. Consider the following employee table. Write SQL commands for the qtns.(i) to (v).

    EMP CODE NAME DESIG PAY ALLOWANCE
    S1001 Hariharan Supervisor 29000 12000
    P1002 Shaji Operator 10000 5500
    P1003 Prasad Operator 12000 6500
    C1004 Manjima Clerk 8000 4500
    M1005 Ratheesh Mechanic 20000 7000

    (i) To display the details of all employees in descending order of pay.
    (ii) To display all employees whose allowance is between 5000 and 7000.
    (iii) To remove the employees who are mechanic.
    (iv) To add a new row.
    (v) To display the details of all employees who are operators.

  9. What are the components of SQL? Write the commands in each.

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

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

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

Reviews & Comments about 12th Computer Science - Structured Query Language Three and Five Marks Questions

Write your Comment