Free Access Oracle.1Z0-082.v2022-07-18.q111 Practice Test (Page 20)

Question 91

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 three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

A.analysis of all privileges used by all users including administrative users in the database

B.analysis of all privileges used by all users but excluding administrative users in the database

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

Question 92

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

A.It generates a sql script that it uses to load data from EMP.DAT to EMP

B.It appends data from EMP.DAT to EMP

C.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

D.It overwrites data in EMP with data in EMP.DAT

E.It uses the database buffer cache to load data

Question 93

Which three statements are true about Oracle synonyms? (Choose three.)

A.A synonym cannot be created for a PL/SQL package

B.A synonym can be available to all users

C.A SEQUENCE can have a synonym

D.A synonym created by one user can refer to an object belonging to another user

E.Any user can drop a PUBLIC synonym

Question 94

Which two statements are true about the PMON background process? (Choose two.)

A.It registers database services with all local and remote listeners known to the database instance

B.It frees resources held by abnormally terminated processes

C.It records checkpoint information in the control file

D.It frees unused temporary segments

E.It kills sessions that exceed idle time

Question 95

Which two statements are true about the DUAL table? (Choose two.)

A.It can be accessed only by the SYS user

B.It consists of a single row and single column of VARCHAR2 data type

C.It can display multiple rows but only a single column

D.It can be used to display only constants or pseudo columns

E.It can be accessed by any user who has the SELECT privilege in any schema

F.It can display multiple rows and columns

Other Version: 2581Oracle.1Z0-082.v2023-08-24.q111; 1630Oracle.1Z0-082.v2023-03-31.q49; 5326Oracle.1Z0-082.v2022-03-27.q110; 6225Oracle.1Z0-082.v2022-02-11.q110; 98Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 119Microsoft.MS-700.v2025-12-27.q286; 110SAP.C-BCFIN-2502.v2025-12-27.q12; 115SAP.C-BCBTM-2502.v2025-12-26.q9; 122SAP.C_THR89_2505.v2025-12-26.q45; 115SAP.C-BCBTM-2509.v2025-12-26.q10; 166IAPP.AIGP.v2025-12-25.q64; 146CISI.UAE-Financial-Rules-and-Regulations.v2025-12-25.q35; 178SAP.C-S4TM-2023.v2025-12-25.q82; 128EMC.D-VXR-DS-00.v2025-12-24.q43; 184Splunk.SPLK-5001.v2025-12-24.q37

Question 91

Question 92

Question 93

Question 94

Question 95

Download PDF File