exam questions

Exam 1z0-931-20 All Questions

View all questions & answers for the 1z0-931-20 exam

Exam 1z0-931-20 topic 1 question 19 discussion

Actual exam question from Oracle's 1z0-931-20
Question #: 19
Topic #: 1
[All 1z0-931-20 Questions]

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

  • A. through SQLPlus
  • B. through SQL/Developer
  • C. through the Oracle Cloud Infrastructure service console
  • D. using DBMS_CLOUD_ADMIN Package
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️

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
guru_ji
1 year, 6 months ago
Selected Answer: AB
A,B is correct.
upvoted 1 times
...
guru_ji
1 year, 6 months ago
Selected Answer: AB
A,B is correct.
upvoted 1 times
...
PKD4OCI
3 years ago
Selected Answer: AB
Are correct way to achieve the same
upvoted 1 times
...
luizyto
3 years ago
Selected Answer: AB
Because from OCI console is through Database Actions and not from Service Console: "Create Users on Autonomous Database - Connecting with Database Actions" https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-users-create.html#GUID-DD0D847B-0283-47F5-9EF3-D8252084F0C1
upvoted 1 times
...
cine
3 years, 1 month ago
how can you connect with sqlplus, A is absolutely wrong, Corrects are b and c
upvoted 1 times
...
SilNilanjan
3 years, 2 months ago
I would say A and B holds good.
upvoted 1 times
...
adnancsedu
3 years, 2 months ago
Selected Answer: AB
A and B are correct.
upvoted 1 times
...
reachabhien10
3 years, 3 months ago
answer is B,C
upvoted 1 times
...
Rogazan
3 years, 3 months ago
I think that A and B are correct: A: From mi WSL2 ubuntu connected to my ADB: adrs@ADRS-1:~/db$ sqlplus admin@midb_medium SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 11 21:52:37 2021 Version 19.12.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. Enter password: Last Successful login time: Mon Oct 11 2021 21:52:12 +02:00 Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.13.0.1.0 SQL> create user userFromSQL; User created. SQL> GRANT CREATE SESSION TO userFromSQL; Grant succeeded. B: Of course (The process is practically the same as with SQLPLUS) Why not C? I think it says "Oracle Cloud Infrastructure service console" and it is NOT really done from the console, but from the "Database Actions" link, which is another service.
upvoted 1 times
Ganmook
3 years, 3 months ago
I think this question asks about autonomous DB service than shell access way.
upvoted 1 times
...
...
TanTran
3 years, 4 months ago
B and C correct
upvoted 2 times
...
eduardoosti
3 years, 4 months ago
B and C https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-users-create.html#GUID-54CA837B-CD6A-4ED2-A960-5874535818CB
upvoted 2 times
jcamt
3 years, 1 month ago
It's difficult to say because the documentation says "You can create users by connecting to the database as the ADMIN user using any SQL client tool." SQLPLus is included
upvoted 1 times
...
...
MNR
3 years, 7 months ago
should be B and C
upvoted 1 times
...
pkriyaz
3 years, 7 months ago
Yes, C is also correct
upvoted 1 times
...
fhoyos
3 years, 7 months ago
I think C is also valid. It makes three options as valid
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