Oracle Exam 1Z0-497 Topic 3 Question 97 Discussion

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

Question #: 97
Topic #: 3

[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 Justa at Jul 10, 2024, 11:10 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Eliz

4 months ago

Ah, the old 'redact customer IDs' trick. Classic move. Next, they'll be telling us to 'move fast and break things' in the name of security.

upvoted 0 times

...

Ligia

4 months ago

Wait, did they really just use '1=1' as the expression? That's about as useful as a chocolate teapot. I bet the developer was just having a 'senior moment' when they wrote this code.

upvoted 0 times

Alease

3 months ago

I agree, it doesn't make much sense in this context.

upvoted 0 times

...

5 months ago

The regex pattern and replace string seem to be working as intended. It's extracting the last 4 digits and replacing the first 5 with XXXXX. Not a bad way to redact sensitive information.

upvoted 0 times

Quentin

4 months ago

B) They 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.

upvoted 0 times

...

Alesia

4 months ago

The regex pattern and replace string seem to be working as intended. It's extracting the last 4 digits and replacing the first 5 with XXXXX. Not a bad way to redact sensitive information.

upvoted 0 times

...

Marg

4 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

...

Micheline

5 months ago

I think the regexp_pattern and regexp_replace_string parameters find a pattern of nine digits and replace all digits with XXXXX concatenated with the last four digits.

upvoted 0 times

...