Which statement about Storage Snapshot Optimization is correct?
http://docs.oracle.com/cd/E16655_01/backup.121/e17630/release_changes.htm#BRADV276 (new features, third bullet)
Which process is responsible for writing the contents of database buffers to data files?
http://docs.oracle.com/cd/E11882_01/server.112/e25789/process.htm#CNCPT1254
(see database writer process (DBW))
Which normalization level is adopted in real-world database systems?
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?
Which normalization level is adopted in real-world database systems?
Arlen
5 days agoMargurite
1 months agoLinwood
2 months agoGerry
2 months ago