SQL-ponovitev-enostavno

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

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

Which word is missing from the following SQL statement?

Select * table_name

• With

• Where

• From

• And

What is the correct order of clauses in a SQL statement?

• SELECT, FROM, ORDER BY, WHERE

• SELECT, FROM, WHERE, ORDER BY

• SELECT, WHERE, FROM, ORDER BY

• WHERE, FROM, SELECT, ORDER BY

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

Which query would return only the fields DesignerID and Designer?

• SELECT * FROM Designers

• SELECT DesignerID, Name FROM Designers

• SELECT DesignerID AND Designer FROM Designers

• SELECT DesignerID, Designer FROM Designers