Free Access Oracle.1Z0-060.v2022-02-12.q102 Practice Test (Page 9)

Question 36

Which two are prerequisites for performing a flashback transaction?

A.Flashback Database must be enabled.

B.Undo retention guarantee for the database must be configured.

C.EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

D.Supplemental logging must be enabled.

E.Recycle bin must be enabled for the database.

F.Block change tracking must be enabled tor the database.

Question 37

Examine the contents of a SQL*Loader control file:

Which three statements are true regarding the SQL*Loader operation performed by using the control file?
(Choose three.)

A.An EMP table is created if a table does not exist. Otherwise, the EMP table is appended with the loaded data.

B.The SQL*Loader data file myfile1.dat has the column names for the EMP table.

C.The SQL*Loader operation fails because no record terminators are specified.

D.Field names should be on the first line in both the SQL*Loader data files.

E.The SQL*Loader operation assumes that the data files are stream record format files with a normal carriage return string as the record terminator.

Question 38

Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX? (Choose two.)

A.Thread creation must be routed through a dispatcher process.

B.Each Oracle process runs an SCMN thread.

C.The local listener may pass the request to an existing process which in turn will create a thread.

D.Each multithreaded Oracle process has an SCMN thread.

Question 39

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 40

On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?

A.Both the indexes are created; however, only the ORD_COSTOMER index is visible.

B.The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.

C.Only the ORD_CUSTOMER_IX1 index is created.

D.Only the ORD_CUSTOMER_IX2 index is created.

E.Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

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; 162TheSecOpsGroup.CNSP.v2025-09-08.q20; 221CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 145Salesforce.Data-Architect.v2025-09-05.q216; 139Adobe.AD0-E605.v2025-09-05.q50; 184Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 36

Question 37

Question 38

Question 39

Question 40

Download PDF File