Which of the following statements creates an Oracle account, but lets the operating system authenticate logons?
create user ops$admin identified by os;
create user ops$admin identified externally;
create user ops$admin nopassword;
create user ops$admin authenticated by os;
Which of the following types of statements can use a temporary tablespace?
An index creation
SQL statements with a GROUP BY clause
A hash join operation
All of the above
Which of the following statements gives user desmond the ability to alter table gl.accounts?
grant alter on gl.accounts to desmond;
grant alter to desmond on gl.accounts;
grant alter table to desmond;
allow desmond to alter table gl.accounts;
Which of the following statements gives user desmond the ...