Oracle Exam 1Z0-497 Topic 8 Question 89 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 89
Topic #: 8

[All 1Z0-497 Questions]

Examine the command below:

BEGIN DBMS_REDACT.ADD_POLICY(

object_schema => 'mavis',

object_name => 'cust_info',

column_name => 'emp_id',

policy_name => 'redact_cust_ids',

function_type => DBMS_REDACT.REGEXP,

expression => '1=1',

regexp_pattern => '(\d\d\d)(\d\d)(\d\d\d\d)',

regexp_replace_string => 'XXXXX\3',

regexp_position => 1,

regexp_occurrence => 0,

regexp_match_parameter => 'i',

policy_description => 'Redacts customer IDs',

column_description => 'emp_id contains employee ID numbers');

END;

What do the regexp_pattern and regexp_replace_string parameters accomplish?

AThey find a pattern of nine digits; break the digits into three groups that contain the first three, the next two and then the last four digits; and replace all digits with XXXXX concatenated with the last four digits.

BThey find a pattern of six digits; break the digits into two groups that contain the first five, and then the last digit; and replace all digits with XXXXX concatenated with the last digit.

CThey find a pattern of nine digits and display the digits as XXXXX XX XXXX.

DThey find a pattern of nine digits and display the first five digits as XXXXX and the last four digits as 3333.

Show Suggested Answer

Suggested Answer: A

http://docs.oracle.com/database/121/ASOAG/redaction_features.htm#ASOAG925

by Detra at Apr 08, 2024, 12:47 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Oneida

6 months ago

I see your point, But I think the main purpose is to redact sensitive information by replacing digits with XXXXX.

upvoted 0 times

...

Kattie

6 months ago

I'm not sure about this. Could it be option C instead? Displaying the digits as XXXXX XX XXXX seems plausible to me.

upvoted 0 times

...

Oneida

7 months ago

I agree with you, Option A makes sense because it breaks the digits into three groups and replaces them accordingly.

upvoted 0 times

...

Oneida

7 months ago

I think the regexp_pattern and regexp_replace_string parameters in the command are used to find a pattern of nine digits and replace them with XXXXX concatenated with the last four digits.

upvoted 0 times

...

Ilda

7 months ago

That does sound interesting, but I think A) makes more sense in this context.

upvoted 0 times

...

Laurel

7 months ago

I'm not sure about the answer, but C) sounds interesting. Displaying the digits as XXXXX XX XXXX could be useful.

upvoted 0 times

...

Odette

7 months ago

I believe option A) is correct. It breaks the digits into three groups and replaces them with XXXXX.

upvoted 0 times

...

Ilda

7 months ago

I think regexp_pattern and regexp_replace_string parameters are used to define and replace part of the data.

upvoted 0 times

...

Edelmira

8 months ago

Nah, I don't think Option B is right. The question clearly states that the pattern is nine digits, and the regex pattern and replace string match that description.

upvoted 0 times

...

Kip

8 months ago

Hmm, I don't know. I think Option B could also be a valid answer. The question doesn't specify that the pattern is nine digits, it just says 'a pattern of digits'.

upvoted 0 times

...

Glory

8 months ago

Good point. The question doesn't really explain those parameters, but based on the information provided, it seems like they're not doing anything significant in this particular case.

upvoted 0 times

...

Laquanda

8 months ago

I don't know, guys. I'm a little confused about the 'regexp_position' and 'regexp_occurrence' parameters. What do they do in this context?

upvoted 0 times

...

Gwenn

8 months ago

Yeah, I agree. Option A seems to be the correct answer here. The regex pattern and replace string are doing exactly what the question is asking about.

upvoted 0 times

...

Carry

8 months ago

Hey, this question seems pretty straightforward. The regex pattern is looking for a nine-digit number and breaking it into three groups - the first three digits, the next two digits, and the last four digits. Then, it's replacing all the digits with 'XXXXX' and concatenating the last four digits.

upvoted 0 times

Willetta

7 months ago

That's correct. The regular expression pattern is specifically looking for that format and then replacing the digits accordingly.

upvoted 0 times

...

Stephane

7 months ago

A) They find a pattern of nine digits; break the digits into three groups that contain the first three, the next two and then the last four digits; and replace all digits with XXXXX concatenated with the last four digits.

upvoted 0 times

...