Oracle Cloud 1Z0-931-24 Practice Test Engine: Try These 236 Exam Questions
Guaranteed Success in Oracle Cloud 1Z0-931-24 Exam Dumps
NEW QUESTION # 42
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-type
- B. licence-model
- C. is-dedicaced
- D. db-workload
Answer: A
NEW QUESTION # 43
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. Avro
- B. Data Pump Export File
- C. JSON
- D. Microsoft SQL Server (.mdf)
- E. Parquet
- F. Text
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/format-options.html#GUID-08C44CDA-7C81-481A-BA0A-F7346473B703
.mdf format is for MS SQL server database file
NEW QUESTION # 44
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
- A. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure
- B. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator
- C. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database
- D. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure
Answer: C
NEW QUESTION # 45
Which two tasks can be executed from the service console for Autonomous Databases?
- A. using a wizard to download connection wallet for connection from desktop tools
- B. creating and scaling an Autonomous Database service
- C. starting and stopping an instance
- D. configuring virtual cloud networks (VCNS)
- E. monitoring Autonomous Databases for usage and query performance
Answer: A,E
NEW QUESTION # 46
What is the maximum number of days that an Autonomous Database Refreshable Clone can be trailing its source instance?
- A. 15 days
- B. 1 day
- C. 7 days
- D. 30 days
Answer: C
NEW QUESTION # 47
What is the number of concurrent statements that can be handled by the medium database service name?
- A. unlimited
- B. OS
- C. 20 X OCPU
- D. 1-25 X OCPU
Answer: D
NEW QUESTION # 48
Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?
- A. You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.
- B. The Oracle Client Credential file is downloaded as a ZIP file.
- C. In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.
- D. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.
Answer: D
Explanation:
When you download the client credentials from the Download Wallet dialog, you must enter a wallet password in the password field and confirm the password in the confirm password field. The password must be at least eight characters long and must include at least one letter and one numeric character or one special character. This password protects the download client credentials wallet. This wallet is not the same as the transparent data encryption wallet for the database. Therefore, a different password is used to protect the client credentials wallet.
NEW QUESTION # 49
When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?
- A. OCPUs and storage can be scaled independently.
- B. Increasing OCPUs will automatically increase storage.
- C. OCPUs and storage must remain in sync.
- D. Storage in TB cannot be larger than the number of OCPUs.
Answer: A
Explanation:
You simply specify the number of OCPUs and the storage capacity in TB's for the database. At any time, you may scale, increase or decrease either the OCPUs or the storage capacity.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-add-resources.html#GUID-DA72422A-5A70-42FA-A363-AB269600D4B0
NEW QUESTION # 50
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?
- A. HIGH
- B. MEDIUM
- C. LOW
- D. TPPERFORMANT
- E. TPURGENT
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 # 51
Which subset of services is offered via OCI-CLI (command line interface) for Autonomous Database (ADB) via calls made to the OCI APIs?
- A. Create, Query, List, Stop, Restore
- B. Create, Get, List, Stop, Restore
- C. Start, Delete, Update, Query, Stop
- D. Create, Query, Update, List, Start
Answer: B
Explanation:
OCI-CLI is a command line interface tool that can be used to interact with Oracle Cloud Infrastructure services, including Autonomous Database. The OCI-CLI provides commands for creating, getting, listing, stopping, and restoring Autonomous Database instances. These commands are documented in theautonomous-databasesection of the OCI-CLI Command Reference1.
Command Line Interface (CLI) - Oracle Help Center, section "autonomous-database".
autonomous-database - OCI CLI Command Reference 3.34.0 documentation - Oracle.
NEW QUESTION # 52
When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?
- A. The SQL statement is executing.
- B. The SQL statement did not complete either due to an error.
- C. The SQL statement is queued.
- D. The SQL statement completed its execution.
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm
NEW QUESTION # 53
Where do you find the URL for Database Actions?
- A. in Oracle Cloud Infrastructure Object Storage
- B. in the Database Users card under Database Actions
- C. in the database with a SQL query
- D. on the SQL Developer Client Connection tab
Answer: B
NEW QUESTION # 54
Which statement is correct about the version of Java that is recommended for use with tools that use Java Database Connectivity (JDBC) connections?
- A. Java Development Kit Version 8 or higher
- B. JDBC .Jar files are specific to each platform.
- C. JDBC drivers do NOT support multiple Java Developer Kit versions.
- D. It doesn't matter, but you must Install the JCE Unlimited Strength Policy Files.
- E. Java Development Kit Version 7
Answer: B
NEW QUESTION # 55
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Data Organization
- B. Backup Retention
- C. Index Storage
- D. Memory Usage
- E. Undo Management
Answer: C,D
NEW QUESTION # 56
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints
- A. A Network Security Group is required within your Virtual Cloud Network before you can provision a
- B. An Autonomous Database with private endpoints can be accessed from the public internet by
- C. You can configure Private Endpoints for an Always Free Autonomous Database
- D. Private Endpoints can be configured when you clone a Shared Autonomous Database that was
Answer: A,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/network-private-endpoint-change.html#GUID-9F76DD5E-85A3-4F5E-A88D-3D4D131FC2CA Enabling a private endpoint for an Autonomous Database ensures that the only access path to the database is via a VCN inside your Oracle Cloud Infrastructure tenancy. This network configuration completely blocks access to the database from public endpoints
NEW QUESTION # 57
Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's?
- A. Create, Query, List, Stop, Restore
- B. Create, Get, List, Stop, Restore
- C. Start, Delete, Update, Query, Stop
- D. Create, Query, Update, List, Start
Answer: B
Explanation:
https://docs.cloud.oracle.com/en-us/iaas/tools/oci-cli/2.9.10/oci_cli_docs/cmdref/db/autonomous-database.html
NEW QUESTION # 58
What REST verb is used to create an Autonomous Database service using REST APIs?
- A. A "PUT" REST call
- B. A "GET" REST call
- C. An "INSERT" REST call
- D. A "POST" REST call
Answer: D
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 Databasefor more details.
NEW QUESTION # 59
Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.
Which statement is FALSE regarding the auto scaling feature?
- A. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands.
- B. Auto scaling is enabled by default and can be enabled or disabled at any time.
- C. The base number of OCPU cores allocated to a database is not guaranteed.
- D. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.
Answer: C
NEW QUESTION # 60
......
Test Engine to Practice 1Z0-931-24 Test Questions: https://torrentvce.pass4guide.com/1Z0-931-24-dumps-questions.html