SQL Select/Insert/Update/Delete

What does "SQL" stand for?

• Structured Question Language

• Structured Query Language

• Simple Query Language

• Simple Question Language

Tags

CCSS.RI.11-12.4

CCSS.RI.7.4

CCSS.RI.8.4

CCSS.RI.9-10.4

CCSS.RI.9-10.4

Which statement is used to extract data from a database?

• Extract

• Get

• Open

• Select

If you were wanting to filter data, which clause would you use?

• Where

• Order by

• From

• Select

Using which word allows you to specify that more than one condition must be met in a query?

• Also

• And

• Or

• Where

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

• And

• Maybe

• If

• Or

In order to amend data in a database we would use which SQL statement?

• Update

• Amend

• Alter

• Modify

To remove a record from a table which SQL statement would you use?

• Remove

• Cancel

• Delete

• Eradicate

Which statement allows us to add a record to a table?

• Add To

• Update To

• Add Into

• Insert Into

Less than or equal to?

• >=

• =>

• =<

• <=

Which character returns all the data found in a table?

• %

• #

• *

• /