Intro SQL 2 - Data Dictionary

Indexes must be created manually and serve to speed up access to rows in a table.

• True

• False

You can use a correlated subquery to delete only those rows that also exist in another table.

• True

• False

You can use a subquery in place of the table name in the ______ clause of the INSERT statement.

• FROM

• INTO

• FOR UPDATE

• VALUES

You cannot add data through a view if the view includes a GROUP BY clause.

• True

• False

The dictionary views that are based on the dictionary tables contain information such as:

• Definitions of all the schema objects in the database

• Default values for the columns

• Integrity constraint information

• Privileges and roles that each user has been granted

A FOREIGN KEY constraint enforces the following action:

When the data in the parent key is deleted, all the rows in the child table that depend on the deleted parent key values are also deleted.

• True

• False

With a correlated subquery, the inner SELECT statement drives the outer SELECT statement.

• True

• False

Which of the following statements are true?

• Subqueries are used to retrieve data by using an inline view.

• Subqueries cannot be used to copy data from one table to another.

• Subqueries update data in one table based on the values of another table.

• Subqueries delete rows from one table based on rows in another table.

The SELECT list of a subquery must have the same number of columns as the column list of the VALUES clause.

• True

• False

The WITH CHECK OPTION keyword prohibits you from changing rows that are not in the subquery

• True

• False