OCA: Oracle 10g™ Administration I: Study Guide

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 ...