Oracle 1z0-931-22 Exam Info and Free Practice Test TrainingQuiz [Q28-Q51]

QUESTION 28
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?

QUESTION 29
When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?

QUESTION 30
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that’s low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

QUESTION 31
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?

QUESTION 32
According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.
Which statement is true?

QUESTION 33
Which Database Actions tool is used to get information about the entries on your Oracle Autonomous Database and to see the effect that changing an object has on other objects.

QUESTION 34
Which statement is true when the Autonomous Database has auto scaling enabled?

QUESTION 35
Which stage of the indexing pipeline divides text into tokens?

QUESTION 36
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)

QUESTION 37
In which four ways can Oracle Database optimally access data in Object Storage?

QUESTION 38
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?

QUESTION 39
Which statement is FALSE about Oracle Autonomous JSON Database?

QUESTION 40
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

QUESTION 41
You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs.
What is the total number of concurrent statements that the TPURGENT service can support?

QUESTION 42
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

QUESTION 43
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?

QUESTION 44
Which three are Oracle-recommended best practices for Autonomous Database alarms?

QUESTION 45
Which is NOT needed to manage Oracle Autonomous Database with REST APIS?

QUESTION 46
Which four file formats are supported when loading data from Cloud Storage?

QUESTION 47
While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

QUESTION 48
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?

QUESTION 49
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?

QUESTION 50
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)?

QUESTION 51
Which two statements are true about Data Insights?