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

Question 166

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 a user.
2. A user should not be able to create more than four simultaneous sessions.
3. A 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?

A.by granting a secure application role to the users

B.by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENTparameter to FALSE

C.By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4

D.By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.

E.By implementing the database resource Manager plan and setting the
SEC_MAX_FAILED_LOGIN_ATTEMPTSparameters to 4.

Question 167

Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

A.Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.

B.Run the Automatic Workload Repository (AWR) report.

C.Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.

D.Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

E.Run the Automatic Database Diagnostic Monitor (ADDM).

Question 168

Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

A.Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.

B.Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.

C.Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB.

D.Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.

E.Use the DBMS_PDB package to clone an existing PDB.

Question 169

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?

A.by granting a secure application role to the users

B.by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENTparameter to FALSE

C.By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4

D.By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.

E.By implementing the database resource Manager plan and setting the
SEC_MAX_FAILED_LOGIN_ATTEMPTSparameters to 4.

Question 170

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

A.The ROW ARCHIVAL VISIBILITY session parameter defaults to all rows.

B.The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

C.The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

D.The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

E.Visibility of the ORA_ARCHIVE_STATE column is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

Latest Upload: 121Adobe.AD0-E911.v2026-09-12.q35; 117Google.ADP.v2026-09-11.q22; 130AIChE.CCPSC.v2026-09-11.q41; 130Scrum.PSPO-III.v2026-09-10.q23; 220Scrum.PSPO-I.v2026-09-09.q157; 188ScaledAgile.SAFe-SPC.v2026-09-08.q108; 147Oracle.1Z0-1033-26.v2026-09-08.q43; 220Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 166BCI.CBCI.v2026-09-07.q89; 208Salesforce.Plat-Admn-202.v2026-09-07.q170

Question 166

Question 167

Question 168

Question 169

Question 170

Download PDF File