Oracle Exam 2022 1Z0-060 Dumps Updated Questions UPDATED Jun-2022 [Q120-Q140]

Q120. You are administering a database and you receive a requirement to apply the following restrictions:
1. A connection must be terminated after four unsuccessful login attempts by user.
2. A user should not be able to create more than four simultaneous sessions.
3. User session must be terminated after 15 minutes of inactivity.
4. Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?

Q121. Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command? (Choose three.)

Q122. Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

Q123. Which two statements are true about hot patching as compared to conventional patching? (Choose two.)

Q124. Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file
`/u01/app/oracle/oradata/CDB1/temp01.tmp’
ORA-27037: unable to obtain file status
Identify two ways to rectify the error.

Q125. Which two statements are true when row archival management is enabled? (Choose two.)

Q126. You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIMEelapsed.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?

Q127. 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?

Q128. Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’);
The possible outcome and actions to aggregate the trace files are as follows:
1.The command fails because a module name is not specified.
2.A trace file is created for each session that is running the SRV1 service.
3.An aggregated trace file is created for all the sessions that are running the SRV1 service.
4.The trace files may be aggregated by using the trcess utility.
5.The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?

Q129. While investigating a possible security breach, you realized that some audit records were not retrieved when the UNIFIED_AUDIT_TRAILview was queried.
How can you ensure that all available audit records are returned when the audit trail is queried?

Q130. You are planning the creation of a new multitenant container database (CDB) and want to store the ROOTand SEEDcontainer data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this? (Choose three.)

Q131. What is the effect of specifying the “ENABLE PLUGGABLE DATABASE” clause in a “CREATE DATABASE” statement?

Q132. You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?

Q133. 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?

Q134. Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to Issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

Q135. Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges:

Which statement is true about the common user created by the command?

Q136. Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table? (Choose two.)

Q137. Which statement is true concerning dropping a pluggable database (PDB)?

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

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

Q140. You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?