A DBA has updated Smith's account by adding the privileges CREATE ANY TABLE and CREATE PROCEDURE. Which tasks can Smith successfully perform?

Question

Options

• ASmith can create tables, drop tables and create procedures in any schema of the database.
• BSmith can create any table or procedure only in his schema. Also, he can drop any table only from
• CSmith can create a table in any schema of the database but can drop tables from and create
• DSmith can create a table or a procedure in any schema of the database. Also, he can drop a table in

• A
  5% (3)
• B
  14% (9)
• C
  75% (49)
• D
  6% (4)

No community discussion yet for this question.