Online Access Free Oracle.1Z1-060.v2021-08-31.q180 Practice Test (Page 16)

1Z1-060 Exam Question 71

A redaction policy was added to the SAL column of the SCOTT.EMP table:

All users have their default set of system privileges. For which three situations will data not be redacted?

A.SYS sessions, regardless of the roles that are set in the session

B.SYSTEM sessions, regardless of the roles that are set in the session

C.SCOTT sessions, only if the MGR role is set in the session

D.SCOTT sessions, only if the MGR role is granted to SCOTT

E.SCOTT sessions, because he is the owner of the table

F.SYSTEM session, only if the MGR role is set in the session

1Z1-060 Exam Question 72

You create a table with the PERIOD FORclause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEEStable?

A.The valid time columns employee_time_start and employee_time_end are automatically created.

B.The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

C.The validtimecolumns are not populated by the Oracle Server automatically.

D.The validtimecolumns arevisible by default when the table is described.

E.Setting the session valid time using
DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for datamanipulation language (DML), data definition language (DDL), and queries performed by the session.

1Z1-060 Exam Question 73

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

A.BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

B.BACKUP SPFILE SECTION SIZE 1M;

C.BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

D.BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

E.BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

F.BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

G.BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

1Z1-060 Exam Question 74

You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:

What is the result?

A.The file `+data.231.45678' is physically relocated to `+data/prod' and renamed as `myfile.dbf'.

B.The file `+data.231.45678' is renamed as `myfile.dbf', and copied to `+data/prod'.

C.The file `+data.231.45678' remains in the same location andasynonym'myfile.dbf' is created.

D.The file `myfile.dbf' is created in `+data/prod' and the reference to `+data.231.45678' in the data dictionary removed.

1Z1-060 Exam Question 75

You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
* RANDOM redaction on the SAL and COMM columns
* PARTIAL redaction on the HIREDATE column
* FULL redaction on the MGR column
What would you define to implement this?

A.several redaction policies, with one redaction policy for each data type defined for the table that must be redacted

B.several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type

C.one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted

D.several redaction policies, with one redaction policy for each table column that must be redacted

Other Version: 68Oracle.Latestcram.1Z1-060.v2022-05-23.by.verna.110q.pdf; 2149Oracle.1Z1-060.v2022-04-28.q110; 115Oracle.Pass4training.1Z1-060.v2021-08-16.by.jennifer.153q.pdf

Latest Upload: 102SAP.C_ABAPD_2507.v2025-09-12.q56; 102SAP.C_TS452_2022.v2025-09-12.q83; 171ACSM.020-222.v2025-09-11.q48; 157VMware.5V0-31.23.v2025-09-10.q73; 131Oracle.1z0-915-1.v2025-09-10.q24; 160Citrix.1Y0-231.v2025-09-10.q87; 137SAP.C-THR85-2505.v2025-09-09.q29; 166Adobe.AD0-E727.v2025-09-09.q76; 130Oracle.1Z0-1123-25.v2025-09-09.q20; 136SAP.C_SIGPM_2403.v2025-09-08.q20

1Z1-060 Exam Question 71

1Z1-060 Exam Question 72

1Z1-060 Exam Question 73

1Z1-060 Exam Question 74

1Z1-060 Exam Question 75

Download PDF File