[Dec-2023] Pass 1z0-931-23 Exam in First Attempt Updated 1z0-931-23 Exam Questions
Oracle Cloud Dumps 1z0-931-23 Exam for Full Questions - Exam Study Guide
NEW QUESTION # 74
Which command should you issue to enable application continuity on 0 Shared Infrastructure?
- A. exec dbms_cloud admin.enable_app_cont('<cservice_name>');
- B. alter session set application_continuity-true
- C. alter system set application_continuity=true
- D. alter database set application_continuity=true
Answer: A
NEW QUESTION # 75
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 # 76
Which stage of the indexing pipeline divides text into tokens?
- A. SECTIONER
- B. FILTER
- C. Otokenizer
- D. LEXER
Answer: D
NEW QUESTION # 77
An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.
Other than changing the shared user password, what can the admin do to protect the instance?
- A. Trust the user who left to not access the database.
- B. Shutdown and restart the instance.
- C. Delete the user.
- D. Rotate the instance wallet and share the new wallet with the remaining users.
Answer: D
NEW QUESTION # 78
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?
- A. Resource Manager settings
- B. SQL Developer Web Console
- C. Compartment quotas
- D. Oracle Machine Learning notebook
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm
NEW QUESTION # 79
Which option is not available to access data in an Autonomous JSON Database?
- A. Regular Oracle SQL statements using a connection string to the database
- B. Oracle Cloud Infrastructure console using the JSON Developer tool
- C. REST API calls to the database
Answer: A
Explanation:
O NoSQL statements using Simple Oracle Document Access (SODA) drivers
NEW QUESTION # 80
Which three functions are provided by Spatial Studio?
- A. Spatial analysis
- B. Custom SQL queries
- C. Geocoding
- D. Map visualization
- E. Spatial data editing
Answer: A,C,D
NEW QUESTION # 81
You have been tasked with analyzing a year's worth of sales data stored in an Autonomous Data Warehouse instance.
Which tool would you use to automate data exploration and create pivot tables?
- A. APEX
- B. SQL Developer Web
- C. Business Models
- D. Data Load
Answer: C
NEW QUESTION # 82
When enabling auto-scaling, which three options do not change?
- A. I/O resources
- B. Amount of storage
- C. parallelism settings
- D. Number of OCPUs displayed in the console.
- E. Level of concurrency
Answer: B,C,E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-scale.html#GUID-27FAB1C1-B09F-4A7A-9FB9-5CB8110F7141
NEW QUESTION # 83
Which two Oracle Cloud Infrastructure (OCI) resources do you need to create before initiating a manual backup of Oracle Autonomous Database?
- A. Object Storage Bucket
- B. Storage Gateway
- C. Backup Job
- D. Service Gateway
- E. Auth Token
Answer: A,E
NEW QUESTION # 84
Which two tasks can be executed from the service console for Autonomous Databases?
- A. configuring virtual cloud networks (VCNS)
- B. using a wizard to download connection wallet for connection from desktop tools
- C. monitoring Autonomous Databases for usage and query performance
- D. creating and scaling an Autonomous Database service
- E. starting and stopping an instance
Answer: B,C
NEW QUESTION # 85
Which statement is FALSE regarding database links?
- A. You can create a database link from one Autonomous Database to another Autonomous Database instance
- B. You can connect to a remote database from an Autonomous Database by using a database line
- C. You can connect to an Autonomous Database from a remote database using a database link
- D. You can call PL/SQL procedures and functions by using a database link
Answer: D
NEW QUESTION # 86
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
- A. through SQL/Developer s
- B. through the Oracle Cloud Infrastructure service console
- C. using DBMS_CLOUD_ADMIN package
- D. through SQLPIus
Answer: A,D
Explanation:
https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-service
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B
"To create users in your database, connect to the database as the ADMIN user using any SQL client tool." https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-create.html#GUID-54CA837B-CD6A-4ED2-A960-5874535818CB
NEW QUESTION # 87
Which statement is FALSE about setting up compartment quotas?
- A. Quotas set on a parent compartment override quotas set on child compartments.
- B. Compartment quotas cannot be set on the root compartment.
- C. You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.
- D. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
Answer: B
NEW QUESTION # 88
Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?
- A. Maximum Protection
- B. Maximum Performance
- C. Maximum Continuity
- D. Maximum Availability
Answer: B,D
NEW QUESTION # 89
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: C
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION # 90
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
- B. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
- C. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
- D. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/components.html#GUID-
268B36E1-87D8-4649-A370-226E2AE3FC5C
NEW QUESTION # 91
......
Authentic Best resources for 1z0-931-23 Online Practice Exam: https://www.freecram.com/Oracle-certification/1z0-931-23-exam-dumps.html
Get the superior quality 1z0-931-23 Dumps with explanations waiting just for you, get it now: https://drive.google.com/open?id=1-8k-foy986KR1wNo86y7ZGOkBFJFkY4U