Which statement creates a new user?

The correct answer is D. CREATE USER susan. The correct statement to create user is: CREATE USER user_name IDENTIFIED BY password. Incorrect Answers A: This syntax is incorrect to create user: you need to provide also password for the user. B: There is no CREATE OR REPLACE USER command in Oracle. C: There is no CREATE…

Controlling User Access

Question

Options

ACREATE USER susan;
BCREATE OR REPLACE USER susan;
CCREATE NEW USER susan
DCREATE USER susan
ECREATE NEW USER susan
FCREATE OR REPLACE USER susan

How the community answered

(25 responses)

A
8% (2)
B
4% (1)
D
80% (20)
E
8% (2)

Explanation

The correct statement to create user is: CREATE USER user_name IDENTIFIED BY password. Incorrect Answers A: This syntax is incorrect to create user: you need to provide also password for the user. B: There is no CREATE OR REPLACE USER command in Oracle. C: There is no CREATE NEW USER user_name DEFAULT command in Oracle. E: There is no CREATE NEW USER user_name IDENTIFIED BY command in Oracle. F: There is no CREATE OR REPLACE USER user_name IDENTIFIED BY command in Oracle.

Topics

#CREATE USER#IDENTIFIED BY#user management#syntax

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice