Which command do you use to create a local role while you are connected as the local user?
Options:
A.
create local role l_hr;
B.
create role c##_hr container=current;
C.
create role l_hr container=current;
D.
create role l_hr container=all;
Answer:
C
Explanation:
Explanation:
You can include CONTAINER=CURRENT in the CREATE ROLE statement to specify the role as a local role.
Reference: [Reference: Oracle Database Security Guide , Creating a Local Role, ]
Question 3
Identify two types of solutions in which you would need to use Active Data Guard and Golden Gate together.
Options:
A.
a solution that provides zero-data-loss protection at any distance without impacting database performance
B.
a solution for disaster protection and database rolling upgrades for a mission-critical OLTP database, where you also want to extract data from a data guard primary database for ETL update o' an enterprise data warehouse
C.
a solution requiring minimal planned downtime and risk, using standby first patching, database rolling upgrades, and select platform migrations
D.
a solution that helps with integrated automatic database and client failover between source and target, where you also need to establish advanced replication (such as multi master and bidirectional replication and data transformations)
Answer:
B, C
Explanation:
Reference: [Reference: http://www.oracle.com/technetwork/database/availability/active-data-guard-wp-12c-1896127.pdf (page 16, last two bulleted points), https://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60084 , ]