Home › Quizzes › MySql Quiz

MySql Quiz

Revision for learning SQL - specifically mySQL

13 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

What does the term DROP do?

  1. Deletes
  2. Disables
  3. Creates
  4. Changes
Question 2 Multiple Choice (Single Answer)

An SQL statement is called ?

  1. A String
  2. A Statement
  3. A Query
  4. A Variable
Question 3 Multiple Choice (Single Answer)

SELECT name, age, city FROM users   -   What is the table name?

  1. age
  2. city
  3. name
  4. users
Question 4 Multiple Choice (Single Answer)

SELECT fName, lName  FROM  users   -   What is fName?

  1. A Record
  2. A Table
  3. A Column
  4. A Row
Question 5 Multiple Choice (Single Answer)

SELECT * FROM users   What does * do?

  1. Grab the Database
  2. Grab a Single Column
  3. Grab all the Columns
  4. SELECT a Varchar
Question 6 Multiple Choice (Single Answer)

What is a Record or Row?

  1. Single Data
  2. A Column
  3. A Field
  4. A set of data
Question 7 Multiple Choice (Single Answer)

What is a Primary Key?

  1. Unique Column
  2. Unique Row
  3. A row than can be duplicated
  4. A Column that can be duplicated
Question 8 Multiple Choice (Single Answer)

What is an INT?

  1. Number
  2. Text
  3. Database
  4. Boolean
Question 9 Multiple Choice (Single Answer)

What is a VARCHAR?

  1. Number
  2. Password
  3. Text
  4. Primary Key
Question 10 Multiple Choice (Single Answer)

When we set up a table we must specify?

  1. Columns
  2. Rows
  3. Varchars
  4. Ints
Question 11 Multiple Choice (Single Answer)

Databases are made up of ?

  1. Databases
  2. Tables
  3. Categories
  4. Different Types
Question 12 Multiple Choice (Single Answer)

What statements adds stuff in to the database?

  1. CREATE
  2. DELETE
  3. INSERT
  4. DROP
Question 13 Multiple Choice (Single Answer)

What does SQL Stand for?

  1. Server Query Language
  2. Structured Query Language
  3. Some Qute Language
  4. Sticky Query Language
← Back to Quizzes