Answer the following questions:

What is the difference between float and decimal data types in SQL? (10 points)

What is the difference between binary strings and character strings in SQL? When does it make sense to use one type or the other? (10 points)

What is the difference between BLOB and CLOB? Give examples of data that can be stored in each type. (10 points)

In SQL, can you set a column that allows null values to be unique? What happens if the table contains multiple rows with null value for that column? What happens in case you specify a foreign key to that column in another table and a tuple in the referencing table contains a null value for the foreign key? (30 points)

In SQL, can you specify a foreign key to non-unique columns? Why or why not? (20 points)

Include the references to all the answers you provided. (20 points)