Exam 1z0-082 topic 1 question 63 discussion

i would say B, E , F are correct!

A - E - F CORRECT!!!! A - Right - We can analyze the administrative user, the oracle just excludes the SYS user B - Wrong, oracle does not delete administrative user, like question A, only SYS user C - Wrong - We cannot analyze the permission of the scheme itself D - Wrong - We cannot analyze the privilege of our schema E - Right - we can analyze the permission that was given directly. F - Right - we can analyze the permission that was given indirectly.

B, E, F is correct!

a tip, this procedure analized if you had used a privilege not is you have.. "You then can determine the privileges that your users are using and not using." what do you think?

SYS, SYSTEM, SYSBACKUP, SYSDG, SYSKM, SYSRAC, SYSMAN, and DBSNMP are administrative users as reported in 19c Database Administrator’s Guide, Par. 7.5 (Predefined User Accounts): Furthermore (19c Database PL/SQL Packages and Types Reference) given that DBMS_PRIVILEGE_CAPTURE.CREATE_CAPTURE "Analyzes all privilege use, except privileges used by the SYS user.", it follows that A cannot be right since SYS is included in "administrative users" The DBMS_PRIVILEGE_CAPTURE works on database, role and context level. Therefore B is right and C, D are not. E, F are right as "When using role-based analysis for the CREATE_CAPTURE procedure, privilege use is analyzed even if the privilege is indirectly granted to the specified role."

https://www.databasejournal.com/oracle/oracle-database-12c-new-privilege-management-features/

Provided answer are wrong. C, D, and F the correct answer, everything described here: https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_PRIVILEGE_CAPTURE.html

A. analysis of all privileges used by all users including administrative users in the database --> False, SYS is excluded B. analysis of all privileges used by all users but excluding administrative users in the database -->False, SYSTEM is included. C. analysis of privileges that a user has on their own schema objects that they did not use D. analysis of privileges that a user has on their own schema objects that they did use E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role F. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

A C E is the correct answer

A says: " including administrative users". The definition of administrative users is here: https://docs.oracle.com/database/121/ADMQS/GUID-CF1CD853-AF15-41EC-BC80-61918C73FDB5.htm#ADMQS12003 So as SYS is excluded from the analysis, I can say A is wrong.

A. An undo segment may be used by multiple transactions simultaneously - True B. Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment - True (undo segment act as a circular buffer) C. Undo segments have a minimum of three extents - False (each segment has a minimum of two extents) D. Undo segments can extend when a transaction fills the last extent of the undo segment - True (Undo tablespace are locally managed with auto extent allocation ) E. A single transaction may use multiple undo segments simultaneously - False F. Undo segments must be stored in a BIGFILE tablespace - False G. Undo segments must be stored in a SMALLFILE tablespace - False (DBCA automatically creates a smallfile undo tablespece, but it can be configured as bigfile table space as well) So correct answers are: A, B, D

sorry BEF is definitely correct

the correct answer is AEF

Anybody have answer for this question after exam?

we can analyze all users except SYS, i dunno but answer B saying all users except administrative Users! You cannot analyze the privileges of the SYS user. https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/performing-privilege-analysis-find-privilege-use.html#GUID-AD683DDB-D345-4702-B1F4-37B79F276B66

C, D are wrong! Privileges in own Schema can not be analyzed!

DEF - i think Database privilege analysis enables you to create a policy that records the usage of system and object privileges that have been granted to users. You then can determine the privileges that your users are using and not using. From there, you can revoke any unused privileges, thereby reducing the number of excess privilege grants for users. C- you can analize only used privileges, but then determine the unsued privileges F - When using role-based analysis for the CREATE_CAPTURE procedure, privilege use is analyzed even if the privilege is indirectly granted to the specified role.