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

Question 66

You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file?

A.It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

B.It contains username and passwords of database users who are members of the OSOPERoperating system group.

C.It contains usernames and passwords of database users who are members of the OSDBAoperating system group.

D.It will permit the use of lowercase passwords for database users who have granted the SYSDBArole.

E.It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBArole.

Question 67

Examine these two statements:

Which three are true about the MRKTtablespace? (Choose three.)

A.Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

B.The MRKTtablespace may be dropped if it has no contents.

C.The MRKTtablespace is created as a smallfile tablespace, because the file size is less than the minimum required for bigfile files.

D.No more data files can be added to the tablespace.

E.The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKTtablespace.

Question 68

Oracle Data Redaction is active on the SCOTT.EMPtable.
You queried the table twice.
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

Which is guaranteed to be true concerning the redaction policy?

A.FULL redaction is active on the SAL column

B.RANDOM redaction is active on the MGR column

C.PARTIAL redaction is active on the MGR column.

D.RANDOM redaction is active on the HIREDATE column

E.PARTIAL redaction is active of the HIREDATE column.

Question 69

Examine the current values for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

A.It succeeds only if memory is available from the autotuned components if SGA.

B.It fails because an increase in DB_8K_CACHE_SIZEcannot be accommodated within SGA_TARGET.

C.It fails because the DB_8K_CACHE_SIZEparameter cannot be changed dynamically.

D.It fails because an increase in DB_8K_CACHE_SIZEcannot be accommodated within SGA_MAX_SIZE.

Question 70

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12c.
Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.
After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.
How do you accomplish this?

A.Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.

B.Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.

C.Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITORview.

D.Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITORfunction to view the required information.

Latest Upload: 103OCEG.GRCP.v2025-09-11.q211; 102HP.HPE0-V27.v2025-09-11.q78; 118Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 157PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 147Salesforce.Data-Architect.v2025-09-05.q216; 141Adobe.AD0-E605.v2025-09-05.q50

Question 66

Question 67

Question 68

Question 69

Question 70

Download PDF File