0

MySql Quiz

Description: Revision for learning SQL - specifically mySQL
Number of Questions: 13
Created by:
Tags: sql
Attempted 0/13 Correct 0 Score 0

What does the term DROP do?

  1. Deletes

  2. Disables

  3. Creates

  4. Changes


Correct Option: A

An SQL statement is called ?

  1. A String

  2. A Statement

  3. A Query

  4. A Variable


Correct Option: C

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

  1. age

  2. city

  3. name

  4. users


Correct Option: D

SELECT fName, lName  FROM  users   -   What is fName?

  1. A Record

  2. A Table

  3. A Column

  4. A Row


Correct Option: C

SELECT * FROM users   What does * do?

  1. Grab the Database

  2. Grab a Single Column

  3. Grab all the Columns

  4. SELECT a Varchar


Correct Option: C

What is a Record or Row?

  1. Single Data

  2. A Column

  3. A Field

  4. A set of data


Correct Option: D

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


Correct Option: A

What is an INT?

  1. Number

  2. Text

  3. Database

  4. Boolean


Correct Option: A

What is a VARCHAR?

  1. Number

  2. Password

  3. Text

  4. Primary Key


Correct Option: C

When we set up a table we must specify?

  1. Columns

  2. Rows

  3. Varchars

  4. Ints


Correct Option: A

Databases are made up of ?

  1. Databases

  2. Tables

  3. Categories

  4. Different Types


Correct Option: B

What statements adds stuff in to the database?

  1. CREATE

  2. DELETE

  3. INSERT

  4. DROP


Correct Option: C

What does SQL Stand for?

  1. Server Query Language

  2. Structured Query Language

  3. Some Qute Language

  4. Sticky Query Language


Correct Option: B
- Hide questions