最新Oracle Database 19c 1z0-076考試題庫，Oracle 1z0-076課程的擬真試題下載

問題1
Your Data Guard environment consists of these components and settings:
A primary database supporting an OLTP workload
A remote physical standby database
Real-time query is enabled
The redo transport mode is set to SYNC
The protection mode is set to Maximum Availability
Which two statements are true regarding the DelayMins database property for the standby database?

A. It allows user errors on the primary to be recovered by using the physical standby database.

B. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.

C. It allows logical corruptions on the primary to be recovered by using the physical standby database.

D. It can only be enabled for a configuration in Maximum Performance mode.

E. It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

F. It can only be enabled for a configuration in Maximum Availability mode.

正確答案: A,C

問題2
Which two factors can cause an increase in redo transport lag?

A. Increase in network latency between the primary database and a redo transport destination.

B. The size of the online redo log files on the primary database.

C. Increase in redo generation rate on the primary database.

D. The size of the standby redo log files on the primary database.

E. The size of the online redo log files on the standby database.

正確答案: A,C

問題3
You are using Data Guard in conjunction with Global Database Services.
You have a Data Guard Broker configuration called Sales and a GDS pool called Prod.
Which three are true concerning the management of the broker configuration when using GDS?

A. DGMGRL may be used to add a single database to the Sales configuration even if Sales is a member of the Prod pool.

B. Adding a database to the Sales configuration with DGMGRL requires that the Sales configuration be disabled first. It must then be enabled after the new database is added to the configuration.

C. Adding a database to the Sales configuration with DGMGRL automatically adds the database to the Prod Pool.

D. Performing a role change with DGMGRL automatically notifies GDS which in turn activates the appropriate services.

E. DGMGRL may be used to add the Sales configuration to the Prod pool in gds.

正確答案: A,D,E

說明：（僅 NewDumps 成員可見）

問題4
You must configure on Oracle Data .......
1. A primary database
2. Three Physical Standby Databases
Examine these requirements:
A designated physical standby database should become the primary database automatically whenever the primary database fails.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?

A. FASTSYNC and Maximum Availability

B. FASTSYNC and Maximum Protection

C. SYNC and Maximum Protection

D. ASYNC and Maximum Performance

正確答案: A

說明：（僅 NewDumps 成員可見）

問題5
Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

A. You can set a critical threshold on the redo generation rate metric for a primary database.

B. You can set a warning threshold on the redo generation rate metric for a physical standby database.

C. You can monitor the redo apply rate on a logical standby database.

D. You can monitor the redo apply rate on a snapshot standby database.

E. You can check the potential data loss in the event of a disaster.

F. You can check if redo apply needs to be tuned.

正確答案: A,C,E

說明：（僅 NewDumps 成員可見）

問題6
Which TWO statements are true about Real-Time Query?

A. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.

B. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

C. Setting standby_max_data_delay=0 requires synchronous redo transport.

D. Real-Time Query sessions can be connected to a Far Sync instance.

E. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby databases opened read only.

正確答案: C,E

說明：（僅 NewDumps 成員可見）

問題7
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. 3,4

B. 1,3,4

C. 5

D. 4

E. 2,3,4

F. 1.4

正確答案: F

說明：（僅 NewDumps 成員可見）

問題8
Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN?

A. Create an SPFILE for the standby database.

B. Create a standby control file.

C. Run the nid utility to modify the DBID of the primary database.

D. Transfer a copy of the password file from the primary host to the standby host.

E. Configure Oracle Net connectivity between the primary host and the standby host.

正確答案: D,E

問題9
You created a physical standby database prodsbyi from the primary database prod using SQL and RMAN. Which THREE are prerequisites for creating a Data Guard Broker configuration to manage these databases?

A. The primary database must have supplemental logging enabled.

B. The DG_BROKER_START parameter must be set to TRUE for both database instances.

C. The LOG_ARCHIVE_DEST_n parameters with the service attribute set must be cleared.

D. The primary database must have FORCE LOGGING enabled.

E. The standby database must have supplemental logging enabled.

F. A local net service name to enable connectivity to the PRODSBYI database instance must be defined on the primary database host.

正確答案: A,B,F

說明：（僅 NewDumps 成員可見）

問題10
Which THREE are always benefits of using a logical standby database?

A. It can be used for database rolling release upgrades.

B. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.

C. It can be used to replicate a single pluggable database (PDB) in a multitenant container database.

D. It can be used for reporting workloads requiring additional indexes or materialized views or both.

E. It can be used for testing patchsets without affecting the primary database.

F. It can be used as an updatable database for Real Application Testing and then converted back to a standby database without affecting the updates.

正確答案: A,B,D

說明：（僅 NewDumps 成員可見）

先試後買

購買之前，你可以先嘗試下載一個試用版本。目前我們只提供PDF版本的試用DEMO，軟件版本只提供截圖。

專業認證

品質保證

輕松通過

Try Before Buy

最新的真實試題

相關鏈接

聯繫我們