6.10. Review Questions

  1. Which of the following statements creates an Oracle account, but lets the operating system authenticate logons?

    1. create user ops$admin identified by os;

    2. create user ops$admin identified externally;

    3. create user ops$admin nopassword;

    4. create user ops$admin authenticated by os;

  2. Which of the following types of statements can use a temporary tablespace?

    1. An index creation

    2. SQL statements with a GROUP BY clause

    3. A hash join operation

    4. All of the above

  3. Which of the following statements gives user desmond the ability to alter table gl.accounts?

    1. grant alter on gl.accounts to desmond;

    2. grant alter to desmond on gl.accounts;

    3. grant alter table to desmond;

    4. allow desmond to alter table gl.accounts;

  4. Which of the following statements gives user desmond the ability to alter table gl.accounts as well as give this ability to other accounts?

    1. grant alter any table with grant option to desmond;

    2. grant alter on gl.accounts to desmond with admin option;

    3. grant alter any table to desmond with grant option;

    4. grant alter any table to desmond with admin option;

  5. The following SQL statement will allow user regina to perform which operations on sequence oe.orders_seq?

    GRANT ALL ON oe.orders_seq TO regina;

    1. Select the next value from oe.orders_seq.

    2. Alter sequence oe.orders_seq to change the next value.

    3. Change the number of sequence numbers that will be cached in memory.

    4. Both A and C.

    5. All of the above.

  6. User system granted SELECT on sh.products to user ian using WITH GRANT OPTION. Ian then granted SELECT on sh.products to user stuart. Ian has left the company, and his account is dropped. What happens to Stuart's privileges on sh.products?

    1. Stuart loses his SELECT privilege on sh.products.

    2. Stuart retains his SELECT privilege on sh.products.

    3. Stuart loses his SELECT privilege if Ian was dropped with the CASCADE REVOKE option.

    4. Stuart retains his SELECT privilege if Ian was dropped with the NOCASCADE REVOKE option.

  7. User system granted SELECT ANY TABLE to user ian using WITH ADMIN OPTION. Ian then granted SELECT ANY TABLE to user stuart. Ian has left the company, and his account is dropped. What happens to Stuart's privileges?

    1. Stuart loses his privileges.

    2. Stuart retains his privileges.

    3. Stuart loses his privileges if Ian was dropped with the CASCADE REVOKE option.

    4. Stuart retains his privileges if Ian was dropped with the NOCASCADE REVOKE option.

  8. Which of the following system privileges can allow the grantee to masquerade as another user and therefore should be granted judiciously?

    1. CREATE ANY JOB

    2. ALTER USER

    3. CREATE ANY PROCEDURE

    4. All of the above

  9. Which of the following statements enables the role user_admin in the current session?

    1. alter session enable role user_admin;

    2. alter session set role user_admin;

    3. alter role user_admin enable;

    4. set role user_admin;

  10. Which of the following SQL statements allows user augustin to use the privileges associated with the password-protected role info_czar, which has been granted to him?

    1. set role all;

    2. alter user augustin default role all;

    3. alter session enable role info_czar;

    4. alter session enable info_czar identified by brozo

  11. By default, how much tablespace can any account use for a new table?

    1. None

    2. Up to the current free space in the tablespace

    3. Unlimited space, including autoextends

    4. Up to the default quota established at tablespace creation time

  12. Which of the following SQL statements results in a disconnection after a session is idle for 30 minutes?

    1. alter session set idle_timeout=30;

    2. alter session set idle_timeout=1800;

    3. alter profile limit idle_time 30;

    4. alter profile set idle_timout 30;

  13. Which of the following prevents a user from reusing a password when they change their password?

    1. Setting the initialization parameter NO_PASSWORD_REUSE to TRUE

    2. Altering that user's profile to UNLIMITED for PASSWORD_REUSE_TIME and 1 for PASSWORD_ REUSE_MAX

    3. Altering that user's profile to UNLIMITED for both PASSWORD_REUSE_TIME and PASSWORD_ REUSE_MAX

    4. Using a password verify function to record the new password and compare the new passwords to those recorded previously

  14. How can you prevent someone from using an all-numeric password?

    1. Set the initialization parameter PASSWORD_COMPLEXITY to ALPHANUM.

    2. Alter that user's profile setting PASSWORD_COMPLEXITY to ALPHNANUM.

    3. Alter the user's profile to use a password verify function that performs REGEX comparisons to validate the password.

    4. There is no mechanism that lets you prevent an all-numeric password.

  15. Which of the following is not an object privilege on a table?

    1. SELECT

    2. DEBUG

    3. REFERENCES

    4. READ

  16. Which of the following statements about user administration and security is the most true? Select the best answer.

    1. Password-protected roles require a password before they can become enabled.

    2. You can disable any role that you find in your session_roles view.

    3. If you execute alter profile student limit idle_time 10; and then execute alter user scott profile student;, then user scott will be disconnected from future sessions after 10 minutes of idle time.

    4. You can limit a table to a maximum size on disk.

  17. Which of the following SQL statements limit attempts to guess passwords by locking an account after three failed logon attempts?

    1. alter profile default limit failed_login_attempts 3;

    2. alter system set max_logon_failures = 3 scope=both;

    3. alter user set failed_login_attempts = 3;

    4. alter system set failed_login_attempts = 3 scope=both;

  18. Where can the database write audit_trail records?

    1. In a database table

    2. In a file outside the database

    3. Both in the database and in an operating system file

    4. Either in the database or in an operating system file

  19. Which of the following activities can be audited?

    1. Unsuccessful deletions from the audit_trail table

    2. Unsuccessful selects from the employee_salary table

    3. All GRANT and REVOKE statements on procedures executed by user system

    4. All of the above

  20. How do you manage fine-grained auditing?

    1. With the AUDIT and NOAUDIT statements

    2. With the DBMS_FGA package

    3. With the GRANT and REVOKE statements

    4. With the CREATE, ALTER, and DROP statements

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset