exam questions

Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 78 discussion

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

Which three are true in Oracle 19c and later releases? (Choose three.)

  • A. If the password file location changes, then the new location is used automatically by the Oracle Server.
  • B. Schema Only accounts can be granted administrator privileges.
  • C. All the Oracle-supplied accounts are Schema Only accounts.
  • D. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
  • E. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
  • F. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
Show Suggested Answer Hide Answer
Suggested Answer: BCD 🗳️
Reference:
https://mandysandhu.com/2018/04/30/oracle-database-18c-schema-only-accounts/

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
veginha
Highly Voted 4 years ago
BDF You can grant administrative privileges, such as SYSOPER and SYSBACKUP, to schema-only (passwordless) accounts. (B correct) -Privilege analysis is now available as part of Oracle Database Enterprise Edition. (D correct) -The unified auditing top-level statements feature enables you to audit top-level user (direct user) activities in the database without collecting indirect user activity audit data. (F correct) https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html
upvoted 23 times
marcinb32
4 years ago
BDF is correct
upvoted 4 times
...
...
acesonly
Most Recent 1 month, 3 weeks ago
Selected Answer: BDF
I've checked it myself, answer BDF is correct.
upvoted 1 times
...
antonica
3 months, 2 weeks ago
B is not correct
upvoted 1 times
acesonly
1 month, 3 weeks ago
Check again, 'B' is correct: https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-5A1DE85F-6485-402E-9D76-34D63186E555
upvoted 1 times
...
...
antonica
3 months, 2 weeks ago
alter user c##test_sysdba no authentication Error report - ORA-40367: An Administrative user cannot be altered to have no authentication type. 40367. 00000 - "An Administrative user cannot be altered to have no authentication type." *Cause: An attempt was made to alter an administrative user to have no authentication type. *Action: Revoke administrative privilege from the user before attempting to alter the user.
upvoted 1 times
...
_gio_
1 year ago
Selected Answer: BDF
here the references: https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-5490FE65-562B-49DC-9246-661592C630F9
upvoted 1 times
...
Neil107
2 years, 11 months ago
It's BDE.
upvoted 3 times
...
janw
3 years, 10 months ago
BDF it is
upvoted 3 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