最新的Oracle 1z1-076免費考試真題

問題1

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. An undersized undo tablespace on the logical standby

B. Many SQL apply operations do full table scans

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

D. An undersized shared pool

E. An increased number of bulk updates on the primary

F. An increased number of bulk inserts on the primary

正確答案: A,B,D,E

說明：（僅 Fast2test 成員可見）

問題2

Which four statements are true regarding SQL Apply filters for a logical standby database?

A. They can be used to stop SQL apply if it encounters an error.

B. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.

C. They can be used to skip ALTER TABLE commands on specific tables.

D. They can only be used to skip DML statements on a table.

E. They can be used to skip ALTE1 STEM and ALTER DATABASE commands.

F. They can be used to skip CREATE TABLE commands.

G. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).

正確答案: B,C,E,F

說明：（僅 Fast2test 成員可見）

問題3

Examine this list of possible steps:
1. Raise the compatibility level on both databases.
2. Restart SQL Apply on the upgraded logical standby database.
3. Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database.
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

A. 4,6,5,2,3,1

B. 5,2,4,6,3,1

C. 5,2,4,1

D. 1,5,2,4,6,3

E. 5,2,4,3,6,1

正確答案: D

說明：（僅 Fast2test 成員可見）

問題4

Which TWO are benefits of using Transaction Guard in a Data Guard environment?

A. It protects against recoverable errors during a planned or an unplanned outage of a primary database.

B. It protects against logical corruptions being replicated to standby databases.

C. It provides application continuity by replaying transactions interrupted by a failover or a switchover

D. It provides application continuity by rolling back uncommitted transactions interrupted by a failover or switchover.

E. It protects against user errors being replicated to standby databases.

正確答案: A,D

說明：（僅 Fast2test 成員可見）

問題5

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

A. Create an SPFILE for the standby database.

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

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

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

E. Create a standby control file.

正確答案: B,C

問題6

Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?

A. The configuration will be in Maximum Availability mode.

B. Sheep will be in the disabled state.

C. The configuration will be in Maximum Performance mode.

D. Dogs will be in the disabled state and has to be manually reinstated.

E. Sheep will be in the enabled state.

正確答案: A,D,E

說明：（僅 Fast2test 成員可見）

問題7

Your Data Guard environment has one physical standby database using Real-Time Query. Two sequences have been created by these SQL statements:

Neither sequence has been used since being created.
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL; SELECT b.nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?
Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?
A)

B)

C)

A. Option D

B. Option B

C. Option C

D. Option A

正確答案: C

說明：（僅 Fast2test 成員可見）

問題8

You are licensed to use Oracle Active Data Guard.
Which TWO statements are true after enabling block change tracking on a physical standby database?

A. It starts the CTWR process on the primary database instance.

B. It allows fast incremental backups to be taken on the primary database.

C. It allows fast incremental backups to be offloaded to the physical standby database.

D. It starts the RVWR process on the physical standby database instance.

E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database is converted.

F. It starts the CTWR process on the physical standby database instance.

正確答案: C,D

說明：（僅 Fast2test 成員可見）

問題9

Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

A. Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.

B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.

C. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE.

D. Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host.

E. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners.

正確答案: B,E

最新的Oracle Database 19c: Data Guard Administration - 1z1-076免費考試真題

聯系我們

站內鏈接

最新更新