Examine the command: CREATE USER user1 IDENTIFIED BY user123 DEFAULT TEMPORARY TABLESPACE temp QUOTA 2M ON system PROFILE dflt_user PASSWORD EXPIRE; Which two are true? (Choose two.)

Question

Options

• AThe PASSWORD EXPIRE clause is invalid because passwords are controlled by the HR_USER profile.
• BUSER1 requires a quota to be able to store objects in the default permanent tablespace.
• CUSER1 will be prompted for a new passport at first login.
• DA quota on the temporary tablespace must be specified to enable USER1 to perform queries and transactions.
• EUSER1's account is locked.

• A
  5% (3)
• B
  84% (53)
• C
  8% (5)
• D
  2% (1)
• E
  2% (1)

No community discussion yet for this question.