Updated Jul 02, 2024 Certification Exam 1z0-931-23 Dumps - Practice Test Questions
Updated Verified 1z0-931-23 dumps Q&As - Pass Guarantee or Full Refund
Oracle 1z0-931-23 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
NEW QUESTION # 45
Which subset of services is offered via OCI-CLI (command line interface) for Autonomous Database (ADB) via calls made to the OCI APIs?
- A. Start, Delete, Update, Query, Stop
- B. Create, Get, List, Stop, Restore
- C. Create, Query, List, Stop, Restore
- 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 the autonomous-database section of the OCI-CLI Command Reference1. Reference:
Command Line Interface (CLI) - Oracle Help Center, section "autonomous-database".
autonomous-database - OCI CLI Command Reference 3.34.0 documentation - Oracle.
NEW QUESTION # 46
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. TPURGENT
- D. HIGH
Answer: C
NEW QUESTION # 47
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?
- A. Users can customize the OS stack and add additional packages
- B. Users have OS access to the database machine.
- C. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
- D. Users can customize the maintenance schedule.
- E. Users have SYS privileges in the database.
Answer: C,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbat/index.html#articletitle
NEW QUESTION # 48
What is the number of concurrent statements that can be handled by the medium database service name?
- A. 1-25 X OCPU
- B. OS
- C. unlimited
- D. 20 X OCPU
Answer: A
NEW QUESTION # 49
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 # 50
Which statement is true about OCPUs and storage when you choose to scale your Autonomous Database?
- A. Increasing OCPUs will automatically increase storage
- B. OCPUs and storage can be scaled independently
- C. OCPUs and storage must remain in sync
- D. Use auto scaling to increase storage
Answer: B
NEW QUESTION # 51
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-type
- B. license-model
- C. is-dedicated
- D. db-workload
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
NEW QUESTION # 52
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
- A. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
- B. Using Database Configuration Assistant (DBCA) on the database server.
- C. It cannot be done.
- D. Connecting to the Cloud Infrastructure Command console via SSH wallet.
Answer: A
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 # 53
Which statement is FALSE for Oracle Data Safe? (Choose the best answer.)
- A. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary
- B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations
- C. Oracle Data Safe only supports Autonomous Databases
- D. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user
Answer: C
NEW QUESTION # 54
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 did not complete either due to an error.
- B. The SQL statement completed its execution.
- C. The SQL statement is executing.
- D. The SQL statement is queued.
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm
NEW QUESTION # 55
Which statement is FALSE about the Catalog tool?
- A. You can view the data definition of an entity.
- B. Impact shows the entities that depend on the source.
- C. You can limit the display of entities to only those with certain names, schemas, types, or applications by entering values in the Search field.
- D. You can delete an entity from the Autonomous Database via the Catalog tool.
Answer: D
Explanation:
The Catalog tool is a built-in feature of Autonomous Database that provides an easily searchable inventory of all the objects in, or accessible from, the database, such as schemas, tables, views, columns, analytic views, files on cloud object storage, and more1. However, the Catalog tool does not allow you to delete any entity from the database. You can only view the details, lineage, and impact of an entity using the Catalog tool2. To delete an entity from the database, you need to use other tools such as SQL Developer Web or APEX3. Reference:
Manage Automatic Indexing on Autonomous Database - Oracle Help Center.
Introducing the Autonomous Database Catalog - Oracle Blogs.
Oracle Autonomous Database - Oracle Autonomous Database.
NEW QUESTION # 56
When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?
- A. 2 hours
- B. 24 hours
- C. 1 hours
- D. 30 minutes
Answer: A
Explanation:
Clone Sources
You can use a running database to create a clone. For databases running on shared Exadata infrastructure, you can also use a backup as the source of your clone. When using a backup, you can select a listed backup to clone from, or create a point-in-time clone. Point-in-time clones contain all data up to a specified timestamp. The specified timestamp must be in the past.
Note When you create a clone from a backup, you must select a backup that is at least two hours old.
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbcloning.htm
NEW QUESTION # 57
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. The standby database is terminated.
- C. Failover is automatically initiated.
- D. Switchover is automatically initiated.
Answer: A
NEW QUESTION # 58
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. Hybrid Columnar compression
- B. ATP and ADW
- C. Autonomous Data Warehouse only
- D. Autonomous Transaction Processing only
Answer: B
Explanation:
NEW QUESTION # 59
Which workload is particularly suited to Oracle Autonomous JSON Database?
- A. Transactions
- B. Data Lakes
- C. Data Marts
- D. Schemaless, document centric
Answer: D
NEW QUESTION # 60
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 did not complete either due to an error.
- B. The SQL statement completed its execution.
- C. The SQL statement is executing.
- D. The SQL statement is queued.
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm
NEW QUESTION # 61
Which two statements are true about Oracle Cloud Infrastructure (OCI)?
- A. A single fault domain can be associated with multiple regions and availability domains
- B. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region
- C. Because availability domains do not share infrastructure, such as power or cooling, or the Internal availability domain network, a failure at one availability domain within a region is u likely to impact the availability of the there within the same region
- D. Regions are dependent on other regions and must be located within five thousand kilometers of each other
Answer: B,C
NEW QUESTION # 62
......
Exam Engine for 1z0-931-23 Exam Free Demo & 365 Day Updates: https://www.prep4sureguide.com/1z0-931-23-prep4sure-exam-guide.html
1z0-931-23 PDF Questions and Testing Engine With 183 Questions: https://drive.google.com/open?id=1lxLoT5AMyEMdUoLTLLGYwUj9zAEq3nhF