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

Question 86

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 RESETLOGSoperation.

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 before images of blocks, so that redo data may be used to roll forward to the desired flashback time.

Question 87

An administrator account is granted the CREATE SESSION andSET CONTAINERsystem privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?

A.You can conned as a common user by using the connect statement.

B.You can connect as a local user by using the connect statement.

C.You can connect by using easy connect.

D.You can connect by using OS authentication.

E.You can connect by using a Net Service name.

F.You can connect as a local user by using the SET CONTAINER statement.

Question 88

You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

A.User session data

B.Stack space

C.Private SQL area

D.Location of the runtime area for DML and DDL Statements

E.Location of a part of the runtime area for SELECT statements

Question 89

What are three purposes of the RMAN "FROM" clause?

A.to support PUSH-based active database duplication

B.to support synchronization of a standby database with the primary database in a Data environment

C.To support PULL-based active database duplication

D.To support file restores over the network in a Data Guard environment

E.To support file recovery over the network in a Data Guard environment

Question 90

What are three purposes of the RMAN "FROM SERVICE" clause? (Choose three.)

A.to support synchronization of a standby database with the primary database in a Data Guard environment

B.to support file restoration over the network in a Data Guard environment

C.to support file recovery over the network in a Data Guard environment

D.to support PUSH-based active database duplication

E.to support active database duplication by taking image copies of the source database

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 86

Question 87

Question 88

Question 89

Question 90

Download PDF File