※This sample exam is different from those that appear in the actual OSS-DB Exam.
2019/03/04
The general syntax of GRANT for privileges on tables is
‘GRANT Authority type ON table name TO granted [WITH GRANT OPTION] ‘
By specifying SELECT, INSERT, UPDATE, DELETE, etc. as authority type, you can grant authority to search, insert, update and delete rows.
In SELECT / INSERT / UPDATE, search, insert and update can be allowed only for a specific column by specifying a column list between permission type and ON.
If you specify WITH GRANT OPTION at the end of the GRANT statement, you will also be given the right to grant the granted privileges to other users.
If you have the DELETE privilege you can delete all the rows in the table, but only the owner of the table will delete (DROP) the table itself, you can not grant that privilege with GRANT.
Therefore, the correct answer is D.