24.06.2022-KS4-SQL, FILES AND RECORDS STARTER

Starter

Identify parts of an image

Multiple Choice

Which is a record?

• a

• b

• c

• d

• e

Multiple Choice

Which is a file?

• a

• b

• c

• d

• e

Multiple Choice

Which is a SQL query?

• a

• b

• c

• d

• e

Multiple Choice

Which is data or results?

• a

• b

• c

• d

• e

Multiple Choice

Which is a record?

• a

• b

• c

• d

• e

Identify parts of an SQL statement

Multiple Choice

Which is condition in the statement?

• a

• b

• c

• d

Multiple Choice

Which is field in the statement?

• a

• b

• c

• d

Multiple Choice

Which is file in the statement?

• a

• b

• c

• d

Multiple Choice

Which orders the way in which the records are displayed in the statement?

• a

• b

• c

• d

write a statement

Fill in the Blanks

Command word that starts an SQL statement

to query the database

Fill in the Blanks

Write a statement to choose all fields and all records

in the Inventory table

Fill in the Blanks

Write a statement to choose only the productid field,

but all records

in the Inventory table

Fill in the Blanks

Write a statement to choose only the productid field,

in the Inventory table

where productname field is "table"

end