Free Access Oracle.1Z1-060.v2022-03-23.q171 Practice Test (Page 9)

Question 36

You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
* RANDOM redaction on the SALand COMMcolumns
* PARTIAL redaction on the HIREDATEcolumn
* FULL redaction on the MGRcolumn
What would you define to implement this?

A.several redaction policies, with one redaction policy foe each data type defined for the table 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

Question 37

Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?

A.None of the data definition language (DDL) statements are logged in the trace file.

B.Only DDL commands that resulted in errors are logged in the alert log file.

C.A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.

D.Only DDL commands that resulted in the creation of new database files are logged.

Question 38

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database? (Choose two.)

A.Effectively implements role separation

B.Enables you to take advantage of Oracle Managed Files.

C.Automatically registers the database with Oracle Restart.

D.Helps you to easily upgrade the database from a prior release.

E.Enables the Installation of Grid Infrastructure files on block or raw devices.

Question 39

Your database is open and the LISTENERlistener running. You stopped the wrong listener LISTENERby issuing the following command:
lsnrctl > STOP
What happens to the sessions that are presently connected to the database Instance?

A.They are able to perform only queries.

B.They are not affected and continue to function normally.

C.They are terminated and the active transactions are rolled back.

D.They are not allowed to perform any operations until the listener LISTENERis started.

Question 40

The tnsnames.ora file has an entry for the service alias ORCL as follows:

The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?

A.The listener is not running on the database node.

B.The TNS_ADMIN environment variable is set to the wrong value.

C.The orcl.oracle.com database service is not registered with the listener.

D.The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.

E.The listener is running on a different port.

Latest Upload: 120Scrum.PSPO-III.v2026-09-10.q23; 216Scrum.PSPO-I.v2026-09-09.q157; 184ScaledAgile.SAFe-SPC.v2026-09-08.q108; 144Oracle.1Z0-1033-26.v2026-09-08.q43; 213Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 160BCI.CBCI.v2026-09-07.q89; 200Salesforce.Plat-Admn-202.v2026-09-07.q170; 168Fortinet.NSE7_SSE_AD-25.v2026-09-05.q85; 249Microsoft.PL-400.v2026-09-05.q375; 339Snowflake.DEA-C01.v2026-09-04.q215

Question 36

Question 37

Question 38

Question 39

Question 40

Download PDF File