SQL
Save
Edit
Host a game
Live GameLive
Homework
Solo Practice
Practice
20 QuestionsShow answers
  • Question 1
    30 seconds
    Q.

    What does "SQL" stand for?

    answer choices

    Structured Question Language

    Structured Query Language

    Simple Query Language

    Simple Question Language

  • Question 2
    30 seconds
    Q.

    Which statement is used to extract data from a database?

    answer choices

    Extract

    Get

    Open

    Select

  • Question 3
    30 seconds
    Q.

    If you were wanting to filter data, which clause would you use?

    answer choices

    Where

    Order by

    From

    Select

  • Question 4
    30 seconds
    Q.

    Using which word allows you to specify that more than one condition must be met in a query?

    answer choices

    Also

    And

    Or

    Where

  • Question 5
    30 seconds
    Q.

    Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

    answer choices

    And

    Maybe

    If

    Or

  • Question 6
    30 seconds
    Q.

    In order to amend data in a database we would use which SQL statement?

    answer choices

    Update

    Amend

    Alter

    Modify

  • Question 7
    30 seconds
    Q.

    To remove a record from a table which SQL statement would you use?

    answer choices

    Remove

    Cancel

    Delete

    Eradicate

  • Question 8
    30 seconds
    Q.

    Which statement allows us to add a record to a table?

    answer choices

    Add To

    Update To

    Add Into

    Insert Into

  • Question 9
    30 seconds
    Q.

    Less than or equal to?

    answer choices

    >=

    =>

    =<

    <=

  • Question 10
    30 seconds
    Q.

    Which character returns all the data found in a table?

    answer choices

    %

    #

    *

    /

  • Question 11
    30 seconds
    Q.

    Which word is missing from the following SQL statement?


    Select * table_name

    answer choices

    With

    Where

    From

    And

  • Question 12
    30 seconds
    Q.

    What is the correct order of clauses in a SQL statement?

    answer choices

    SELECT, FROM, ORDER BY, WHERE

    SELECT, FROM, WHERE, ORDER BY

    SELECT, WHERE, FROM, ORDER BY

    WHERE, FROM, SELECT, ORDER BY

  • Question 13
    30 seconds
    Q.

    How do we select all rows for the "Designer" table?

    answer choices

    SELECT * FROM Designer

    SELECT [All] FROM Designer

    SELECT Designer.*

    SELECT FROM Designer

  • Question 14
    30 seconds
    Q.

    How would we script a SQL query to select "Description" from the Item table?

    answer choices

    SELECT Item.Description

    EXTRACT Description FROM Item

    SELECT Item FROM Description

    SELECT Description FROM Item

  • Question 15
    30 seconds
    Q.

    Which query would return only the fields DesignerID and Designer?

    answer choices

    SELECT * FROM Designers

    SELECT DesignerID, Name FROM Designers

    SELECT DesignerID AND Designer FROM Designers

    SELECT DesignerID, Designer FROM Designers

  • Question 16
    30 seconds
    Q.

    You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

    answer choices

    UPDATE Designer SET PhoneNo = '01224123456'

    UPDATE Designer (PhoneNo) VALUES ('01224123456')

    UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

    UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

  • Question 17
    30 seconds
    Q.

    With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

    answer choices

    SELECT * FROM Items ORDER BY Price ASCENDING

    SELECT * FROM Items ORDER BY Price ASC

    SELECT * FROM Items BY Price LOWEST TO HIGHEST

    SELECT * FROM Items ORDER BY Price DESC

  • Question 18
    30 seconds
    Q.

    How would you DELETE records from the Items table with a "Chair" Type?

    answer choices

    DELETE 'Chair' FROM Items

    DELETE Type FROM Items WHERE Type = 'Chair'

    DELETE FROM Items WHERE Type = 'Chair'

    DELETE ITEMS WHERE Type = 'Chair'

  • Question 19
    30 seconds
    Q.

    How would you display Chairs in the Items table that have a Price greater than £50.

    answer choices

    SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

    SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

    SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

    SELECT * FROM Items WHERE Price > 50

  • Question 20
    30 seconds
    Q.

    Which SQL statement would add a record to the database?

    answer choices

    INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

    INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer

    INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer

    INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

Report Quiz
Join a game