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

Question 16

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 17

Thetnsnames.orafile has anentry for the servicealiasORCL as follows:

The TNS ping commandexecutes successfullywhen tested withORCL;however, from the same OS user session, you are not able toconnect to the databaseinstance with thefollowing 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.

Question 18

The tnsnames.ora file has an entry for the service alias ORCL as follows: The TNS ping 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.

Question 19

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose three.)

A.Reduced logical I/O

B.Reduced virtual memory utilization

C.Improved parallel Execution performance

D.Improved Serial Execution performance

E.Reduced physical I/O

F.Reduced CPU utilization

Question 20

You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEEStable in the SECURESPACEtablespace with the SALToption on the EMPLOYEEcolumn.
Which is true about the result?

A.It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.

B.It generates an error when creating the table because the wallet is closed.

C.It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.

D.It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

Latest Upload: 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 156TheSecOpsGroup.CNSP.v2025-09-08.q20; 207CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 145Salesforce.Data-Architect.v2025-09-05.q216; 137Adobe.AD0-E605.v2025-09-05.q50; 180Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 16

Question 17

Question 18

Question 19

Question 20

Download PDF File