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

Question 106

Which three statements are true about Flashback Database?

A.Flashback logs are written sequentially, and are archived.

B.Flashback Database uses a restored control file to recover a database.

C.The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

D.Flashback Database can recover a database to the state that it was in before a reset logs operation.

E.Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F.Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Question 107

Which three statements are true about Flashback Database? (Choose three.)

A.Flashback logs are written sequentially, and are archived.

B.Flashback Database uses a restored control file to recover a database.

C.The Oracle database automatically creates, deletes, and resizes flashback logs in the Fast Recovery Area.

D.Flashback Database can recover a database to the state that it was in before a RESETLOGS operation.

E.Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F.Flashback logs are used to restore the before images of blocks, so that redo data may be used to roll forward to the desired flashback time.

Question 108

Which two statements are true about variable extent size support for large ASM files? (Choose two.)

A.The metadata used to track extents in SGA is reduced.

B.Rebalance operations are completed faster than with a fixed extent size

C.An ASM instance automatically allocates an appropriate extent size for a file based on file size.

D.Resync operations are completed faster when a disk comes online after being taken offline.

E.Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

Question 109

Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false');
Which three statements are true about the effect of this command?

A.Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

B.Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

C.Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

D.Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

E.Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

Question 110

Which three statements are true about Oracle Data Pump export and import operations?

A.You can detach from a data pump export job and reattach later.

B.Data pump uses parallel execution server processes to implement parallel import.

C.Data pump import requires the import file to be in a directory owned by the oracle owner.

D.The master table is the last object to be exported by the data pump.

E.You can detach from a data pump import job and reattach later.

Latest Upload: 105OCEG.GRCP.v2025-09-11.q211; 104HP.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; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 149Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 106

Question 107

Question 108

Question 109

Question 110

Download PDF File