SQL

What does "SQL" stand for?

• Structured Question Language

• Structured Query Language

• Simple Query Language

• Simple Question Language

Tags

CCSS.RI.9-10.4

CCSS.RI.6.4

CCSS.RI.7.4

CCSS.RI.9-10.4

CCSS.RI.11-12.4

Which statement is used to extract data from a database?

• Extract

• Get

• Open

• Select

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?

• %

• #

• *

• /

Which word is missing from the following SQL statement?

Select * table_name

• With

• Where

• From

• And

How do we select all rows for the "Designer" table?

• SELECT * FROM Designer

• SELECT [All] FROM Designer

• SELECT Designer.*

• SELECT FROM Designer

How would we script a SQL query to select "Description" from the Item table?

• SELECT Item.Description

• EXTRACT Description FROM Item

• SELECT Item FROM Description

• SELECT Description FROM Item

You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

• UPDATE Designer SET PhoneNo = '01224123456'

• UPDATE Designer (PhoneNo) VALUES ('01224123456')

• UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

• UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'