A new retail store employee needs to be able to authenticate to a database. Which of the following commands should a database administrator use for this task?

The correct answer is C. CREATE USER. The command that the database administrator should use for this task is CREATE USER. The CREATE USER command is a SQL statement that creates a new user account in a database and assigns it a username and a password. The CREATE USER command also allows the database administrator…

Data and Database Security

Question

Options

AINSERT USER
BALLOW USER
CCREATE USER
DALTER USER

How the community answered

(22 responses)

A
5% (1)
B
9% (2)
C
86% (19)

Explanation

The command that the database administrator should use for this task is CREATE USER. The CREATE USER command is a SQL statement that creates a new user account in a database and assigns it a username and a password. The CREATE USER command also allows the database administrator to specify other options or attributes for the user account, such as default tablespace, quota, profile, role, etc. The CREATE USER command is the first step to enable a user to authenticate to a database. The other options are either invalid or not suitable for this task. For example, INSERT USER is not a valid SQL command; ALLOW USER is not a SQL command, but a keyword used in some database systems to grant permissions to users; ALTER USER is a SQL command that modifies an existing user account, but does not create a new one.

Topics

#database user management#user creation#SQL DDL#authentication

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice