Multiple choice

Which script should be executed to create user JOY and give him the ability to connect to the database and the ability to create tables, sequences, and procedures in his schema?

  1. CREATE Joy IDENTIFIED BY Joy18; GRANT CREATE CONNECT, TABLE, SEQUENCE, PROCEDURE TO Joy

  2. CREATE USER Joy IDENTIFIED BY Joy18; GRANT CREATE TABLE, CREATE SEQUENCE, CREATE PROCEDURE TO Joy

  3. CREATE OR REPLACE USER Joy IDENTIFIED BY Joy18 GRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE PROCEDURE

  4. CREATE USER Joy IDENTIFIED BY Joy18; GRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE PROCEDURE TO Joy
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

CREATE USER  Joy IDENTIFIED BY  Joy18; GRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE PROCEDURE TO Joy

Keep practicing — related questions