C re connect the sessions that access objects with

This preview shows page 18 - 21 out of 152 pages.

C. Re-connect the sessions that access objects with redaction policies defined on them. D. Flush the shared pool. E. Restart the database instance. Correct Answer: E
Image of page 18
Section: (none) Explanation Explanation/Reference: Explanation: About Altering the Default Full Data Redaction Value You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect. Note: * The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application. * UPDATE_FULL_REDACTION_VALUES Procedure This procedure modifies the default displayed values for a Data Redaction policy for full redaction. * After you create the Data Redaction policy, it is automatically enabled and ready to redact data. * Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low- privileged users or applications. You can redact column data by using one of the following methods: / Full redaction. / Partial redaction. / Regular expressions. / Random redaction. / No redaction. References: QUESTION 38 You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions? (Choose two.) A. Enable supplemental logging for the database. B. Specify undo retention guarantee for the database. C. Create a Flashback Data Archive in the tablespace where the tables are stored. D. Create a Flashback Data Archive in any suitable tablespace. E. Enable Flashback Data Archiving for the tables that require tracking. Correct Answer: DE Section: (none) Explanation Explanation/Reference: Explanation: E: By default, flashback archiving is disabled for any table. You can enable flashback archiving for a table if you have the FLASHBACK ARCHIVE object privilege on the Flashback Data Archive that you want to use for that table. D: Creating a Flashback Data Archive / Create a Flashback Data Archive with the CREATE FLASHBACK ARCHIVE statement, specifying the following: Name of the Flashback Data Archive
Image of page 19
Name of the first tablespace of the Flashback Data Archive (Optional) Maximum amount of space that the Flashback Data Archive can use in the first tablespace / Create a Flashback Data Archive named fla2 that uses tablespace tbs2, whose data will be retained for two years: CREATE FLASHBACK ARCHIVE fla2 TABLESPACE tbs2 RETENTION 2 YEAR; QUESTION 39 You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing
Image of page 20
Image of page 21

You've reached the end of your free preview.

Want to read all 152 pages?

  • Fall '19
  • Oracle Database

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors