[UPDATED 2023] Oracle 1z0-931-23 Questions Prepare with Free Demo of PDF
NEW 2023 Certification Sample Questions 1z0-931-23 Dumps & Practice Exam
NEW QUESTION # 56
Which statement is FALSE for Oracle Data Safe? (Choose the best answer.)
- A. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations
- B. Oracle Data Safe only supports Autonomous Databases
- C. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary
- D. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user
Answer: B
NEW QUESTION # 57
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
- A. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
- B. Transaction Count, Sessions, Running Statements
- C. CPU Utilization, Storage Utilization
- D. Query Latency, User Calls, Execute Count
Answer: A
NEW QUESTION # 58
Which three scaling options are available in Oracle Autonomous Database on Shared Infrastructure?
- A. Automatic online scaling of OCPU
- B. Manual online scaling of Storage
- C. Manual offline scaling of Storage and OCPU
- D. Automatic online scaling of Storage
- E. Manual online scaling of OCPU
Answer: A,C,D
NEW QUESTION # 59
Which statement is true when the Autonomous Database has auto scaling enabled?
- A. Increases the number of sessions available to the database.
- B. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.
- C. Database concurrency is scaled up when needed by the workload.
- D. Scales the PGA and SGA size when needed for the workload.
Answer: B
NEW QUESTION # 60
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. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
- B. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
- C. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
- D. ADW since operational reporting is a higher priority in this scenario.
Answer: A
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 # 61
Where do you find the URL for Database Actions?
- A. in the Database Users card under Database Actions
- B. on the SQL Developer Client Connection tab
- C. in the database with a SQL query
- D. in Oracle Cloud Infrastructure Object Storage
Answer: A
NEW QUESTION # 62
You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use?
- A. db-workload
- B. is-dedicated
- C. db-type
- D. license-model
Answer: B
Explanation:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
NEW QUESTION # 63
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
- A. OCI CLI
- B. OS command line from the database server.
- C. SQLDeveloper
- D. Admin page of the Cloud Service Console
Answer: B
NEW QUESTION # 64
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?
- A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'
- B. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
- C. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'DW'
- D. Allow group ADB-Admins to manage autonomous-database in tenancy.
Answer: B
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htm
NEW QUESTION # 65
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Backup Retention
- B. Memory Usage
- C. Data Organization
- D. Index Storage
- E. Undo Management
Answer: B,D
NEW QUESTION # 66
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?
- A. Route Table
- B. Network Security Group
- C. Security List
- D. Subnet
- E. VCN
Answer: B,D,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 # 67
You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements:
* Autonomous Transaction Processing
* Licence Tracluded
* Shared Infrastructure
Which parameter would you NOT use?
- A. db-workload
- B. licence-model
- C. db-type
- D. is-dedicaced
Answer: C
NEW QUESTION # 68
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. TP
- C. MEDIUM
- D. TPURGENT
Answer: D
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 # 69
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?
- A. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
- B. 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.
- C. 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.
- D. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
Answer: D
NEW QUESTION # 70
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 Administrators create, monitor and manage Autonomous Databases.
- C. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
- 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 # 71
What REST verb is used to create an Autonomous Database service using REST APIs?
- A. A "GET" REST call
- B. An "INSERT" REST call
- C. A "POST" REST call
- D. A "PUT" REST call
Answer: C
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 # 72
Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?
- A. Amazon S3
- B. Google Cloud Storage
- C. Oracle Cloud Infrastructure Object Storage
- D. Oracle Cloud Infrastructure Object Storage Classic
Answer: B
NEW QUESTION # 73
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
- A. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure
- B. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator
- C. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure
- D. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database
Answer: D
NEW QUESTION # 74
When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?
- A. scan hybrid partition tables
- B. prun column in parquet files
- C. Scan partition tables
- D. prun columns in csv files
Answer: C
NEW QUESTION # 75
What is the maximum number of days that an Autonomous Database Refreshable Clone can be trailing its source instance?
- A. 15 days
- B. 30 days
- C. 7 days
- D. 1 day
Answer: C
NEW QUESTION # 76
You enabled Autonomous Data Guard on Autonomous Database on Shared Infrastructure.
Which three statements are true about the standby database after a failover?
- A. A new wallet is required to connect to the standby database
- B. Autonomous Data Guard automatically creates a new standby database
- C. Oracle Machine Learning Notebooks created in the primary database are available in the standby database
- D. The OCPU Count, Storage, Display Name, Database Name, Auto Scaling, Tags, and Licensing options have the same values as the primary
- E. Autonomous Data Guard automatically reverts to the primary database when it becomes available again
Answer: B,C,D
NEW QUESTION # 77
What are the two supported infrastructure options for deploying an Autonomous Database?
- A. Shared Exadata Infrastructure
- B. VM on Oracle Cloud Infrastructure
- C. Any Oracle Engineered System
- D. Dedicated Exadata Infrastructure
- E. Bare-metal on Oracle Cloud Infrastructure
Answer: A,D
NEW QUESTION # 78
How do you change the tablespace quota for user MTHEO on Autonomous Database on Shared Infrastructure?
- A. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username = MTHEO', V U tablespace_quota -> UNLIMITED');
- B. Execute alter user MTHEO quota unlimited on tablespace DATA;
- C. Execute alter tablespace DATA det quota = 10G;
- D. Execute alter database for user MTHEO tableapace DATA quota = 10G;
Answer: A
NEW QUESTION # 79
Which is a feature of a graph query language?
- A. Scripting language
- B. Ability to specify patterns
- C. Object-oriented language
- D. Run key-value queries
Answer: B
NEW QUESTION # 80
......
1z0-931-23 Deluxe Study Guide with Online Test Engine: https://actualtests.crampdf.com/1z0-931-23-exam-prep-dumps.html