O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required