Assuming USER1 has full access to database DB1. To restore the database DB1 using the command...

Transcribed Image Text:

Assuming USER1 has full access to database DB1. To restore the database DB1 using the command line from file_DB1, we use the below SQL syntax: O mysql -u USER1 'DB1' -p> file_DB1.sql O mysql -u USER1 DB1 -p > file_DB1.sql O mysql-u USER1 DB1 -p < file_DB1.sql O mysql -u USER1 file_DB1 -p < DB1.sql Problem Describe the use of functions in a SQL statement by inserting the correct terms into the descriptions below. Details In the WHERE portion of a SQL statement, you can use the o For example: WHERE colour_name O CAN NOT O NOT O ON O BETWEEN /IS NOT operator, to test if something does not exist inside a list. IN ('red','blue', 'green') Assuming USER1 has full access to database DB1. To restore the database DB1 using the command line from file_DB1, we use the below SQL syntax: O mysql -u USER1 'DB1' -p> file_DB1.sql O mysql -u USER1 DB1 -p > file_DB1.sql O mysql-u USER1 DB1 -p < file_DB1.sql O mysql -u USER1 file_DB1 -p < DB1.sql Problem Describe the use of functions in a SQL statement by inserting the correct terms into the descriptions below. Details In the WHERE portion of a SQL statement, you can use the o For example: WHERE colour_name O CAN NOT O NOT O ON O BETWEEN /IS NOT operator, to test if something does not exist inside a list. IN ('red','blue', 'green')