New (2023) Download free 1z0-931-23 PDF for Oracle Practice Tests
100% Free 1z0-931-23 Files For passing the exam Quickly
NEW QUESTION # 68
Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?
- A. Month of the Quarter, Week of the Month, Day of the Week, Start Hour
- B. Month of the Year, Week of the Month, Day of the Week, Start Hour
- C. Week of the Quarter, Day of the Week, Start Hour
- D. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour
Answer: A
NEW QUESTION # 69
Which two objects are imported when using Data Pump to migrate your Oracle database to Autonomous Database?
- A. Reports
- B. Tablespaces
- C. Schemas
- D. Data
Answer: C,D
NEW QUESTION # 70
You enabled Autonomous Data Guard on Autonomous Database on Shared Infrastructure.
Which three statements are true about the standby database after a failover?
- A. Autonomous Data Guard automatically creates a new standby database
- B. A new wallet is required to connect to the standby database
- C. Oracle Machine Learning Notebooks created in the primary database are available in the standby database
- D. Autonomous Data Guard automatically reverts to the primary database when it becomes available again
- E. The OCPU Count, Storage, Display Name, Database Name, Auto Scaling, Tags, and Licensing options have the same values as the primary
Answer: A,C,E
NEW QUESTION # 71
Which statement is correct about the Service console in an 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
NEW QUESTION # 72
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: A
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 # 73
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 # 74
Which command should you issue to enable application continuity on 0 Shared Infrastructure?
- A. alter database set application_continuity=true
- B. alter system set application_continuity=true
- C. exec dbms_cloud admin.enable_app_cont('<cservice_name>');
- D. alter session set application_continuity-true
Answer: C
NEW QUESTION # 75
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
- A. Current settings for ACLs are cloned.
- B. All resource management rules are cloned.
- C. All underlying data for OML notebooks is cloned.
- D. Clone can be in a different region.
- E. All OML notebooks are cloned.
Answer: C,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-clone-notes.html#GUID-F943E7FF-8DEB-47F4-84C0-FFA5BAF9D5A9
NEW QUESTION # 76
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. SQLDEV_ADMIN.GRANT_SCHEMA
- B. ORDS_ADMIN.GRANT_SCHEMA
- C. ORDS_PRIV.ENABLE_SCHEMA
- D. ORDS_ADMIN.ENABLE_SCHEMA
Answer: D
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 # 77
A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.
What should they do to remove this bottleneck?
- A. Ask Support to migrate their setup to a node without noisy neighbors.
- B. Increase the number of OCPUs allocated to the database.
- C. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.
- D. Remove any non-JSON data from the database.
Answer: B
NEW QUESTION # 78
A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst.
When restoring/cloning the ADB, you must select a backup which is atleast___ hours/minutes old.
- A. 2 hrs
- B. 5 min
- C. 24 hrs
- D. 1 day
Answer: C
NEW QUESTION # 79
What REST verb is used to create an Autonomous Database service using REST APIs?
- A. A "POST" REST call
- B. A "GET" REST call
- C. An "INSERT" REST call
- D. A "PUT" REST call
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/SendRequests.html To create an Autonomous Database service using REST APIs, you need to use a POST method with the appropriate request body. See Create Autonomous Database for more details.
NEW QUESTION # 80
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?
- A. Resource Manager settings
- B. Oracle Machine Learning notebook
- C. SQL Developer Web Console
- D. Compartment quotas
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm
NEW QUESTION # 81
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
- A. Using Database Configuration Assistant (DBCA) on the database server.
- B. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
- C. Connecting to the Cloud Infrastructure Command console via SSH wallet.
- D. It cannot be done.
Answer: B
Explanation:
The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands.
https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using-oci-curl Examples of using Autonomous Database managing by REST API
https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/LabGuide900ConfigureOCI-CLI.md
NEW QUESTION # 82
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 also stopped.
- B. Switchover is automatically initiated.
- C. The standby database is terminated.
- D. Failover is automatically initiated.
Answer: A
NEW QUESTION # 83
What are the two supported infrastructure options for deploying an Autonomous Database?
- A. Any Oracle Engineered System
- B. VM on Oracle Cloud Infrastructure
- C. Shared Exadata Infrastructure
- D. Bare-metal on Oracle Cloud Infrastructure
- E. Dedicated Exadata Infrastructure
Answer: C,E
NEW QUESTION # 84
Which two tasks can be executed from the service console for Autonomous Databases?
- A. monitoring Autonomous Databases for usage and query performance
- B. using a wizard to download connection wallet for connection from desktop tools
- C. creating and scaling an Autonomous Database service
- D. starting and stopping an instance
- E. configuring virtual cloud networks (VCNS)
Answer: A,B
NEW QUESTION # 85
Which option is not available to access data in an Autonomous JSON Database?
- A. REST API calls to the database
- B. Oracle Cloud Infrastructure console using the JSON Developer tool
- C. Regular Oracle SQL statements using a connection string to the database
Answer: C
Explanation:
O NoSQL statements using Simple Oracle Document Access (SODA) drivers
NEW QUESTION # 86
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?
- A. Route Table
- B. Subnet
- C. VCN
- D. Security List
- E. Network Security Group
Answer: B,C,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 # 87
Which three scaling options are available in Oracle Autonomous Database on Shared Infrastructure?
- A. Automatic online scaling of OCPU
- B. Manual offline scaling of Storage and OCPU
- C. Automatic online scaling of Storage
- D. Manual online scaling of Storage
- E. Manual online scaling of OCPU
Answer: A,B,C
NEW QUESTION # 88
Which statement is true about OCPUs and storage when you choose to scale your Autonomous Database?
- A. OCPUs and storage must remain in sync
- B. Increasing OCPUs will automatically increase storage
- C. OCPUs and storage can be scaled independently
- D. Use auto scaling to increase storage
Answer: C
NEW QUESTION # 89
Which two statements are true about Data Insights?
- A. You can search for Data Insights against a base table or business model.
- B. Data Insights is available with on-premises deployments of Oracle Database.
- C. Data Insights is an additional priced option.
- D. You can retrieve previously executed Data Insights searches.
Answer: A,D
NEW QUESTION # 90
As a database architect, you are tasked with configuring a high concurrency, production OLTP (online transaction processing) 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?
- A. TP
- B. MEDIUM
- C. HIGH
- D. TPURGENT
Answer: D
NEW QUESTION # 91
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. alter database set application_continuity=true
- B. alter system set application_continuity=true
- C. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
- D. alter session set application_continuity=true
Answer: C
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 # 92
Which three are Oracle-recommended best practices for Autonomous Database alarms?
- A. Select the correct alarm interval for your metric.
- B. Suppress alarms during investigations.
- C. Use a single interval for all alarms.
- D. Create a single alarm for each metric.
- E. Routinely tune your alarms.
- F. Create multiple alarm metrics.
Answer: A,B,E
NEW QUESTION # 93
......
1z0-931-23 Premium Exam Engine - Download Free PDF Questions: https://testking.realvce.com/1z0-931-23-VCE-file.html