New ! Computer Science MCQ Practise Tests



12th Standard Computer Science Structured Query Language ( SQL ) English Medium Free Online Test One Mark Questions with Answer Key 2020 - 2021

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 00:10:00 Hrs
Total Marks : 10

    Answer all the questions

    10 x 1 = 10
  1. Which command lets to change the structure of the table?

    (a)

    SELECT

    (b)

    ORDER BY

    (c)

    MODIFY

    (d)

    ALTER

  2. Queries can be generated using

    (a)

    SELECT

    (b)

    ORDER BY

    (c)

    MODIFY

    (d)

    ALTER

  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 originally called as

    (a)

    DBMS

    (b)

    RDBMS

    (c)

    SQL

    (d)

    SQLITE

  5. Find out the odd man out:

    (a)

    MS SQL servers

    (b)

    Microsoft Access

    (c)

    IBM DB2

    (d)

    Dbase

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

    (a)

    DCL

    (b)

    TCL

    (c)

    DDL

    (d)

    DML

  7. DCL stands for

    (a)

    Dynamic Control Language

    (b)

    Data Communication Language

    (c)

    Data Control Language

    (d)

    Dynamic Data Control Language

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

    (a)

    DML

    (b)

    DQL

    (c)

    DDL

    (d)

    TCL

  9. Which of the following SQL DDL command that delete tables from database?

    (a)

    Drop

    (b)

    Delete

    (c)

    Truncate

    (d)

    Rollback

  10. The SQL DDL command removes all records from a table and also release the space occupied by these records is

    (a)

    Delete

    (b)

    Truncate

    (c)

    Rollback

    (d)

    Drop

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

Reviews & Comments about 12th Standard Computer Science Structured Query Language ( SQL ) English Medium Free Online Test One Mark Questions with Answer Key 2020 - 2021

Write your Comment