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

出題：1

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 メンバーにのみ表示されます)

出題：2

Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker?

A. If the primary database is a container database, then a logical standby may be a non-container database.

B. After a role change, the broker opens all Pluggable databases (pdbb) on the new primary.

C. If the primary database is not a container database, then a standby may be a container database.

D. All broker actions execute at the root container for container databases.

E. If the primary database is a container database, then a physical standby may be a non-container database.

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

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

出題：3

You notice that the SQL apply lag on your logical standby database has increased but the redo transport lag has not.
Which four could be reasons for the increase in SQL apply lag?

A. Many SQL apply operations do full table scans

B. An increased number of bulk updates on the primary

C. An undersized shared pool

D. An undersized undo tablespace on the logical standby

E. The standby redo log files are undersized on the primary database

F. An increased number of bulk inserts on the primary

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

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

出題：4

Active Data Guard (ADG) databases are widely used to offload reporting or ad hoc query-only jobs from the primary database. Reporting workload profile is different from the primary database and often requires tuning.
Which tool is used to tune SQL workloads running on an ADG database?

A. Standby Statspack

B. SQL Tuning Advisor

C. Automatic Workload Repository (AWR)

D. Automatic Diagnostic Database Monitor (ADDM)

E. In-Memory Active Session History (ASH)

正解：C 解答を投票する

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

出題：5

On your logical standby database, you specified these rules:

After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:

Which is TRUE regarding the execution of the UNSKIP procedure?

A. It succeeds but the SQL Apply filters are not deleted.

B. It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.

C. It succeeds only if SQL apply is stopped before deleting the SQL Apply filter.

D. It deletes both the SQL Apply filters.

E. It returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added.

正解：D 解答を投票する

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

出題：6

Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances?

A. Client TNS entries for the databases use the correct service names for the intended service.

B. The LOCAL_LISTENER parameter on the primary database instance must always be set.

C. A service name is registered with the local listener of each database instance.

D. The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.

E. Oracle Net connectivity to the primary database instance must be established on all the standby database instances.

F. The client applications must use the correct TNS entries when requesting connections to the database instances.

G. The standby database services must be defined statically with the Listeners running on the standby database hosts.

正解：A,F,G 解答を投票する

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

出題：7

Which three are prerequisites for enabling Fast-Start Failover?

A. You can specify only one standby database as the fast-start failover target.

B. The configuration must be operating in either Maximum Performance or Maximum Protection mode.

C. The maximum protection mode can be used, but with two or more standby databases.

D. The Data Guard environment must be managed by the Data Guard Broker.

E. Flashback Database must be enabled only on the Fast-Start Failover target standby database.

F. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.

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

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

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