Exam 1z0-066 topic 1 question 21 discussion

Actual exam question from Oracle's 1z0-066

Question #: 21
Topic #: 1

Examine this query and its output:
SQL> select fs_failover_status, fs_failover_current_target,
2 fs_failover_observer_present, fs_failover_oserver_host
3 from v$database:
FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET
FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
--------------- ----------------------- ---------------- ------------------
BYSTANDER cats NO

O17.example.com -
Which are true?

A. The observer is not connected to the database on which the query was executed.
B. Cats is a bystander database.
C. The observer is connected to the database on which the query was executed.
D. The observer is currently running on o17.example.com.
E. The observer is not running, but should run on o17.example.com.

Show Suggested Answer

Suggested Answer: A 🗳️
Viewing Information About the Observer
You can find information about the observer by querying the following columns in the V$DATABASE view:
* FS_FAILOVER_OBSERVER_HOST shows the name of the computer on which the observer is running. Here it is cats.
* FS_FAILOVER_OBSERVER_PRESENT shows whether or not the observer is connected to the local database. Here the value is NO.
References:
https://docs.oracle.com/cd/B19306_01/server.102/b14230/sofo.htm

by Kamaelk at Oct. 15, 2019, 4:44 a.m.

Comments

Submit Cancel

ScottL

1 year, 7 months ago

Selected Answer: A

A and D FS_FAILOVER_STATUS BYSTANDER: Fast-start failover is enabled, but this standby database is not the target of the fast-start failover. FS_FAILOVER_CURRENT_TARGET DB_UNIQUE_NAME of the standby database that is the current fast-start failover target standby database for the Data Guard configuration FS_FAILOVER_OBSERVER_PRESENT: YES: Observer is connected to the local database. NO: Observer is not connected to the local database. FS_FAILOVER_OBSERVER_HOST: Name of the machine that hosts the observer process

upvoted 1 times

...

JESUSBB

2 years, 1 month ago

Answer: A and D

upvoted 1 times

...

oraexam12

2 years, 9 months ago

A, D the correct answer.......

upvoted 1 times

...

Sugar

3 years, 7 months ago

A D is my bet here

upvoted 1 times

...

marpayer

4 years, 1 month ago

In my opinion cats is the failover target , so I think righ answers are A and D

upvoted 1 times

...

Kamaelk

5 years, 7 months ago

In my point of view, right answer should be ABD. FS_FAILOVER_OBSERVER_PRESENT shows whether or not the observer is connected to the local database. FS_FAILOVER_OBSERVER_HOST shows the name of the computer on which the observer is running. BYSTANDER-" Fast-start failover is enabled, but this standby database is not the target of the fast-start failover. The database cannot provide fast-start failover status information."

upvoted 1 times

...