Visit Official SkillCertPro Website :-
For a full set of 500+ questions. Go to
SkillCertPro offers detailed explanations to each question which helps to understand the concepts better.
It is recommended to score above 85% in SkillCertPro exams before attempting a real exam.
SkillCertPro updates exam questions every 2 weeks.
You will get life time access and life time free updates
SkillCertPro assures 100% pass guarantee in first attempt.
Question 1:
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?
A. Allow group ADB-Admins to manage autonomous-database in tenancy
B. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW‘
C. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘OLTP‘
D. Allow group ADB-Admins to manage autonomous-database-family in tenancy
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Identity/Concepts/commonpolicies.htm#ariaid-title30
Question 2:
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s). How can they achieve this?
A. Change the Automatic Maintenance Schedule to ‘None‘
B. Change the Automatic Maintenance Schedule to ‘Specify a Schedule‘ but do not select any month, week or day
C. Change the Automatic Maintenance Schedule to ‘No Preference‘
D. You cannot permanently disable schedule Automatic Maintenance
Answer: C
Explanation:
Question 3:
When enabling auto-scaling, which three options do not change?
A. I/O resources
B. Number of OCPUs displayed in the console
C. Amount of storage
D. Parallelism settings
E. Level of concurrency
Answer: C, D, E
Explanation:
Question 4:
Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?
A. The Autonomous Database must belong to a Network Security Group (NSG)
B. A Private Endpoint is required to connect to the Shared Autonomous Database
C. The Autonomous Database must be in the same VCN and Subnet as the Compute instance
D. The OCI compute instance can be used with an Always-Free Autonomous Database Account
E. The OCI compute instance does not support connecting to a Shared Autonomous Database
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/FreeTier/freetier.htm#ariaid-title3
Question 5:
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statements is true about the workloads?
A. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart and data lake
B. Autonomous Data Warehouse workloads are optimized for mixed workloads
C. Autonomous Transaction Processing memory usage optimized workloads for parallel joins and aggregations
D. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar
Answer: D
Explanation:
ADW designed for parallel joins and aggregations, ATP designed for Mixed workloads, ADW optimized for data-warehouse, data lake and data mart, Data format for ATP row-wise and for ADW columnar.
For a full set of 500+ questions. Go to
SkillCertPro offers detailed explanations to each question which helps to understand the concepts better.
It is recommended to score above 85% in SkillCertPro exams before attempting a real exam.
SkillCertPro updates exam questions every 2 weeks.
You will get life time access and life time free updates
SkillCertPro assures 100% pass guarantee in first attempt.
Question 6:
When using data pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
A. Tablespaces
B. Schemas
C. Data
D. Reports
Answer: B, C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/load-data-data-pump.html#GUID-30DB1EEA-DB45-49EA-9E97-DF49A9968E24
Question 7:
You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX. What statement describes the step to provide the developer a new workspace in APEX?
A. Create an IDCS user with the APEX role
B. Create a database user with the APEX role
C. Access the APEX Administration Services and create the workspace for the developer
D. Create a new developer account
Answer: C
Explanation:
https://blogs.oracle.com/apex/forms-to-apex-creating-a-workspace
Question 8:
Which statement is true in regards to database links?
A. Connect to Autonomous Database from remote database using a database link
B. You can call PL/SQL procedures and functions using a database link
C. Create a database link from one Autonomous Database to another Autonomous Database instance
D. Connect from Autonomous Database to remote database using a database link
Answer: A
Explanation:
Question 9:
Which is NOT needed for signing, in order to use REST APIs with the Oracle Autonomous Database?
A. Fingerprint of the public key
B. SSH-RSA (1024 bits)
C. Tenancy‘s OCID
D. User‘s OCID
Answer: B
Explanation:
https://i.ibb.co/YBhh4tW/screen-shot-2018-09-06-at-9-44-44-pm.jpg
Question 10:
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated Infrastructure?
A. The Compartment of the Dedicated Infrastructure as each compartment only runs 1 Dedicated environment
B. The name or OCID of Exadata Infrastructure which was assigned by the Fleet Administrator
C. The Client Credentials wallet which is used to connect to the Autonomous Database
D. The ‘High Availability Container Database‘ in which the Autonomous instance should run
E. The Listener endpoint where the Autonomous Database should register on
Answer: D
Explanation:
For a full set of 500+ questions. Go to
SkillCertPro offers detailed explanations to each question which helps to understand the concepts better.
It is recommended to score above 85% in SkillCertPro exams before attempting a real exam.
SkillCertPro updates exam questions every 2 weeks.
You will get life time access and life time free updates
SkillCertPro assures 100% pass guarantee in first attempt.