Oracle DBA Assignment 7

Chapter 13

1. _________________________ displays all object privileges granted and by whom.

2. There is a role called _________________________, containing privileges specifically used for managing Oracle advanced queues, which is an Oracle feature for communicating between databases.

3. Roles are similar to _________________________ in that a role granted by a user is not revoked if the granting user loses the role.

4. A(n) _________________________ is a process that uses a previously created snapshot of the database and re-creates all or part of it in the current database.

5. Include the _________________________ only when you want the user to be able to grant the role to other users.

6. When a role switches to requiring a(n) _________________________, users currently logged on who are granted the role are unaffected until they log off and back on again.

Chapter 14

7. _________________________ sets the symbols for the decimal point (placeholder is D) and group separator (placeholder is G).

8. The initialization parameters in the _________________________ file should be set up to handle the NLS requirements for typical requests and reports.

9. _________________________ is a universal language character set capable of supporting all languages supported by Oracle9i.

10. Calculating the length of a data string is easier with _________________________ character sets; however, they take up more space.

11. NLS initialization parameters can be modified at two levels: _________________________ level and session level.

12. The best way to use the NLS parameters in your session is by adjusting the two primary parameters (NLS_LANGUAGE and _________________________), which in turn adjust the others (NLS_SORT, NLS_CURRENCY, and so on) automatically.