※This sample exam is different from those that appear in the actual OSS-DB Exam.
To create a new user (role), execute the createuser command from the OS command prompt, or connect to the database with psql etc. and execute SQL CREATE USER or CREATE ROLE.
The createuser command is executed by the following form.
createuser [options] [user name]
Options that is described in this question have the following meanings.
-c: Maximum number of connections for new users, default is infinity
-d: Give the new user authority to create the database
-D: Do not grant database creation authority to new users (default)
On the other hand, SQL CREATE USER is executed by the following form.
CREATE USER user name [[WITH] option]
The WITH keyword may or may not be present. To grant database creation authority, specify CREATEDB as an option.
Therefore the correct answers are B and E.