Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.
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 statement about Online Move Data file is true?
Which two statements about switchover and failover are true?
Which statement about CDB architecture is true?
You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?
Examine the output:
SQL> SELECT index_name, status FROM dba_indexes WHEREstatus='UNUSABLE’;
INDEX_NAME STATUS
--------------------- -----------------
EIND UNUSABLE
Which two statements about this index are true?
Examine the command:
SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt NUMBER (10, 2)) TABLESPACE users ;
Which two statements are true about the execution of the command?
For which use case would you use a rolling upgrade with the Oracle Active Data Guard feature?
PDF + Testing Engine
|
---|
$66 |
Testing Engine
|
---|
$50 |
PDF (Q&A)
|
---|
$42 |
Oracle Free Exams |
---|
![]() |