Quizalize logo
placeholder image to represent content

SQL-2

Quiz by Dr.J.Jenefa

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
19 questions
Show answers
  • Q1
    The language used in application programs to request data from the DBMS is referred to as __________
    DML
    DDL
    All the above
    Query Language
    30s
  • Q2
    In SQL, which of the following is not a data Manipulation Language Commands?
    UPDATE
    TRUNCATE
    CREATE
    DELETE
    30s
  • Q3
    Which of the following is not a type of SQL statement?
    DDL (Data Definition Language)
    DCL (Data Control Language)
    DML (Data Manipulation Language)
    DCL (Data Communication Language)
    30s
  • Q4
    Which of the following is not included in DML (Data Manipulation Language) ?
    INSERT
    CREATE
    UPDATE
    DELETE
    30s
  • Q5
    TRUNCATE statement in SQL is a ______________
    DML
    DDL
    DCL
    TCL
    30s
  • Q6
    In SQL, which command is used to add new rows to a table ?
    INSERT
    ALTER
    APPEND
    ADD ROW
    30s
  • Q7
    Combination of a primary key with foreign key forms
    Network model between the tables connect them
    Many to many relationship between the tables that connect them
    None of them
    Parent-child relationship between the tables that connect them
    30s
  • Q8
    Stack is also called _____________________________
    First In First Out (FIFO)
    Last In Last Out (LILO)
    First Come First Served (FCFS)
    First In Last Out (FILO)
    30s
  • Q9
    )Match SQL language with SQL commands 1)DDL i)Revok, Grant 2)DML ii)rename a table 3)TCL iii)insert, update 4)DCL iv)rollback , commit
    1-ii,2-iii,3-iv,4-i
    1-i,2-iii,3-ii,4-iv
    1-iii,2-ii,3-iv,4-i
    1-iii,2-i,3-ii,4-iv
    30s
  • Q10
    Which is not DDL (data definition language) operation ?
    SQL create table
    Renaming a table
    Update data into a table in SQL database
    Add a column to an existing table
    30s
  • Q11
    Which of the following is not a type of SQL statement?
    DML
    DCL
    DCI
    DDL
    30s
  • Q12
    Which of the following is not included in DML (Data Manipulation Language)?
    Insert
    Delete
    Alter
    Update
    30s
  • Q13
    A type of query that is placed within a WHERE or HAVING clause of another query is called
    Master query
    Multi-query
    Sub query
    Super query
    30s
  • Q14
    Which one of these is used with SELECT clause to fetch all columns from a table?
    ALL
    DISTINCT
    AS
    *
    30s
  • Q15
    Data manipulation language (DML) includes statements that modify the _____ of a database.
    Structure
    User
    Size
    Data
    30s

Teachers give this quiz to your class