New ! Computer Science MCQ Practise Tests



Structured Query Language - Two Marks Study Materials

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:00: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. List few RDBMS packages.

  7. How will you create database and work with the database? Give example.

  8. Define Data Definition Language.

  9. What are two basic types of DML.

  10. Define TCL.

  11. Write a note on data query language.

  12. Differentiate IN and NOT IN keywords.

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

  14. How will you filter the records in a table? Give an example.

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

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

Reviews & Comments about 12th Computer Science - Structured Query Language - Two Marks Study Materials

Write your Comment