Online Access Free 1Z0-931-21 Practice Test

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?

• A.Create a database user with connect, resource, and object privileges.
• B.Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
• C.Create a database user with the default privileges.
• D.Create an IDCS user. Create a database user with connect, resource, and object privileges.

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?

• A.2700
• B.1800
• C.900
• D.1500

Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

• A.Backup Retention
• B.Data Organization
• C.Undo Management
• D.Memory Usage
• E.Index Storage

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 'Specify a Schedule' but do not select any month, week or day.
• B.You cannot permanently disable scheduled Automatic Maintenance.
• C.Change the Automatic Maintenance Schedule to 'No Preference'.
• D.Change the Automatic Maintenance Schedule to 'None'd.

Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

• A.Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
• B.You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
• C.You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
• D.It is enabled by default.
• E.The indexing feature is implemented as an automatic task that runs at a fixed interval.