FREE! Click here to Join FunTrivia. Thousands of games, quizzes, and lots more!

Quiz about SQL Commands and Database Concepts

SQL Commands and Database Concepts Quiz

SQL or Structured Query Lanaguage is the most popular language used to create, retrieve, update and delete data from relational databases.

A multiple-choice quiz by kwdesigner. Estimated time: 4 mins.

Author
kwdesigner

Time
4 mins

Type
Multiple Choice

Quiz #
252,932

Updated
Dec 03 21

# Qns
10

Difficulty
Average

Avg Score
7 / 10

Plays
2105

One at a Time - Single Page - Timed Game

Question 1 of 10

1. Which SQL command would you use to retrieve a record or records from the database? Hint

FIND

SELECT

RETRIEVE

NEXT>

Question 2 of 10

2. Which SQL command would you use to add a new record (row) to the database? Hint

ADDROW

INSERT

NEWRECORD

UPDATE

NEXT>

Question 3 of 10

3. Which SQL command would you use to modify the contents of an existing record (row) in the database? Hint

UPDATE

MERGE

INSERT

MODIFY

NEXT>

Question 4 of 10

4. What does the command: 'TRUNCATE TABLE Sample' do? Hint

Deletes the table called Sample.

Reindexes the rows in the table called Sample.

There is no command called Truncate.

Empties all data (rows) from the table called Sample.

NEXT>

Question 5 of 10

5. Look at the following SQL statement:

INSERT INTO ________________
VALUES (value1, value2)

What belongs in the blank? Hint

none of the above

the column(s) name

the table name

the database name

NEXT>

Question 6 of 10

6. The ALTER tablename command would be used to... Hint

none of the above

create a new table in the database

add columns to or drop columns from an existing database table

rename the database table

NEXT>

Question 7 of 10

7. This aggregate SQL function will return the number of rows in a database table. Hint

SUM(column_name)

COUNT(column_name) or COUNT(*)

MAX(column_name)

NUM(column_name)

NEXT>

Question 8 of 10

8. This is a column with a unique value for each row used to bind data together, across tables, without repeating all of the data in every table. Hint

Primary Column

None of the above

Index

Primary Key

NEXT>

Question 9 of 10

9. This type of JOIN statement will return all the rows from the first table, even if there are no matches in the second table. Hint

OUTER JOIN

RIGHT JOIN

LEFT JOIN

INNER JOIN

10. A WHERE clause can be added to a SELECT statement to add conditions to the rows being returned.

SELECT * FROM products WHERE ordernumber >= 1000

What rows will this select statement return? Hint

The first 1000 rows of the product table.

All rows in the products table whose order number is greater than or equal to 1000.

All rows in the products table whose order number is less than or equal to 1000.

All rows in the products table whose order number is greater than 1000.

(Optional) Create a Free FunTrivia ID to save the points you are about to earn:

Select a User ID:

Choose a Password:

Your Email:

Quiz Answer Key and Fun Facts

1. Which SQL command would you use to retrieve a record or records from the database?

Answer: SELECT

In most applications, SELECT is the most commonly used SQL command.

2. Which SQL command would you use to add a new record (row) to the database?

Answer: INSERT

INSERT is used to add rows to an existing table.

3. Which SQL command would you use to modify the contents of an existing record (row) in the database?

Answer: UPDATE

UPDATE is used to modify the values of a set of existing table rows.

4. What does the command: 'TRUNCATE TABLE Sample' do?

Answer: Empties all data (rows) from the table called Sample.

TRUNCATE removes all data (rows) from the table but leaves the structure of the table intact.

5. Look at the following SQL statement: INSERT INTO ________________ VALUES (value1, value2) What belongs in the blank?

Answer: the table name

INSERT INTO table_name
VALUES (value1, value2)

In addition to the above syntax, you may also specify the columns for which you want to insert data:

INSERT INTO table_name (column1, column2)
VALUES (value1, value2)

6. The ALTER tablename command would be used to...

Answer: add columns to or drop columns from an existing database table

The ALTER statement is used to add or drop columns in an existing table.

7. This aggregate SQL function will return the number of rows in a database table.

Answer: COUNT(column_name) or COUNT(*)

The count function is common to most DBMS including MySQL, MS Access, and Microsoft SQL Server.

8. This is a column with a unique value for each row used to bind data together, across tables, without repeating all of the data in every table.

Answer: Primary Key

Primary keys are essential in creating a relational database.

9. This type of JOIN statement will return all the rows from the first table, even if there are no matches in the second table.

Answer: LEFT JOIN

JOIN commands allow you to select data from two tables at the same time.

10. A WHERE clause can be added to a SELECT statement to add conditions to the rows being returned. SELECT * FROM products WHERE ordernumber >= 1000 What rows will this select statement return?

Answer: All rows in the products table whose order number is greater than or equal to 1000.

Many different operators are available to add conditions to the WHERE statement.

Source: Author kwdesigner

This quiz was reviewed by FunTrivia editor crisw before going online.
Any errors found in FunTrivia content are routinely corrected through our feedback system.