SQL PRETEST OPERATORS

Which statement is used to extract data from a database?

• Extract

• Get

• Open

• Select

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

When examining a column in a table, we refer to it as a...

• field name

• folder name

• column number

• table name