1z0-076試験無料問題集（72題）「Oracle Database 19c: Data Guard Administration 認定」

出題：1

Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package?

A. starting media recovery on all the Leading Group Standby databases

B. creating a guaranteed restore point on the primary database

C. converting the designated physical standby database into a logical standby database

D. creating a guaranteed restore point on the standby databases

E. switching the primary database to the logical standby role

F. building a LogMiner dictionary on the primary database instance

正解：B,D,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

You must configure flashback database for your Oracle 19c databases that will be part of a Data Guard Broker configuration.
The databases are all in ARCHIVELOG mode.
You will execute the SQL statement:
ALTER DATABASE FLASHBACK ON;
Which three are true concerning this command?

A. If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all physical standby databases that are part of the configuration.

B. It will execute successfully while an Oracle 19c primary database is mounted.

C. It will execute successfully while an Oracle 19c primary database is open.

D. It will execute successfully on an Oracle 19c physical standby database while Real Time Query is active.

E. If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all logical standby databases that are part of the configuration.

F. It will execute successfully on an Oracle 19c logical standby database while SQL apply is active.

正解：B,C,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

Which THREE statements are true about Far Sync instances?

A. The Data Guard Broker must be used to deploy and manage Far Sync instances.

B. They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary.

C. A primary database can ship redo directly to multiple Far Sync instances.

D. They work with any protection level.

E. They use an spfMe, a standby controlfile, and standby redo logs.

正解：A,B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Examine the following parameter settings of the physical standby database:
* STANDBY_FILE_MANAGEMENT=AUTO
* ENABLED_PDBS_ON_STANDBY=<null>
During which TWO tasks are files automatically created in the physical standby database after structure changes on the primary database?

A. Renaming a data file in the primary database

B. Adding or dropping a redo file group

C. Performing transportable tablespaces

D. Adding a data file or creating a tablespace

E. Creating a PDB from the existing PDB within the same CDB

正解：D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Examine the fast-start failover configuration:

A. A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database

B. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.

C. You must disable fast-start failover first to change the fast-start failover target to East sales.

D. If South_Sales develops a problem and cannot be the target of a failover, the broker automatically changes the fast-start failover target to one of the other candidate targets.

E. The observer is running.

正解：A,B,E 解答を投票する

出題：6

Your Data Guard environment contains a four-instance RAC primary database whose SID is PROD and a RAC physical standby database whose std is PROD_SBY.
Examine the command executed on a node of the primary database cluster to create a service OLTPWORKLOAD that the applications will use to connect to the database when it is in the FRlMARYTclatabase role:
srvctl add service -db PROD -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150 The service is then started Consider this list of tasks:
1. On a node of the standby database cluster execute:
srvctl add service -db PROD_SBY -service oltpworkload -role PRIMARY -failovertype SESSION
-failovermethod BASIC -failoverdelay 10 -failoverretry 150
2. On the primary database, create the oltpworkload database service using the dbms_service.create_service procedure.
3. Configure tap for clients in the tnsnames.ora files.
4. Make sure clients use the OLTPWORKLOAD service to connect to the database instances.
5. On the standby database, create the oltpworkload database service using the dbms_service.create_servi;l procedure.
Identify the required steps to configure and use Transparent Application Failover (taf).

A. 4

B. 1.4

C. 2,3,4

D. 5

E. 1,3,4

F. 3,4

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Which THREE statements are true........ open in real time query mode, which becomes a new.

A. Sessions that have long running queries can be retained.

B. User sessions can be retained.

C. User sessions and Current Buffers are maintained by default.

D. All sessions are disconnected and all

E. All current buffers can be retained.

F. Sessions that are using database links

正解：B,D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1z0-076試験無料問題集「Oracle Database 19c: Data Guard Administration 認定」