최신 1z0-076 무료덤프 - Oracle Database 19c: Data Guard Administration
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?
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?
정답: B,E,G
설명: (DumpTOP 회원만 볼 수 있음)
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?
Which THREE are prerequisites for creating a Data Guard Broker configuration to manage these databases?
정답: B,C,F
설명: (DumpTOP 회원만 볼 수 있음)
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?
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?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
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?
* 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,E
설명: (DumpTOP 회원만 볼 수 있음)
Which two are true about database roles in an Oracle Data Guard configuration?
정답: A,E
설명: (DumpTOP 회원만 볼 수 있음)
Which two statements are true regarding asynchronous redo transport in a Data Guard
정답: A,C
설명: (DumpTOP 회원만 볼 수 있음)
A customer has these requirements for their proposed Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:
정답: B
설명: (DumpTOP 회원만 볼 수 있음)