Database systems that store each relation in a separate operating system file may use the operating system's authorization scheme, instead of defining a special scheme themselves. In this case, which of the following is false?

1. AThe administrator enjoys more control on the grant option.
2. BIt is difficult to differentiate among the update, delete and insert authorizations.
3. CCannot store more than one relation in a file.
4. DOperations on the database are speeded up as the authorization procedure is carried out at the operating system level. R (a, b, c) R (x, y, z)

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: D. Operations on the database are speeded up as the authorization procedure is carried out at the operating system level. R (a, b, c) R (x, y, z)

Explanation

Using OS file permissions makes it hard to separate insert/update/delete rights and ties one relation to a file. Claiming it speeds up database operations is the false statement.