Oracle Cloud Infrastructure (OCI) 1Z0-931-21 Sample Questions:
1. As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?
Ans: TPURGENT
2. Which can be Scaled independently of the number of CPUs in an Autonomous Database?
Ans: Storage
3. What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?
Ans: ADMIN
4. Given the steps:
1. Create Oracle Machine Learning User
2. Create projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning?
Ans: Run SQL Scripts
Create workspaces
5. How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?
Ans: Five. They are called tpurgent, tp, high, medium and low.
6. Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?
Ans: Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
7. While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
Ans: Data that Is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format Is columnar.
8. When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?
Ans: CWALLET.SSO
9. Which statement is true in regards to database links?
Ans: Connect to Autonomous Database from remote database using a database link.
10. What are three methods to load data into the Autonomous Database?
Ans: Oracle Data Pump
Oracle GoldenGate
SQL*Loader