MySQL 101-01

Chris Lee
Quiz by Chris Lee, updated more than 1 year ago
Chris Lee
Created by Chris Lee about 6 years ago
23
1

Description

A general Quiz on some basic SQL knowledge, focusing on general SQL and some MySQL specific questions.

Resource summary

Question 1

Question
Which of the following is a correctly written SQL Insert statement?
Answer
  • INSERT table VALUES (value1, value2, value3);
  • INSERT INTO table VALUES (value1, value2, value3);
  • INSERT INTO database TABLE(table(schema));
  • INSERT TABLE INTO database table(schema);

Question 2

Question
When writing DELETE statements, it is often a good idea to begin with a SELECT statement, to verify that your are targeting the correct data for deletion.
Answer
  • True
  • False

Question 3

Question
C.R.U.D is an acronym for the four basic operations of a database system. What are they?
Answer
  • Create, Retrieve, Upgrade, Delete
  • Collate, Retrieve, Update, Delete
  • Create, Recall, Update, Delete
  • Create, Retrieve, Update, Delete
  • Create, Retrieve, Update, Destroy

Question 4

Question
In SQL terminology, what does DML stand for?
Answer
  • Data Modification Language
  • Data Manipulation Language
  • Digital Manipulation Language
  • Digital Modification Language

Question 5

Question
In SQL terminology, What does DDL Stand for?
Answer
  • Digital Definition Language
  • Data Detention Language
  • Digital Determination Language
  • Data Definition Language

Question 6

Question
SQL code that can be categorized as DML is used primarily for:
Answer
  • Adding, querying, manipulating and deleting data from tables and data sets.
  • Defining tables, indexes, and data relationships.
  • Storing data in tables, indexes, and primary keys.
  • Inserting data relationships into indexes, tables, and primary keys.

Question 7

Question
SQL code that can be categorized as DDL is used primarily for:
Answer
  • Inserting data relationships into indexes, tables, and primary keys.
  • Adding, querying, manipulating and deleting data from tables and data sets.
  • Defining tables, indexes, and data relationships.
  • Storing data in tables, indexes, and primary keys.

Question 8

Question
Which answer most completely and correctly describes what this SQL statement will do? SELECT Name, LifeExpectancy AS 'Life Expectancy' FROM Country;
Answer
  • Return all rows from the Name and LifeExpectancy columns in the country table.
  • Return all rows from the Name and LifeExpectancy columns in the country table, renaming the column header displaying the LifeExpectancy column's results to 'Life Expectancy'.
  • Return all rows from the Name and LifeExpectancy columns in the country table where the phrase 'Life Expectancy' is found in the name column.
  • This statement is incorrectly written. It will produce an error.

Question 9

Question
Which answer most completely and correctly describes what the following SQL statement will do? SELECT "Hi, my name is Jimmy.";
Answer
  • This statement is not valid, it will return an error.
  • This will return a single row with the value "Hi, my name is Jimmy.".
  • This will return a single row with the header <String> and the value "Hi, my name is Jimmy.".
  • This will return the value "Hi, my name is Jimmy." in a column with the header name "Hi, my name is Jimmy."

Question 10

Question
Which answer most completely and correctly describes what the following SQL statement will do? SELECT FROM inventory WHERE item_desc like '%shoe%';
Answer
  • This will return all rows from the customer table where the item_desc column contains the sub-string 'shoe'.
  • This statement is written incorrectly, it will return an error.
  • This will return all rows from the customer table where the item_desc column begins with the sub-string 'shoe'.
  • This will return all rows from the customer table where the item_desc column ends with the sub-string 'shoe'.

Question 11

Question
This SQL statement will return all rows from the 'Countries' table: SELECT * FROM Countries; Which of the following will return the number of rows in the Countries table? 1. SELECT * (COUNT) FROM Countries; 2. SELECT COUNT FROM Countries; 3. SELECT COUNT(*) FROM Countries; 4. All of the above.
Answer
  • 1
  • 2
  • 3
  • 4

Question 12

Question
True or False: Given a database with table named test that has columns named 'id' and 'value' This is a valid SQL statement: SELECT * FROM test WHERE value = NULL;
Answer
  • True
  • False

Question 13

Question
In MySql, this create table statement is not valid. Why? CREATE TABLE test ( a INTEGER AUTO_INCREMENT, b TEXT DEFAULT 'nothing', c TEXT NOT NULL );
Answer
  • The semicolon is unnecessary.
  • The AUTO_INCREMENT keyword is misused.
  • There is a comma missing after the last column declaration.
  • The DEFAULT keyword is misused.

Question 14

Question
In MySQL, which of these statements will successfully create a table named simpleTest with an id field set as an auto-increment integer with a primary key constraint?
Answer
  • CREATE TABLE simpleTest( id INTEGER AUTO_INCREMENT PRIMARY KEY, fName TEXT NOT NULL, lName TEXT NOT NULL );
  • CREATE TABLE simpleTest( id INTEGER AUTO_INCREMENT, fName TEXT NOT NULL, lName TEXT NOT NULL, PRIMARY KEY(id) );
  • Neither A nor B is correct.
  • Both A and B are correct.

Question 15

Question
The term "Query" is often used to refer to what kind of SQL statements?
Answer
  • CREATE
  • SELECT
  • INSERT
  • ALTER
Show full summary Hide full summary

Similar

SQL Quiz
R M
SQL Quiz
Chris Cronin
Coding Quiz
ryanseaborne
Database Final Exam
dbm
Microsoft Virtual Academy - SQL Server Basics
chrisburford
Databases
Alex Baine
SQL Server
Jordan Cartwright
BASES DE DATOS RELACIONALES
Jesus Castellanos
Chapter 7: MySQL
Rebecca Walton
WORLD OF DOMES
mohammadudwan
lesson3
tualau