ExamGecko
Question list
Search
Search

Question 48 - DS0-001 discussion

Report
Export

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?

A.
INSERT USER
Answers
A.
INSERT USER
B.
ALLOW USER
Answers
B.
ALLOW USER
C.
CREATE USER
Answers
C.
CREATE USER
D.
ALTER USER
Answers
D.
ALTER USER
Suggested answer: C

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.Reference:CompTIA DataSys+ Course Outline, Domain 4.0 Data and Database Security, Objective 4.2 Given a scenario, implement security controls for databases.

asked 02/10/2024
Suraj Patil
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first