Exam 12: Security Management

The ____ object privilege allows you to create FOREIGN KEY constraints that reference the table.

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

You can change a user's name using the ALTER USER statement.

There are over ____ system privileges in the Oracle 10g database.

You should click on the ____ tab of a user's property sheet (available in the Security Management section of the Enterprise Manager console)to see a list of the quotas for each tablespace.

It is advisable to store temporary segments in the SYSTEM tablespace.

Removing users requires the ____ system privilege,which the SYSTEM user has.

Oracle ____________________ is a feature for storing dimensional data in the database.

Composite limits require two steps.First,you set a(n)____ for the resources you want to include when Oracle 10g calculates service units.Second,you set the maximum service units in the profile.

When you ____________________ a privilege,you assign a privilege to a user or a role,whether it is a system privilege or an object privilege.

When dropping a profile,you must add ____________________ if any users have been assigned the profile being dropped.

The CREATE ANY INDEX privilege allows you to create indexes on a table in your own schema.

The ______________________________ gives you an excellent way to look at the settings for users and profiles,without having to write queries.

A user's identity can be validated in ____ ways.

The audit trail records are written to the ____ table.

The only way to remove the role from a user's default roles is by issuing the ____________________ command.

Oracle 10g allows a user whose user name matches his operating system logon name combined with a prefix such as ____ (the default).

Exporting is a form of backup that can be used to back up specific tables or schemas,or to back up the entire database.

You should log on as the SYS user for only the very highest level of tasks,and not for other,more routine tasks.

A(n)____________________ is the user receiving a privilege.