Oracle Cloud Platform Data Management 2019 Associate Sample Questions:
1. You have already created Exadata DB System with Oracle Grid Infrastructure 12c Release 1. You want to upgrade Orade Grid Infrastructure to Oracle 12c Release 2 of the Exadata Cloud Service.
Which two statements are true about ensuring a successful upgrade?
A) You must manually upgrade to Oracle Grid Infrastructure 12c R2
B) Your must manually upgrade to Oracle Grid lnfrastructure 12c R2 and use self-service web interface acces to create version 12.2 Database Deployment.
C) You cannot later use the self-service web interfaces to upgrade a version 12. 2 Database Deployment.
D) You can use the self-service web interfaces to upgrade a version 12.2 Database Deployment.
2. You are going to perform a 5-GB database migration from on-premises to OCI DB system. It includes some tables with LONG columns.
What is the best Data Pump method for this case?
A) There is no need to generate a dump file. You can use the NETWORK LINK method over an SSH tunnel, because that way you avoid transferring dump files and the data is secured too.
B) Data Pump is not recommended in this case as the amount of data is too big.
C) There is no need to generate a dump file. You can use the NETWORK LINK method over the Internet, because that way you avoid transferring dump files.
D) Generate a dump file, transfer it using SCP, and import it in the destination OCI DB system .
3. You want to set up an on-premises network connectivity to OCI. Which component Is NOT part of this configuration?
A) FastConnect Service
B) Service Gateway
C) Routing Tables
D) Dynamic Routing Gateway
E) IPSec VPN Tunnel
F) Customer-premises equipment
G) VCN and Subnets
4. You want to modify the default eight-day retention period for Autonomous Database performance datA. Which DBMS_WORKLOAD_REPOSITORY subprogram procedure should you use?
A) OPDATE_OBJECT_SETTINGS
B) CREATE_BASELINE_TEMPLATE
C) MODIFY_SNAPSHOT_SETTINGS
D) UPDATE_OBJECT_INFO
5. Which two fall under the scope of customer for management and maintenance of Exadata Cloud at Customer?
A) control and manage the Hypervisor
B) control and manage the Operating System
C) control and manage the Database software
D) control and manage the hardware
Solutions:
Question # 1 Answer: B | Question # 2 Answer: A | Question # 3 Answer: B | Question # 4 Answer: C | Question # 5 Answer: A,D |