MySQL 101-01

Question 1

Which of the following is a correctly written SQL Insert statement?

Accepted Answer

INSERT INTO table VALUES (value1, value2, value3);

Answer

INSERT table VALUES (value1, value2, value3);

Answer

INSERT INTO database TABLE(table(schema));

Answer

INSERT TABLE INTO database table(schema);

Question 2

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

Question 3

C.R.U.D is an acronym for the four basic operations of a database system. What are they?

Accepted Answer

Create, Retrieve, Update, Delete

Answer

Create, Retrieve, Upgrade, Delete

Answer

Collate, Retrieve, Update, Delete

Answer

Create, Recall, Update, Delete

Answer

Create, Retrieve, Update, Destroy

Question 4

In SQL terminology, what does DML stand for?

Accepted Answer

Data Manipulation Language

Answer

Data Modification Language

Answer

Digital Manipulation Language

Answer

Digital Modification Language

Question 5

In SQL terminology, What does DDL Stand for?

Accepted Answer

Data Definition Language

Answer

Digital Definition Language

Answer

Data Detention Language

Answer

Digital Determination Language

Question 6

SQL code that can be categorized as DML is used primarily for:

Accepted Answer

Adding, querying, manipulating and deleting data from tables and data sets.

Answer

Defining tables, indexes, and data relationships.

Answer

Storing data in tables, indexes, and primary keys.

Answer

Inserting data relationships into indexes, tables, and primary keys.

Question 7

SQL code that can be categorized as DDL is used primarily for:

Accepted Answer

Defining tables, indexes, and data relationships.

Answer

Inserting data relationships into indexes, tables, and primary keys.

Answer

Adding, querying, manipulating and deleting data from tables and data sets.

Answer

Storing data in tables, indexes, and primary keys.

Question 8

Which answer most completely and correctly describes what this SQL statement will do?

SELECT  Name, LifeExpectancy AS 'Life Expectancy' FROM Country;

Accepted Answer

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'.

Answer

Return all rows from the Name and LifeExpectancy columns in the country table.

Answer

Return all rows from the Name and LifeExpectancy columns in the country table where the phrase 'Life Expectancy' is found in the name column.

Answer

This statement is incorrectly written. It will produce an error.

Question 9

Which answer most completely and correctly describes what the following SQL statement will do?

SELECT "Hi, my name is Jimmy.";

Accepted Answer

This will return the value "Hi, my name is Jimmy." in a column with the header name "Hi, my name is Jimmy."

Answer

This statement is not valid, it will return an error.

Answer

This will return a single row with the value "Hi, my name is Jimmy.".

Answer

This will return a single row with the header <String> and the value "Hi, my name is Jimmy.".

Question 10

Which answer most completely and correctly describes what the following SQL statement will do?

SELECT FROM inventory WHERE item_desc like '%shoe%';

Accepted Answer

This statement is written incorrectly, it will return an error.

Answer

This will return all rows from the customer table where the item_desc column contains the sub-string  'shoe'.

Answer

This will return all rows from the customer table where the item_desc column begins with the sub-string  'shoe'.

Answer

This will return all rows from the customer table where the item_desc column ends with the sub-string  'shoe'.

Question 11

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.

Accepted Answer

3

Answer

1

Answer

2

Answer

4

Question 12

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

Question 13

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
);

Accepted Answer

The DEFAULT keyword is misused.

Answer

The semicolon is unnecessary.

Answer

The AUTO_INCREMENT keyword is misused.

Answer

There is a comma missing after the last column declaration.

Question 14

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?

Accepted Answer

Both A and B are correct.

Answer

CREATE TABLE simpleTest(
	id INTEGER AUTO_INCREMENT PRIMARY KEY,
    fName TEXT NOT NULL,
    lName TEXT NOT NULL
);

Answer

CREATE TABLE simpleTest(
	id INTEGER AUTO_INCREMENT,
    fName TEXT NOT NULL,
    lName TEXT NOT NULL,
    PRIMARY KEY(id)
);

Answer

Neither A nor B is correct.

Question 15

The term "Query" is often used to refer to what kind of SQL statements?

Accepted Answer

SELECT

Answer

CREATE

Answer

INSERT

Answer

ALTER

MySQL 101-01

Create a free account to finish this quiz

Questions in this quiz (15)

Information

Feedback

What do you think of the new look?