________allows you to assign a column or an expression in the select list

of a SELECT statement a temporary name

___________links tables by selecting only the rows with common values in their common attribute(s)

___________refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.

Which of the following is not valid literal for BOOLEAN data type?

__________________function accepts a string and returns the length of that string.

_____________convert a value of one data type into another

___________the matched pairs would be retained, and any unmatched values in the other table would be left null.

_______________ are very useful when doing date or time arithmetic.