최신 1Z0-182 무료덤프 - Oracle Database 23ai Administration Associate

A. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

B. Analysis of all privileges used by the SYS user.

C. Analysis of privileges that a user has on their own schema objects.

D. Analysis of privileges that a user has on other schemas' objects.

E. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.

A. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.

B. Only the owner of a Unified Audit Policy can purge audit records by resetting the policy.

C. Only viewed audit records can be purged from Unified Audits.

D. Use DBMS_AUDIT_MGMT.CREATE_PURGE_JOB as a privileged user to schedule an automatic purge job.

E. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.

F. Use DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL as a privileged user to manually purge audit records.

A. Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated.

B. Optimizer Statistics are collected by the Statistics Advisor.

C. Optimizer Statistics are collected automatically by an automatic maintenance job that runsduring predefined maintenance windows.

D. Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot.

E. Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures.

A. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

B. Oracle Net Manager can be used to locally configure naming methods on a database server.

C. Oracle Net Manager can be used to centrally configure listeners on any database server target.

D. The Oracle Net Configuration Assistant is only used when running the Oracle installer.

E. The lsnrctl utility requires a listener.ora file to exist before it is started.

A. From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

B. From the PDB, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfile$;

C. From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfiles;

D. From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;

A. Data files are closed normally.

B. Subsequent instance startup performs instance recovery.

C. A checkpoint is written.

D. Uncommitted transactions are not rolled back by the shutdown.

E. Subsequent instance startup performs media recovery.

A. One instance on one server mounting and opening one database.

B. One instance on one server mounting multiple databases.

C. One instance on one server mounting and opening multiple databases.

D. One instance on one server that has no database mounted.

E. Two or more instances on separate servers all mounting and opening the same database.

A. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

B. Analysis of privileges that a user has on their own schema objects that they did use.

C. Analysis of all privileges used by all users but excluding administrative users in the database.

D. Analysis of privileges granted indirectly to a role that are then used by a user who has beengranted that role.

E. Analysis of privileges that a user has on their own schema objects that they did not use.

F. Analysis of all privileges used by all users including administrative users in the database.

A. DML may be performed on tables with one or more extents in this data file during the execution of this command.

B. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

C. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

D. The file is renamed and stored in the same location.

E. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

A. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.

B. They support DELETEs, which transparently deletes records in the file system as if they were table rows.

C. They can be queried while the database is in the MOUNT state like dynamic performance views.

D. They can be queried, transformed, and joined with other tables without having to load the data first.

E. They support UPDATEs, which transparently updates records in the file system as if they were table rows.