Oracle인증 실제 시험문제, 1z1-076 덤프문제집

문제1
Which two Data Guard features require the use of flashback database by the broker?

A. Far Sync Instances

B. Snapshot Standby databases

C. Fast-Start Failover

D. Real Time Query

E. Read-Mostly physical standby implementations

정답: B,C

문제2
Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

A. A TNS entry enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

B. To enable Real-Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

C. The LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.

D. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

E. To start SQL Apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.

정답: D

문제3
Examine the fast-start failover configuration:

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

B. The observer is running.

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

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

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

정답: B,C,D

문제4
Examine the procedure that you plan to execute on your logical standby:
SQL> EXECUTE DBMS_LOGSTDBY.SKIP(stmt => 'DML', schema_name => 'HR', object_name => 'EMPLOYEE'); What is a prerequisite for execution of this procedure?

A. Execute the DBMS_LOGSTDBY.APPLY_SET procedure to record errors that might cause SQL Apply to stop.

B. Stop SQL Apply on the logical standby database.

C. Change the redo transport mode if necessary to ASYNC.

D. Stop redo transport to the logical standby database.

정답: B

문제5
Which three are prerequisites for enabling Fast-Start Failover?

A. The Fast-Start Failover target standby database must receive REDO synchronously when the configuration operates in Maximum Availability mode.

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

C. Flashback Database must be enabled on the primary database.

D. The Fast-Start Failover target standby database may receive REDO either synchronously or asynchronously when the configuration operates in Maximum Performance mode.

E. A static service name must be configured only for the Fast-Start Failover target standby database.

정답: A,B,C

문제6
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. In-Memory Active Session History (ASH)

C. SQL Tuning Advisor

D. Automatic Workload Repository (AWR)

E. Automatic Diagnostic Database Monitor (ADDM)

정답: D

설명: (ITDumpsKR 회원만 볼 수 있음)

문제7
Which three statements are true....... With no Oracle Streams or Goldengate configured?

A. It is recommended to have them on the...

B. They are required on a logical standby for real-time apply

C. The LGWR process writes to them on ....

D. Only standby databases can write redo....

E. They are required only for synchronous redo transport

F. They are required on a physical standby for real-time apply.

정답: B,C,F

설명: (ITDumpsKR 회원만 볼 수 있음)

문제8
Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which set of actions will fulfill this requirement?

A. Set DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

B. Set the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.

C. Set the INSTANCE NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

D. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

정답: D

설명: (ITDumpsKR 회원만 볼 수 있음)

문제9
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 RVWR process on the physical standby database instance.

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

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

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

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

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

정답: A,B

설명: (ITDumpsKR 회원만 볼 수 있음)

문제10
Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. The redo transport mode is set to sync
4. Real-time query is enabled for both standby databases
5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?

A. Increase the size of the buffer cache on the physical standby database instances.

B. Decrease the redo log file size on the primary database.

C. Increase the number of standby redo log files on the standby databases.

D. Increase the size of standby redo log files on the standby databases.

E. Lower DB_BLOCK_CHECKING to MEDIUM or low on the standby databases.

정답: D,E

설명: (ITDumpsKR 회원만 볼 수 있음)

최신Oracle Database 19c: Data Guard Administration - 1z1-076무료샘플문제

자격증의 중요성:

ITDumpsKR 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공:

유용한 링크

인기 시험

우리와 연락하기