New ! Computer Science MCQ Practise Tests



Structured Query Language Two Marks Questions

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 00:45:00 Hrs
Total Marks : 30
    15 x 2 = 30
  1. Write a query that selects all students whose age is less than 18 in order wise.

  2. Differentiate Unique and Primary Key constraint

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

  4. Which component of SQL lets insert values in tables and which lets to create a table?

  5. What is the difference between SQL and MYSQL?

  6. What are two basic types of DML.

  7. List the SQL DML commands.

  8. Define TCL.

  9. Differentiate BETWEEN AND NOT BETWEEN keywords.

  10. Differentiate IN and NOT IN keywords.

  11. How will search NULL values in a field? Give example.

  12. Write the syntax of ORDER by clause used in SELECT command.

  13. Define Primary Key Constraint.

  14. Write the syntax of GROUP BY and HAVING clause.

  15. How will you include aggregate function on the group created in a table using GROUP BY clause?

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

Reviews & Comments about Class 12th Computer Science - Structured Query Language Two Marks Questions

Write your Comment