1z0-497 試験問題を無料オンラインアクセス

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?

• 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.
• 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.
• C.They find a pattern of nine digits and display the digits as XXXXX XX XXXX.
• D.They find a pattern of nine digits and display the first five digits as XXXXX and the last four digits as 3333.

What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?

• A.SYSBACKUP
• B.SYSBKPRMAN
• C.SYSRMAN
• D.SYSBKP

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

• A.Media recovery is possible in most cases.
• B.You can perform complete recovery by using the command:
  RESTORE DATABASE
  FROM TAG"consistent_whole_backup";
  RECOVER DATABASE;
• C.Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.
• D.You can perform incomplete recovery by using the command:
  RESTORE DATABASE;
  FROM TAG "consistent_whole_backup";
  RECOVER DATABASE NOREDO;

Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.

• A.increased storage cost
• B.less instance overhead
• C.fast and easy provisioning
• D.same time needed for patching and upgrade as in the previous release
• E.minor application changes
• F.isolation

Your customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the customer if the distance between the primary and the standby location is more than 300 miles?

• A.Data Guard SQL Apply
• B.Synchronous redo transport with Data Guard
• C.Asynchronous redo transport with Data Guard
• D.Active Data Guard Far Sync