Re: Test One Certification Questions

davebiduk_at_hotmail.com ¼¶¼g©ó¤å³¹ <3630d087.24429971_at_47.211.192.68>...
>I have the outline of Test One for the Oracle DBA Certification from
>the Web and am confused on a couple of topics:
>
>"Identify table naming conventions"
>The only global convention I know of is don't use reserved words (?)

  schema level unique
  can't exceed 30 characters
  case insensitive, consists of alphabets, digits, or $, #, _, can't start with digit, can't be SQL reserved words,

      unless enclosed by double quotes

>"Create a non-unique index"
>Are they talking about clustered indexes?

Without specifying "UNIQUE" in "CREATE INDEX" statement, Oracle will create a non-unique index.

>"... using implicit cursor attributes"
>Huh? (I've been using Oracle for 7 years)

SQL%FOUND, SQL%NOTFOUND, SQL%ROWCOUNT, ex:

begin
  update emp set sal=sal*1.1 where ename='SCOTT';   if SQL%NOTFOUND then

      ....... -- SCOTT was not found   elsif SQL%ROWCOUNT>1 then

      ....... -- more than one employee called SCOTT   end if;
end;

However, SQL%ISOPEN is useless, sinse it always evaluates to FALSE.

>"... three basic types of (PL/SQL) exceptions"
>1. Built-in
>2. User-defined
>3. ? (Unhandled??)

??? Received on Mon Oct 26 1998 - 07:03:52 CST