New ! Computer Science MCQ Practise Tests

12th Standard Computer Science English Medium Structured Query Language Reduced Syllabus Important Questions 2021

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:00:00 Hrs
Total Marks : 100

      Multiple Choice Questions


    15 x 1 = 15
  1. Which commands provide definitions for creating table structure, deleting relations, and modifying relation schemas.

    (a)

    DDL

    (b)

    `DML

    (c)

    DCL

    (d)

    DQL

  2. The clause used to sort data in a database

    (a)

    SORT BY

    (b)

    ORDER BY

    (c)

    GROUP BY

    (d)

    SELECT

  3. Which of the following language was designed for managing and accessing data in RDBMS?

    (a)

    DBMS

    (b)

    DDL

    (c)

    DML

    (d)

    SQL

  4. SQL stands for

    (a)

    Standard Query Language

    (b)

    Secondary Query Language

    (c)

    Structural Query Language

    (d)

    Standard Question Language

  5. SQL originally called as

    (a)

    DBMS

    (b)

    RDBMS

    (c)

    SQL

    (d)

    SQLITE

  6. Latest SQL standard as of now is

    (a)

    SQL 2008

    (b)

    SQL 2009

    (c)

    SQL 2018

    (d)

    SQL 2.0

  7. The data in RDBMS, is stored in database objects called

    (a)

    Queries

    (b)

    Languages

    (c)

    Relations

    (d)

    Tables

  8. Which component of SQL includes commands to insert) delete and modify tables in database?

    (a)

    DCL

    (b)

    TCL

    (c)

    DDL

    (d)

    DML

  9. DCL stands for

    (a)

    Dynamic Control Language

    (b)

    Data Communication Language

    (c)

    Data Control Language

    (d)

    Dynamic Data Control Language

  10. Which component provides a self definitions to specify storage structure used by the database system?

    (a)

    DML

    (b)

    DQL

    (c)

    DDL

    (d)

    TCL

  11. Which of the following is not a SQL DDL commands?

    (a)

    Alter

    (b)

    Drop

    (c)

    Grant

    (d)

    Truncate

  12. The SQL DQL command used to display all the records from the table is

    (a)

    Select

    (b)

    display

    (c)

    Show

    (d)

    Select all

  13. Which SQL TCL command save a transaction temporarily

    (a)

    Commit

    (b)

    Roll back

    (c)

    Save point

    (d)

    None of these

  14. How many types of database integrity constraints are there?

    (a)

    4

    (b)

    5

    (c)

    3

    (d)

    Multiple

  15. The command to delete all the rows in the table is

    (a)

    DELETE ALL FROM tablename

    (b)

    DELETE tablename

    (c)

    DELETE * FROM tablename

    (d)

    DELETE * FROM tablename ALL

    1. 2 Marks


    10 x 2 = 20
  16. Write a query that selects all students whose age is less than 18 in order wise.

  17. Differentiate Unique and Primary Key constraint

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

  19. What is the difference between SQL and MySQL?

  20. Expand
    (i) SQL
    (ii) DBMS
    (iii) RDBMS

  21. What is the use of WAMP?

  22. What are two basic types of DML.

  23. Explain the following SQL TCL commands.
    (i) Commit
    (ii) Roll back
    (iii) Save point

  24. Write the syntax of creating table with constraint.

  25. How will you retain duplicate rows while displaying the table?

    1. 3 Marks


    10 x 3 = 30
  26. What is a constraint? Write short note on Primary key constraint.

  27. Write any three DDL commands.

  28. Write a SQL statement using DISTINCT keyword.

  29. How the data in RDBMs is stored? Explain.

  30. Write the function performed by DDL.

  31. Write the syntax for the following commands.
    (i) INSERT
    (ii) DELETE
    (iii) UPDATE

  32. List the data types used in SQL.

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

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

  35. Write the different categories of SQL commands.

    1. 5 Marks


    7 x 5 = 35
  36. Write the different types of constraints and their functions.

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

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

  39. Write the processing skills of SQL.

  40. Explain ALTER command in detail.

  41. Write a note on
    (i) TRUNCATE command.
    (ii) DROP TABLE command.

  42. Explain TCL commands in detail.

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

TN 12th Standard Computer Science free Online practice tests

Reviews & Comments about 12th Standard Computer Science English Medium Structured Query Language Reduced Syllabus Important Questions 2021

Write your Comment