Use 1z0-931-22 Exam Dumps (2023 PDF Dumps) To Have Reliable 1z0-931-22 Test Engine
1z0-931-22 PDF Recently Updated Questions Dumps to Improve Exam Score
NEW QUESTION 68
Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?
- A. Amazon S3
- B. Oracle Cloud Infrastructure Object Storage
- C. Oracle Cloud Infrastructure Object Storage Classic
- D. Google Cloud Storage
Answer: D
Explanation:
NEW QUESTION 69
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 'None'd.
- D. Change the Automatic Maintenance Schedule to 'No Preference'.
Answer: B
Explanation:
"If the Autonomous Exadata Infrastructure resource doesn't have a customized schedule, its maintenance schedule will be automatically modified so that it precedes the Autonomous Container Database schedule you define."
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/change-maintenance-scheduleacd.html#GUID-CA028A37-5510-473E-B4D0-A5D454B8DA6E
NEW QUESTION 70
Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?
- A. A Private Endpoint is required to connect to the Shared-Autonomous Database.
- B. The OCI compute instance does not support connecting to a Shared Autonomous Database.
- C. The Autonomous Database must belong to a Network Security Group (NSG).
- D. The OCI compute instance can be used with an Always-Free Autonomous Database account.
- E. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.
Answer: D
NEW QUESTION 71
Which two are correct actions to take in order to Download the Autonomous Database Credentials?
- A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
- B. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
- C. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
- D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
- E. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
Answer: A,B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1
NEW QUESTION 72
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
- A. CPU Utilization, Storage Utilization
- B. Query Latency, User Calls, Execute Count
- C. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
- D. Transaction Count, Sessions, Running Statements
Answer: A
NEW QUESTION 73
Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)
- A. Oracle Cloud Infrastructure Object Storage Classic
- B. Amazon S3
- C. Azure Blob Storage
- D. Google Cloud Storage
- E. Oracle Cloud Infrastructure Object Storage
Answer: A,E
Explanation:
Reference:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpud/load-data-using-oracle-data-pump.html#GUID-
025C4566-1BDB-4EF2-BFB7-0CBA8C47EA5D
Data Pump Import lets you import data from Data Pump files residing on the Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic.
You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to Autonomous Database.
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/index.html#ADBBK-GUID-37922C56-0412-45CD-B10C-2088A000113F
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
NEW QUESTION 74
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.
- A. Data Insight
- B. JSON
- C. Data Load
- D. Catalog
Answer: D
Explanation:
Data Catalog
Data Catalog: it helps to get information about the entities in your Oracle Autonomous Database and to see the effect that changing an object has on other objects. Data lineage and impact analysis is key for a Data driven company.
https://blogs.oracle.com/pcoe/post/autonomous-database-tools-for-database-actions#:~:text=Data%20Catalog%3A%20it%20helps%20to,for%20a%20Data%20driven%20company.
NEW QUESTION 75
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
- B. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
- C. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
- D. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/components.html#GUID-
268B36E1-87D8-4649-A370-226E2AE3FC5C
NEW QUESTION 76
Which statement is correct about the Service console in an Autonomous Database?
- A. You can use Service console to create manual backups of Autonomous database
- B. You can use Service console to move Autonomous DB between compartments
- C. You can use Service console to manage runaway SQL statements on Autonomous DB
- D. You can use Service console to enable or disable auto scaling of Autonomous DB
Answer: C
Explanation:
NEW QUESTION 77
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?
- A. Network Security Group
- B. Subnet
- C. Security List
- D. Route Table
- E. VCN
Answer: A,B,E
Explanation:
To provision an Autonomous Database with a private endpoint, you must have the following resources already created:
A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure. Cannot be changed after provisioning.
A private subnet within your VCN configured with default DHCP options. Cannot be changed after provisioning.
At least 1 network security group (NSG) within your VCN for the Autonomous Database. Can be changed or edited after provisioning.
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbsprivateaccess.htm
NEW QUESTION 78
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
- A. OCI CLI
- B. Admin page of the Cloud Service Console
- C. OS command line from the database server.
- D. SQLDeveloper
Answer: C
NEW QUESTION 79
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.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
- D. 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.
- E. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
Answer: A,D,E
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 80
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: C
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 81
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
- A. Tablespaces
- B. Schemas
- C. Reports
- D. Data
Answer: B,D
NEW QUESTION 82
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. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-priorities.html#GUID-6E4DCD27-CDAA-432D-A90B-485C19EF72B0 It's 300x the number of OCPUs for TPURGEN
NEW QUESTION 83
When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?
- A. 1 hours
- B. 30 minutes
- C. 2 hours
- D. 24 hours
Answer: C
Explanation:
Clone Sources
You can use a running database to create a clone. For databases running on shared Exadata infrastructure, you can also use a backup as the source of your clone. When using a backup, you can select a listed backup to clone from, or create a point-in-time clone. Point-in-time clones contain all data up to a specified timestamp. The specified timestamp must be in the past.
Note When you create a clone from a backup, you must select a backup that is at least two hours old.
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbcloning.htm
NEW QUESTION 84
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 a new developer account.
- B. Create an IDCS user with the APEX role.
- C. Access the APEX Administration Services and create the workspace for the developer.
- D. Create a database user with the APEX role.
Answer: C
Explanation:
https://docs.oracle.com/en/database/oracle/application-express/19.1/htmig/creating-workspace-and-adding-Oracle-AE-users.html#GUID-1040F145-452A-49D4-BCF6-A80851AFFA74 Create a New Instance Administrator Login to the INTERNAL workspace as the ADMIN user, or another existing admin user.
Click the "Create User" link on the right-hand menu.
For a new admin user enter mandatory items and the following.
Workspace : INTERNAL
Default Schema : APEX_180200 {or whatever the highest version is}
User is an administrator: Yes
Account Availability : Unlocked
Password and Confirmation Password.
Require Change of Password on First Use : Yes
Click the "Create User" button.
https://oracle-base.com/articles/misc/apex-tips-basic-apex-management
NEW QUESTION 85
Which statement is NOT correct when setting up compartment quotas?
- A. Compartment quotas are set by Oracle.
- B. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
- C. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
- D. There are three types of quota policy statements which are set, unset and zero.
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/Content/General/Concepts/resourcequotas.htm
NEW QUESTION 86
Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?
- A. inside the backups of the container database
- B. In a separate key vault external to the Exadata Infrastructure
- C. inside the Autonomous Database wallet
- D. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted
Answer: B
NEW QUESTION 87
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
- A. Autonomous Transaction Processing
- B. Neither service ignores hints by default
- C. Both services ignore hints by default
- D. Autonomous Data Warehouse
Answer: D
Explanation:
NEW QUESTION 88
Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is stopped.
Which statement is true?
- A. The standby database is terminated.
- B. The standby database is also stopped.
- C. Failover is automatically initiated.
- D. Switchover is automatically initiated.
Answer: B
NEW QUESTION 89
Which statement is not correct when the Autonomous Database is stopped?
- A. Tools are no longer able to connect to a stopped instance
- B. CPU billing is halted
- C. User with DWROLE can still access the database
- D. In-flight transactions queries are stopped
Answer: C
Explanation:
NEW QUESTION 90
Which two statements are true about Data Insights?
- A. Data Insights is an additional priced option.
- B. You can retrieve previously executed Data Insights searches.
- C. Data Insights is available with on-premises deployments of Oracle Database.
- D. You can search for Data Insights against a base table or business model.
Answer: B,D
NEW QUESTION 91
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?
- A. MEDIUM
- B. HIGH
- C. TPURGENT
- D. TPPERFORMANT
- E. LOW
Answer: D
Explanation:
Predefined Database Service Names for Autonomous Transaction Processing The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
* tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
* tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
* high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
* medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
* low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
NEW QUESTION 92
......
1z0-931-22 Dumps Full Questions with Free PDF Questions to Pass: https://officialdumps.realvalidexam.com/1z0-931-22-real-exam-dumps.html
