Oracle 1z0-182 Questions Answers

Oracle Database 23ai Administration Associate Questions and Answers

Question 25

You execute this command: [oracle@host01 ~]$ expdp system/oracle FULL=Y DUMPFILE=exp_db_full.dmp PARALLEL=4 LOGFILE=exp_db_full.log JOB_NAME=exp_db_full. During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=IMMEDIATE. Are you sure you wish to stop the job ([yes]/no): yes. Which two statements are true about the job?

Options:

It continues to run in the background.

You cannot monitor it.

You can reattach to it and monitor it.

It terminates.

Question 26

Which advisor is used to detect missing or stale object statistics?

Options:

SQL Tuning Advisor

SQL Statistics Advisor

SQL Performance Analyzer

SQL Access Advisor

Question 27

At which two container database levels can COMMON Unified Audit Policies be used?

Options:

COMMON Unified Audit Policies can only be created at CDB level to monitor DBA operation at any level.

At the CDB level.

At the Application Root level of an Application Container.

At any level by using the COMMON option in the policy.

At the PDB level if the policy is created by a COMMON user.

Question 28

You want to apply the principle of least privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which two types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?

Options:

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

Analysis of all privileges used by the SYS user.

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

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

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

Special Summer Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle Database 23ai Administration Associate Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

CompTIA

Fortinet

Microsoft

Salesforce