Test your understanding

What is the statement to extract data from database

• Get

• Select

• Extract

• Load

Which wildcard character indicate select all field from a table

• %

• *

• &

• @

Which statement is correct for select all records from Staff table where ID start with 'MY'

• Select * from Staff where ID = 'MY'

• Select * from Staff where ID like 'MY'

• Select * from Staff where ID = 'MY%'

• Select * from Staff where ID like 'MY%'

The OR operator displays a record if any conditions listed are true. The AND operator displays a record if all of the conditions listed are true

• True

• False

Which statement is used to return only different values

• Select distinct

• Select different

• Select unique

Data lake data is production data.

• True

• False

Which component I used to upload file to HUE.

• Impala

• Hive

• File Browser

• Oozie

Which keyword is used to sort the result-set

• Order

• Order by

• Sort

• Sort by