최신 1z1-497 무료덤프 - Oracle Database 12c Essentials
All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
123 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
123 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
You want to clone PDB1 and PDB2 into the same CDB. Which statement is correct?
정답: A
As part of your Oracle Database 12c post-installation tasks, you run these commands:
Cd $ORACLE_HOME/bin
srvctl stop database -d myDb
chopt enable dm
srvctl start database -d myDb
What does this do?
Cd $ORACLE_HOME/bin
srvctl stop database -d myDb
chopt enable dm
srvctl start database -d myDb
What does this do?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
Your customer is planning for a maximum-availability architecture at their data center to address their planned downtime, unplanned downtime, and replication needs.
Consider these options:
-Instance, site recovery, and heterogeneous setup
-Inter-region and intra-region load balancing across replicated databases
-Fine-grained error investigation of incorrect results
-Integrated client and application failover
-Fastest and simplest database replication Which four options would you recommend?
Consider these options:
-Instance, site recovery, and heterogeneous setup
-Inter-region and intra-region load balancing across replicated databases
-Fine-grained error investigation of incorrect results
-Integrated client and application failover
-Fastest and simplest database replication Which four options would you recommend?
정답: A,B,D,F
설명: (DumpTOP 회원만 볼 수 있음)
정답: A,C,E
Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?
정답: B,C,D
Your customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault. Which product should your customer use?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
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?
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?
정답: C
John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases- John takes a complete CDB backup by using RMAN>Backup Database. Mike and Tim may need point-in-time recovery of their PDBs. Which statement is true?
정답: B
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?
정답: D