New ! Computer Science MCQ Practise Tests

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

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

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

      Multiple Choice Questions


    15 x 1 = 15
  1. SQL originally called as

    (a)

    DBMS

    (b)

    RDBMS

    (c)

    SQL

    (d)

    SQLITE

  2. Latest SQL standard as of now is

    (a)

    SQL 2008

    (b)

    SQL 2009

    (c)

    SQL 2018

    (d)

    SQL 2.0

  3. WAMP stands for

    (a)

    Windows, Android, MySQL, PHP

    (b)

    Windows, Apache, MySQL, Python

    (c)

    Windows, APL, MySQL, PHP

    (d)

    Windows, Apache, MySQL, PHP

  4. TCL stands for

    (a)

    Transmission Control Language

    (b)

    Transfer Communication Language

    (c)

    Transaction Communication Language

    (d)

    Transaction control Language

  5. DQL Stands for

    (a)

    Database Query Language

    (b)

    Data Query Language

    (c)

    Defined Query Language

    (d)

    Dynamic Query Language

  6. Which DML requires a user to specify what data is needed without specifying how to get it?

    (a)

    Produced DML

    (b)

    Non-Procedural DML

    (c)

    Programmable DML

    (d)

    PRocedural DQL

  7. The SQL DeL command withdraws the access permission given by the GRANT statement is

    (a)

    WITHDRAWN

    (b)

    REMOVE

    (c)

    DELETE

    (d)

    REVOKE

  8. The data in a database is stored based on the kind of value stored is known as

    (a)

    language

    (b)

    function

    (c)

    record

    (d)

    datatype

  9. Double data type precision may exceed

    (a)

    64

    (b)

    74

    (c)

    54

    (d)

    14

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

    (a)

    4

    (b)

    5

    (c)

    3

    (d)

    Multiple

  11. ____________ is a condition application on a field or set of fields?

    (a)

    Class

    (b)

    Control structure

    (c)

    Constraint

    (d)

    Arguments

  12. The Primary key constraint is similar to ___________ tonstraint.

    (a)

    Unique

    (b)

    Check

    (c)

    Default

    (d)

    none of the these

  13. The __________ command is used to modify the table structure (schema)

    (a)

    ALTER

    (b)

    CHANGE

    (c)

    REPLACE

    (d)

    MODIFY

  14. The _______ keyword is used along with the SELECT command to eliminate duplicate rows in the table?

    (a)

    DUPLICATE

    (b)

    DISTINCT

    (c)

    ELIMINATE

    (d)

    a ro b

  15. The _______ keyword defines a range of values the record must fall into make the condition true.

    (a)

    BETWEEN

    (b)

    RANGE

    (c)

    IN

    (d)

    WHERE

    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. Which component of SQL lets insert values in tables and which lets to create a table?

  20. What is the difference between SQL and MySQL?

  21. List few RDBMS packages.

  22. Expand
    (i) DDL
    (ii) DML
    (iii) WAMP

  23. What is the use of WAMP?

  24. List the SQL DDL commands .Explain each.

  25. List the SQL DML commands.

    1. 3 Marks


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

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

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

  29. Write a SQL statement using DISTINCT keyword.

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

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

  32. How will you frame the commands to work on database?

  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. Construct the following SQL statements in the student table-
    (i) SELECT statement using GROUP BY clause.
    (ii) SELECT statement using ORDER BY clause.

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

  40. Write the processing skills of SQL.

  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 With Answer Key 2021

Write your Comment