Online Access Free Oracle.1z0-062.v2022-01-28.q200 Practice Test (Page 24)

1z0-062 Exam Question 111

Examine the parameters:
Your database instance is started with a PFILE.

You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?

A.Change is applied to the current instance, but does not persist after instance restart.

B.The value is changed for the current instance and in the PFILE.

C.It fails because the SCOPE clause is missing.

D.The value is changed only in the PFILE and takes effect at the next instance startup.

1z0-062 Exam Question 112

Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?

A.System privileges apply only to the PDB in which they are used.

B.Local users cannot use local system privileges on the schema of a common user.

C.The granter of system privileges must possess the set container privilege.

D.Common users connected to a PDB can exercise privileges across other PDBs.

E.System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

1z0-062 Exam Question 113

Which three database operations can be performed only at MOUNT state? (Choose three.)

A.enabling or disabling ARCHIVELOG mode

B.re-creating control files

C.performing full database recovery

D.performing Flashback Database

E.renaming control files

1z0-062 Exam Question 114

Which two tasks can be performed on an external table?

A.creating a view

B.creating an invisible index

C.updating the table by using an update statement

D.partitioning the table

E.creating a public synonym

1z0-062 Exam Question 115

Examine the parameter settings in your local ORCL database:

Examine the parameter settings for the remote SALES database:

As the SYS user, you issue the following command on ORCL:
CREATE PUBLIC DATABASE LINK sales.us.example.com USING 'sales1';
The sales1 tnsnames entry points to the sales database instance.
Which two are requirements to ensure that you can successfully connect by using this database link?

A.TheGLOBAL_NAMESinitialization parameter should be set toFALSEin
theORCLdatabase.

B.TheREMOTE_OS_AUTHENTinitialization parameter should be set to FALSE in the remote database.

C.Only the user creating the database link must have an account and the required privileges in the remote database.

D.Local database users who use this database link should have accounts and the required privileges in the remote database.

E.TheSALES1net service name should be known to both the local and remote databases.

Other Version: 71Oracle.Exam4docs.1z0-062.v2021-08-01.by.louise.171q.pdf

Latest Upload: 256ISACA.CGEIT.v2025-09-19.q537; 153Fortinet.FCP_FWF_AD-7.4.v2025-09-18.q62; 154Scrum.SAFe-Practitioner.v2025-09-18.q63; 146Workday.Workday-Prism-Analytics.v2025-09-17.q17; 131Oracle.1Z0-1055-24.v2025-09-17.q28; 129Oracle.1Z1-182.v2025-09-17.q32; 243Nutanix.NCP-US-6.5.v2025-09-16.q73; 263Oracle.1z0-071.v2025-09-16.q232; 203Oracle.1Z1-922.v2025-09-16.q125; 323CyberArk.PAM-CDE-RECERT.v2025-09-15.q100

1z0-062 Exam Question 111

1z0-062 Exam Question 112

1z0-062 Exam Question 113

1z0-062 Exam Question 114

1z0-062 Exam Question 115

Download PDF File