Online Coding Lessons SQL and Database Basics

Question 1

What does SQL stand for?

Accepted Answer

Structured Query Language

Answer

SQL stands for Structured Query Language, which is used to communicate with and manipulate databases.

Question 2

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

Accepted Answer

SELECT

Answer

The SELECT command is the standard SQL statement used to query and retrieve data from one or more tables.

Question 3

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

Accepted Answer

WHERE

Answer

The WHERE clause is used to specify conditions that rows must meet to be included in the query results.

Question 4

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

Accepted Answer

INSERT INTO

Answer

INSERT INTO is the SQL command used to add new records (rows) into a database table.

Question 5

In a database table, what is a primary key?

Accepted Answer

A column that uniquely identifies each row

Answer

A primary key is a column (or combination of columns) whose values uniquely identify every row in a table.

Online Coding Lessons Practice Test