Which clause orders data when creating a view?

The GROUP BY clause functions in a view much as the ORDER BY clause (or GROUP BY clause) does in a regular query.

Do Oracle and SQL Server handle the ability to order a view in the same way?

No. SQL Server does not permit you to order a view inside of the view definition.

Which option can you use when creating a view from a view to check integrity constraints?

You can use the WITH CHECK OPTION.

You try to drop a view and receive an error because of one or more underlying views. What must you do to drop the view?

Re-execute your DROP statement with the CASCADE option. This allows the DROP statement to succeed by also dropping all underlying views.

In some implementations, what is the system catalog also known as?

The system catalog is also known as the data dictionary.

Can a regular user update the system catalog?

Not directly; however, when a user creates an object such as a table, the system catalog is automatically updated.

Who owns the system catalog?

The owner of the system catalog is often a privileged database user account called SYS or SYSTEM. The owner of the database can also own the system catalog, but a particular schema in the database does not ordinarily own it.

What is the difference between the Oracle system objects ALL_TABLES and DBA_TABLES?

ALL_TABLES shows all tables that are accessible by a particular user, whereas DBA_TABLES shows all tables that exist in the database.

Who makes modifications to the system tables?

The database server makes these modifications.

Why is a cursor not considered a set-based operation?

Cursors are not considered set-based operations because they operate on only one row at a time by fetching a row from memory and performing some action with it.