Online Access Free 1z1-497 Exam Questions

Identify two solutions that Oracle provides for patch conflict.

• A.combine patch
• B.merge patch
• C.overlay patch
• D.dual patch
• E.super patch

A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?

• A.D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements
• B.ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements
• C.ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword
• D.ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword

In this SQL statement, what is the partitioning criteria?
CREATE TABLE books_part
PARTITION BY RANGE (cell_id) ( PARTITION p0l VALUES LESS THAN (2),
PARTITION p02 VALUES LESS THAN (3) ,
. . .
PARTITION pl4 VALUES LESS THAN (15),
PARTITION pl5 VALUES LESS THAN (16),
PARTITION pl6 VALUES LESS THAN (MAXVALUE)
)
AS SELECT * FROM books;

• A.MAXVALUE
• B.pxx
• C.cell_id
• D.books
• E.There is no partitioning criteria.

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

Which is the default isolation level in Oracle Database 12c?

• A.read-only
• B.read uncommitted
• C.serializable
• D.read committed