Suggested Answer:CE🗳️
C: Flashback Database is similar to conventional point-in-time recovery in its effects. It enables you to return a database to its state at a time in the recent past. Flashback Database uses its own logging mechanism, creating flashback logs and storing them in the fast recovery area. You can only use Flashback Database if flashback logs are available. Flashback Database is used to convert a snapshot standby database back into a physical standby database. E: When we convert the physical standby database to snapshot standby database a guaranteed restore point is created. This guaranteed restore point is used to flashback a snapshot standby database to its original state. Incorrect Answers: A: Oracle Database supports the installation of database software upgrades, and the application of patch sets, in a rolling fashionwith near zero database downtimeby using Data Guard SQL Apply and logical standby databases. References:
Which three statements... but Correct Answer: CE... need another one it is B.
Full answer is BCE.
Test:
Before snaphot:
SQL> select database_role,open_mode from v$database;
DATABASE_ROLE OPEN_MODE
---------------- --------------------
PHYSICAL STANDBY READ ONLY WITH APPLY
SQL> select to_char(sum(p.BYTES)) from v$datafile p;
TO_CHAR(SUM(P.BYTES))
----------------------------------------
1058536062976
DGMGRL> convert database kszh to snapshot standby;
Database "kszh" converted successfully
After:
SQL> create table test1 tablespace users as select * from dba_objects;
Table created.
SQL> select to_char(sum(p.BYTES)) from v$datafile p;
TO_CHAR(SUM(P.BYTES))
----------------------------------------
1058640920576
revert back:
DGMGRL> convert database kszh to physical standby;
Database "kszh" converted successfully
SQL> select to_char(sum(p.BYTES)) from v$datafile p;
TO_CHAR(SUM(P.BYTES))
----------------------------------------
1058536062976
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ScottL
1 year, 3 months agoJESUSBB
1 year, 9 months agoSugar
3 years, 3 months agoKamaelk
5 years, 3 months ago