[Dec 10, 2023] 100% Pass Guarantee for 1z0-931-23 Dumps with Actual Exam Questions
Today Updated 1z0-931-23 Exam Dumps Actual Questions
NEW QUESTION # 92
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?
- A. You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.
- B. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
- C. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
- D. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.
Answer: B
NEW QUESTION # 93
Which two tasks can be executed from the service console for Autonomous Databases?
- A. monitoring Autonomous Databases for usage and query performance
- B. configuring virtual cloud networks (VCNS)
- C. using a wizard to download connection wallet for connection from desktop tools
- D. creating and scaling an Autonomous Database service
- E. starting and stopping an instance
Answer: A,C
NEW QUESTION # 94
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
- A. Schemas
- B. Data
- C. Reports
- D. Tablespaces
Answer: A,B
Explanation:
When using Data Pump to migrate your Oracle database to Autonomous Database, you can import data and schemas from Data Pump files. You cannot import tablespaces or reports. See Export Your Existing Oracle Database to Import into Autonomous Database for more details.
NEW QUESTION # 95
For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?
- A. ORDS_ADMIN.GRANT_SCHEMA
- B. ORDS_PRIV.ENABLE_SCHEMA
- C. ORDS_ADMIN.ENABLE_SCHEMA
- D. SQLDEV_ADMIN.GRANT_SCHEMA
Answer: C
Explanation:
As an alternative, the ADMIN can provide Web Access for a user, REST enable a user, with SQL commands. As the ADMIN user run the following code:
BEGIN
ORDS_ADMIN.ENABLE_SCHEMA(
.
.
);
COMMIT;
END;
/
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/sql-developer-web.html#GUID-4B404CE3-C832-4089-B37A-ADE1036C7EEA
NEW QUESTION # 96
Which three tasks are performed from the service console of an Autonomous Database on Shared Infrastructure?
- A. Set resource management rules
- B. Download the wallet
- C. Manage Oracle Machine Learning users
- D. Rotate the wallet
- E. Enable autoscaling
Answer: B,D,E
NEW QUESTION # 97
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- A. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
- B. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
- C. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
- D. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
- E. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
Answer: A,C,D
Explanation:
DELETE_FILE Procedure
This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.
CREATE_CREDENTIAL Procedure
This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. Use stored credentials for data loading or for querying external data residing in the Cloud.
PUTJDBJECT Procedure
This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).
VALIDATE EXTERNAL TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.
To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.
This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're moving the log import.log to object store with a DBMS_CLOUD.PUT_OBJECT command.
VALIDATE_EXTERNAL_TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Database. The overloaded form enables you to use the operation_id parameter.
PUT_OBJECT Procedure
This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB) DELETE FILE Procedure This procedure removes the specified file from the specified directory on Autonomous Database.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Database.
NEW QUESTION # 98
What are the two supported infrastructure options for deploying an Autonomous Database?
- A. Dedicated Exadata Infrastructure
- B. Any Oracle Engineered System
- C. Shared Exadata Infrastructure
- D. Bare-metal on Oracle Cloud Infrastructure
- E. VM on Oracle Cloud Infrastructure
Answer: A,C
NEW QUESTION # 99
Which two methods can you use to define Oracle Machine Learning users?
- A. Service Console
- B. SQL Developer
- C. the DBMS_CLOUD_ADMIN package
- D. Oracle Cloud Infrastructure Console
Answer: D
NEW QUESTION # 100
Which statement is FALSE about setting up compartment quotas?
- A. Quotas set on a parent compartment override quotas set on child compartments.
- B. You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.
- C. Compartment quotas cannot be set on the root compartment.
- D. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
Answer: C
NEW QUESTION # 101
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. alter database set application_continuity=true
- B. alter session set application_continuity=true
- C. alter system set application_continuity=true
- D. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-42B9DDB0-12A7-4EE3-9860-30EFA41061E9 If it was asking for Autonomous Database Dedicated Infrastructure, then answer would be execute DBMS_APP_CONT_ADMIN.ENABLE_AC( 'databaseid_tpurgent.adb.oraclecloud.com', 'LEVEL1', 600);
NEW QUESTION # 102
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
- A. All resource management rules are cloned.
- B. All underlying data for OML notebooks is cloned.
- C. Clone can be in a different region.
- D. Current settings for ACLs are cloned.
- E. All OML notebooks are cloned.
Answer: B,C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-clone-notes.html#GUID-F943E7FF-8DEB-47F4-84C0-FFA5BAF9D5A9
NEW QUESTION # 103
Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database.
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Backup Retention
If you choose to enable automatic backups, you can choose one of the following preset retention periods: 7 days, 15 days, 30 days, 45 days, or 60 days. The system automatically deletes your incremental backups at the end of your chosen retention period.
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/backingupOS.htm
NEW QUESTION # 104
Which three are Oracle-recommended best practices for Autonomous Database alarms?
- A. Use a single interval for all alarms
- B. Suppress alarms during investigations
- C. Select the correct alarm interval for your metric
- D. Tune your alarms routinely
- E. Create a single alarm for each metric
- F. Create multiple alarm metrics
Answer: B,C,E
NEW QUESTION # 105
Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?
- A. Maximum Performance
- B. Maximum Availability
- C. Maximum Continuity
- D. Maximum Protection
Answer: A,B
NEW QUESTION # 106
Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?
- A. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
- B. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
- C. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.
- D. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.
Answer: D
Explanation:
Exadata infrastructure maintenance takes place at least once each quarter and is mandatory.
If a scheduled container database maintenance run cannot take place (because of changes made to infrastructure maintenance scheduling or other reasons) , Oracle will automatically reschedule the container database maintenance for the following quarter.
You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.
Exadata infrastructure maintenance patches the Exadata infrastructure (including patching of the Exadata grid infrastructure code and operating systems updates), and DO NOT include database patching.
NEW QUESTION # 107
Which statement is correct about managing and monitoring of Autonomous Database?
- A. You can use Service console to manage runaway SQL statements on Autonomous DB.
- B. You can use Service console to move Autonomous DB between compartments.
- C. You can use Service console to enable or disable auto scaling of Autonomous DB.
- D. You can use Service console to create manual backups of Autonomous database.
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-sql-statements.html#GUID-4861BA7F-F9FA-4909-8DC0-4F46AFF80706
NEW QUESTION # 108
Which statement is true when the Autonomous Database has auto scaling enabled?
- A. Scales the PGA and SGA size when needed for the workload.
- B. Database concurrency is scaled up when needed by the workload.
- C. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.
- D. Increases the number of sessions available to the database.
Answer: C
NEW QUESTION # 109
Which of the following two statements regarding Data Transforms are correct?
- A. Workflows for data transforms is only available on the ODI Web Edition
- B. Data Transforms allows you to design data transformations in the form of data loads, data flows, and workflows
- C. Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition
- D. All capabilities to transform data in ODI Classic are available with ODI Web Edition
Answer: B,C
NEW QUESTION # 110
Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?
- A. Oracle Cloud Infrastructure Object Storage
- B. Oracle Cloud Infrastructure Object Storage Classic
- C. Azure Blob Storage
- D. Amazon S3
- E. Google Cloud Storage
Answer: A,B
NEW QUESTION # 111
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
- A. Under Database then Autonomous Transaction Processing then Autonomous Exadata
- B. Under Solutions and Platform then Platform Services then Autonomous Exadata
- C. Under Core Infrastructure then Compute then Autonomous Exadata
- D. Under Core Infrastructure then Autonomous Exadata
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory.
Even though the UI has changed recently, this documentation has the user go to Menu -> Database
NEW QUESTION # 112
Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?
- A. Enterprise Manager Cloud Control
- B. Performance Hub
- C. RMAN
- D. OCI Metrics
- E. Logs
Answer: A,B,D
NEW QUESTION # 113
Which statement is FALSE about Oracle Text?
- A. It provides indexing, word and theme searches
- B. It requires an Oracle Text license for Autonomous Database
- C. t uses standard SQL queries
- D. It is suited to search document collections
Answer: B
NEW QUESTION # 114
You are the admin user of an Autonomous Database instance. A new business analyst has joined the team and could like to explore the Autonomous Database tables using Autonomous Database's Data Tools.
Which step should you to perform to enable the new team member?
- A. Create a database user with the default privileges
- B. Create a database user with connect, resource, and object privileges
- C. Create an IDCS user Create a database user with connect, resource, and object privileges
- D. Create a REST-enabled database user (with connect and object privileges) and grant the U DWROLE role
Answer: A
NEW QUESTION # 115
......
1z0-931-23 exam dumps with real Oracle questions and answers: https://www.dumpsmaterials.com/1z0-931-23-real-torrent.html
1z0-931-23 Exam in First Attempt Guaranteed: https://drive.google.com/open?id=1GBD-S2LQ31OMbDBRo8-8Yy0hpNJPFl95
