Knowledge quiz

It's time to put what you've learned to the test, get 4 right to pass this unit.

1.

If a view is defined on a join of tables, then an INSERT or DELETE on the view will modify each of the underlying tables.

Choose the correct answer.
2.

You wish to create a unique index on a column that contains duplicate values. Which of the following is true?

Choose the correct answer.
3.

A user initially has no access to a given table, and is the grantee of following permission commands in the order shown: GRANT SELECT ON ‹table_name› TO ‹user›; GRANT SELECT, INSERT ON ‹table_name› TO ‹user›; REVOKE SELECT, INSERT, DELETE, UPDATE ON ‹table_name› FROM ‹user›;. Which of the following is true?

Choose the correct answer.
4.

When altering a table to add a column, which of the following is true?

There are two correct answers.
5.

Like the INSERT command without a subquery, the UPDATE and DELETE commands can only act on one row at a time.

Choose the correct answer.

Learning

SAP FacebookSAP YoutubeSAP LinkedIn