[2024] Use Valid Exam 1z0-931-23 by VCE4Dumps Books For Free Website
Free Oracle Cloud 1z0-931-23 Official Cert Guide PDF Download
Oracle 1z0-931-23 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
NEW QUESTION # 33
Which are the two restrictions for an Always Free Autonomous Database?
- A. supports only ATP as a workload type
- B. Oracle Application Express (APEX) not included
- C. maximum of two Always Free Databases per OCI tenancy
- D. maximum of one OCPU per Database
Answer: C,D
NEW QUESTION # 34
Which statement is correct about the Service console in an Autonomous Database?
- A. You can use Service console to enable or disable auto scaling of Autonomous DB
- B. You can use Service console to move Autonomous DB between compartments
- C. You can use Service console to create manual backups of Autonomous database
- D. You can use Service console to manage runaway SQL statements on Autonomous DB
Answer: D
Explanation:
NEW QUESTION # 35
Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?
- A. Maximum Performance
- B. Maximum Continuity
- C. Maximum Availability
- D. Maximum Protection
Answer: A,C
NEW QUESTION # 36
When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?
- A. prun columns in csv files
- B. Scan partition tables
- C. scan hybrid partition tables
- D. prun column in parquet files
Answer: B
NEW QUESTION # 37
What is the number of concurrent statements that can be handled by the medium database service name?
- A. 20 X OCPU
- B. unlimited
- C. 1-25 X OCPU
- D. OS
Answer: C
NEW QUESTION # 38
Which three event types are supported for Autonomous Database?
- A. Change Compartment Begin
- B. Change Autoscaling Configuration Compartment
- C. Maintenance Begin
- D. Terminate End
- E. Update IORM Begin
Answer: A,C,D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htm
NEW QUESTION # 39
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
- A. SQLDeveloper
- B. Admin page of the Cloud Service Console
- C. OS command line from the database server.
- D. OCI CLI
Answer: C
NEW QUESTION # 40
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?
- A. Fleet Administrators are responsible for patching and backups of all container databases.
- B. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
- C. Fleet Administrators create, monitor and manage Autonomous Databases.
- D. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbah/index.html#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/index.html
NEW QUESTION # 41
Which is a feature of a graph query language?
- A. Scripting language
- B. Ability to specify patterns
- C. Run key-value queries
- D. Object-oriented language
Answer: B
NEW QUESTION # 42
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.ENABLE_SCHEMA
- B. ORDS_ADMIN.GRANT_SCHEMA
- C. SQLDEV_ADMIN.GRANT_SCHEMA
- D. ORDS_PRIV.ENABLE_SCHEMA
Answer: A
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 # 43
Which three methods can be used to migrate on-premises databases to Oracle Autonomous Database (both Shared and Dedicated)?
- A. RMAN backup & restore
- B. Oracle Data Pump
- C. Orace Zero Downtime Migration (ZDM)
- D. Original imp/exp tools
- E. Oracle Golden Gate
- F. Physical migration methods, such as database cloning
Answer: B,C,E
NEW QUESTION # 44
On which two infrastructure classes can the Autonomous Database service be deployed?
- A. Dedicated Exadata Infrastructure
- B. Exadata Cloud Service
- C. Oracle Cloud Infrastructure Virtual Machines
- D. Shared Exadata Infrastructure
Answer: A,D
NEW QUESTION # 45
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?
- A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
- B. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
- C. ADW since operational reporting is a higher priority in this scenario.
- D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
Answer: D
Explanation:
Autonomous Transaction Processing provides all of the performance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store.
As a service Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.
NEW QUESTION # 46
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. Transaction Count, Sessions, Running Statements
- D. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
Answer: D
NEW QUESTION # 47
Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?
- A. Oracle Database Vault, Oracle Key Vault
- B. Oracle Key Vault, Oracle Cloud Infrastructure Vault
- C. Oracle Audit Vault, Oracle Key Vault
- D. Oracle Cloud Infrastructure Vault, Oracle Database Vault
Answer: D
NEW QUESTION # 48
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. Autonomous Data Warehouse only
- B. Autonomous Transaction Processing only
- C. ATP and ADW
- D. Hybrid Columnar compression
Answer: C
NEW QUESTION # 49
Which two statements are true about accessing Autonomous Database Tools?
- A. Oracle APEX can be accessed only from the Developer menu in the Service Console.
- B. Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpoint networking.
- C. Access to Database Actions is available for all users of Autonomous Database.
- D. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
- E. SQL Developer Web is available exclusively on the Autonomous Database.
Answer: A,B
NEW QUESTION # 50
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. Autonomous Data Warehouse only
- B. Autonomous Transaction Processing only
- C. ATP and ADW
- D. Hybrid Columnar compression
Answer: C
Explanation:
NEW QUESTION # 51
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- B. Execute alter database for user MTHEO tablespace DATA quota = 10G;
- C. Execute alter tablespace DATA set quota = 10G;
- D. Execute alter user MTHEO quota unlimited on tablespace DATA;
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0
NEW QUESTION # 52
Which index type is designed to index catalog information?
- A. CTXRULE
- B. CONTEXT
- C. CONTAINS
- D. CTXCAT
Answer: D
Explanation:
CTXCAT is an index type that is designed to index catalog information such as product names, prices, descriptions, etc. CTXCAT indexes are suitable for e-commerce applications where users can query on multiple attributes of a product8. CTXCAT indexes are faster to create and maintain than CONTEXT indexes, which are designed to index large amounts of text such as documents, web pages, etc. CTXCAT indexes also support mixed queries that combine structured and unstructured predicates9. CTXRULE is an index type that is designed to index a set of queries or rules that can be evaluated against documents or rows in a table10. CONTAINS is not an index type, but a SQL operator that performs text searches on CONTEXT and CTXRULE indexes11. Reference:
Oracle Text Indexing Elements - Oracle Help Center, section "CTXCAT Index Type".
Oracle Text Application Developer's Guide - Oracle Help Center, section "Choosing an Index Type", subsection "When to Use a CTXCAT Index".
Oracle Text Indexing Elements - Oracle Help Center, section "CTXRULE Index Type".
CONTAINS - Oracle Help Center.
NEW QUESTION # 53
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 # 54
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. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
- C. Virtual Cloud Network, Compartments, Policies, 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 # 55
You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.
Which service will you need to connect to?
- A. LOW
- B. TPURGENT
- C. MEDIUM
- D. TP
Answer: B
Explanation:
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE
NEW QUESTION # 56
......
Oracle 1z0-931-23 Official Cert Guide PDF: https://prep4sure.vce4dumps.com/1z0-931-23-latest-dumps.html