Online Coding Lessons SQL and Database Basics

Question 1

What does SQL stand for?

Accepted Answer

Structured Query Language

Answer

Simple Question Language

Answer

Standard Query List

Answer

Scripted Query Logic

Question 2

Which SQL command is used to retrieve data from a database table?

Accepted Answer

SELECT

Answer

GET

Answer

FETCH

Answer

PULL

Question 3

What keyword is used in SQL to filter rows returned by a SELECT query?

Accepted Answer

WHERE

Answer

FILTER

Answer

HAVING

Answer

LIMIT

Question 4

Which SQL command adds a new row of data to a table?

Accepted Answer

INSERT INTO

Answer

ADD

Answer

APPEND

Answer

UPDATE

Question 5

In a database table, what is a primary key?

Accepted Answer

A column that uniquely identifies each row

Answer

The first column in every table

Answer

The most important data in a row

Answer

A password that locks the table

Question 6

Which SQL command is used to remove rows from a table?

Accepted Answer

DELETE

Answer

REMOVE

Answer

DROP

Answer

CLEAR

Question 7

What does the ORDER BY clause do in a SQL query?

Accepted Answer

Sorts the result set by one or more columns

Answer

Filters duplicate rows from results

Answer

Groups rows that have the same values

Answer

Limits the number of rows returned