ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-066 All Questions

View all questions & answers for the 1z0-066 exam
Go to Exam

Exam 1z0-066 topic 1 question 75 discussion

Actual exam question from Oracle's 1z0-066
Question #: 75
Topic #: 1
[All 1z0-066 Questions]

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

  • A. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.
  • B. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands.
  • C. They can be used to stop SQL apply if it encounters an error.
  • D. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).
  • E. They can only be used to skip DML statements on a table.
  • F. They can be used to skip ALTER TABLE commands on a specific tables.
  • G. They can be used to skip CREATE TABLE commands.
Show Suggested Answer Hide Answer
Suggested Answer: ACFG 🗳️
A: The DDL fires DML triggers defined on the target table. Since the triggered DMLs occur in the same transaction as the DDL, and operate on the table that is the target of the DDL, these triggered DMLs will not be replicated at the logical standby.
C: The SKIP_ERROR Procedure specifies rules regarding what action to take upon encountering errors
F: You can specify rules to prevent application of DML and DDL changes to the specific table.
G: Use the SKIP procedure with caution, particularly when skipping DDL statements. If a CREATE TABLE statement is skipped, for example, you must also specify other DDL statements that refer to that table in the SKIP procedure. Otherwise, the statements will fail and cause an exception. When this happens, SQL
Apply stops running.
Incorrect Answers:
B: ALTER SYSTEM and ALTER DATABASE commands cannot be skipped.
E: You can specify rules to prevent application of DML and DDL changes to the specific table.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e41134/manage_ls.htm#SBYDB4805 https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_lsbydb.htm
by Rogazan at Aug. 6, 2021, 11:09 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Rockfics
1 year, 3 months ago
Selected Answer: AFG
B. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands. It's another database. C. They can be used to stop SQL apply if it encounters an error. It continue with an error E. They can only be used to skip DML statements on a table. It's not only for skyp DML, skip error an skip transactions.
upvoted 1 times
...
ScottL
1 year, 3 months ago
C,D,F,G SQL> execute DBMS_LOGSTDBY.SKIP(stmt => 'CONTAINER', object_name => 'DEV1'); PL/SQL procedure successfully completed. SQL> select error, statement_opt, name from dba_logstdby_skip; ERROR STATEMENT_ NAME ---------- ---------- ---------- N CONTAINER DEV1
upvoted 1 times
...
JESUSBB
1 year, 9 months ago
Answer: C, D, F and G
upvoted 1 times
...
LIHUI
2 years, 4 months ago
I THINK IS CDFG
upvoted 2 times
...
Rogazan
3 years, 6 months ago
I think D is TRUE (DBMS_LOGSTDBY.SKIP(stmt => 'CONTAINER', object_name => 'PDB1'); And I think A is FALSE. (At least I haven't found a way to skip the trigger and allow data modification). Therefore, in my opinion, the correct answer is CDFG
upvoted 4 times
...
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago