exam questions

Exam 1z0-908 All Questions

View all questions & answers for the 1z0-908 exam

Exam 1z0-908 topic 1 question 2 discussion

Actual exam question from Oracle's 1z0-908
Question #: 2
Topic #: 1
[All 1z0-908 Questions]

Which three are characteristics of a newly created role? (Choose three.)

  • A. It can be dropped using the DROP ROLE statement.
  • B. It is stored in the mysql.role table.
  • C. It is created as a locked account.
  • D. It can be renamed using the RENAME ROLE statement.
  • E. It can be granted to user accounts.
  • F. It can be protected with a password.
Show Suggested Answer Hide Answer
Suggested Answer: ACE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
abpg
2 months ago
Selected Answer: ACE
A, C, E
upvoted 1 times
...
eena96
11 months, 3 weeks ago
Agree, A,C,E
upvoted 1 times
...
FelipeK
1 year, 2 months ago
Selected Answer: ACE
The three correct statements are A, C, and E. A newly created role in MySQL 8.0 can be dropped using the DROP ROLE statement, is created as a locked account, and can be granted to user accounts. It is not stored in a mysql.role table, but rather in the mysql.user table. It cannot be protected with a password, as it has no password when created.
upvoted 3 times
...
FelipeK
1 year, 6 months ago
The three correct statements are A, C, and E. A newly created role in MySQL 8.0 can be dropped using the DROP ROLE statement, is created as a locked account, and can be granted to user accounts. It is not stored in a mysql.role table, but rather in the mysql.user table. It cannot be protected with a password, as it has no password when created.
upvoted 3 times
...
raju8010
1 year, 6 months ago
hi please can anyone send me the dumps
upvoted 1 times
...
fthusa
1 year, 9 months ago
ACE It is created as a lock account
upvoted 1 times
...
Nelate
1 year, 10 months ago
Correct answer is A,C,E https://dev.mysql.com/doc/refman/8.0/en/roles.html
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago