Which has precedence, AND or OR?

Why do we need derived structures?

What is a view?

List some advantages of using views.

List some advantages of using temporary tables.

Can temporary tables replace views in all cases?

What is the difference between a view and temporary table?

What is the difference between a local temporary table and global temporary table?

If data is changed in a view, is it changed in the original table?

If data is changed in a temporary table, does it automatically change data in the original table?

What happens to local temporary tables after the session has been ended?

What happens to global temporary table after the session has been ended?

Which type of temporary table has a system-generated suffix attached to it? What does this suffix mean?

Why are inline views helpful?

In SQL Server, is the ORDER BY clause allowed during the creation of a view?

Is SELECT INTO allowed in a view? Why or why not?

Where is the data stored in a view?

How do you delete views?

How do you delete a temporary table?

Do you need to delete a local temporary table? Why or why not?

Which operators have the highest/lowest precedence?

In SQL Server, if a column of FLOAT data type were divided by a column of REAL data type, what data type would the resulting column have? (Hint: refer to the section on Data Type Preference.)

Is an ORDER BY clause necessary when you use a DISTINCT? Why or why not?