Exam Passing Guarantee Apr 13, 2024 1z0-931-23 Exam with Accurate Quastions!
Test Engine to Practice Test for 1z0-931-23 Valid and Updated Dumps
NEW QUESTION # 78
You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?
- A. Create a notification alert using DBMS_SNMP package
- B. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric
- C. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database
- D. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"
Answer: D
NEW QUESTION # 79
Which is a feature of a graph query language?
- A. Run key-value queries
- B. Ability to specify patterns
- C. Scripting language
- D. Object-oriented language
Answer: B
NEW QUESTION # 80
Which Database Actions tool is used to get information about the entries on your Oracle Autonomous Database and to see the effect that changing an object has on other objects.
- A. Data Load
- B. Data Insight
- C. Catalog
- D. JSON
Answer: C
Explanation:
Data Catalog
Data Catalog: it helps to get information about the entities in your Oracle Autonomous Database and to see the effect that changing an object has on other objects. Data lineage and impact analysis is key for a Data driven company.
NEW QUESTION # 81
When enabling auto-scaling, which three options do not change?
- A. parallelism settings
- B. Amount of storage
- C. I/O resources
- D. Number of OCPUs displayed in the console.
- E. Level of concurrency
Answer: A,B,E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-scale.html#GUID-27FAB1C1-B09F-4A7A-9FB9-5CB8110F7141
NEW QUESTION # 82
Which three are Oracle-recommended best practices for Autonomous Database alarms?
- A. Routinely tune your alarms.
- B. Suppress alarms during investigations.
- C. Select the correct alarm interval for your metric.
- D. Use a single interval for all alarms.
- E. Create multiple alarm metrics.
- F. Create a single alarm for each metric.
Answer: A,B,C
NEW QUESTION # 83
What is the correct way to list all files in the default data pump directory?
- A. By executing select * from utl_file . list ( 'DATA_PUMP_DIR ' ) ;
- B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
- C. Log onto ADW server and issue is -al on the command line.
- D. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
Answer: D
Explanation:
To list all files in the default data pump directory, you can use the DBMS_CLOUD.LIST_FILES procedure with the directory name as the parameter. See Listing Files in a Directory for more details.
NEW QUESTION # 84
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. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
- B. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
- 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: B
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 # 85
Where do you find the URL for Database Actions?
- A. in the Database Users card under Database Actions
- B. in the database with a SQL query
- C. on the SQL Developer Client Connection tab
- D. in Oracle Cloud Infrastructure Object Storage
Answer: A
NEW QUESTION # 86
Which two methods can you use to define Oracle Machine Learning users?
- A. SQL Developer
- B. the DBMS_CLOUD_ADMIN package
- C. Service Console
- D. Oracle Cloud Infrastructure Console
Answer: D
NEW QUESTION # 87
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
- A. SSH keys cannot be added from console. They have to be added using REST APIs only.
- B. On the Autonomous Database Console.
- C. SSH keys are not required in Oracle Cloud Infrastructure.
- D. Navigate to Identity, select Users panel on the console and select "Add Public Key".
Answer: D
Explanation:
- In the Console, click Identity, and then click Users. Locate the user in the list, and then click the user's name to view the details.
-Click Add Public Key.
- Paste the key's value into the window and click Add.
NEW QUESTION # 88
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
- B. alter session set application_continuity=true
- C. alter database set application_continuity=true
- D. alter system set application_continuity=true
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-42B9DDB0-12A7-4EE3-9860-30EFA41061E9 If it was asking for Autonomous Database Dedicated Infrastructure, then answer would be execute DBMS_APP_CONT_ADMIN.ENABLE_AC( 'databaseid_tpurgent.adb.oraclecloud.com', 'LEVEL1', 600);
NEW QUESTION # 89
Who, and in which order, provisions dedicated Exadata Infrastructure resources?
- A. The database administrator provisions the Autonomous Exadata Infrastructure. Then, the fleet administrator provisions the Autonomous Container DB and then the Autonomous DB
- B. The database administrator provisions the Autonomous Container DB and the Autonomous DB Then, the feet administrator provisions the Autonomous Exadata Infrastructure
- C. The fleet administrator provisions the Autonomous Exadata Infrastructure. Then, the database administrator provisions the Autonomous Container DB and then the Autonomous DB
- D. The fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB. Then, the database administrator provisions the Autonomous DB
Answer: D
NEW QUESTION # 90
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?
- A. Storage
- B. Parallelism
- C. Concurency
- D. Sessions
- E. Memory
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:
NEW QUESTION # 91
Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?
- A. inside the Autonomous Database wallet
- B. In a separate key vault external to the Exadata Infrastructure
- C. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted
- D. inside the backups of the container database
Answer: B
NEW QUESTION # 92
Which two actions can you perform with Autonomous Data Guard enabled on Autonomous Database on Shared Infrastructure?
- A. Failover
- B. Reinstate
- C. View Apply Lag
- D. Change Protection Mode
- E. Switchover
Answer: A,E
Explanation:
Autonomous Data Guard is a feature of Autonomous Database on Shared Infrastructure that provides data protection and disaster recovery for your database by creating and maintaining a standby database that continuously gets updated with the changes from the primary database4. With Autonomous Data Guard enabled, you can perform a switchover or a failover operation to switch roles between the primary and standby databases. A switchover is a planned role reversal that does not affect availability5. A failover is an unplanned role reversal that occurs when the primary database becomes unavailable due to a failure or disaster6. You cannot perform a reinstate operation, which is used to re-synchronize a disabled standby database with the primary database after a failover7. You also cannot change the protection mode, which determines how redo data is transmitted from the primary database to the standby database4. You can only view the apply lag, which is the difference between the redo applied on the standby database and the redo generated on the primary database5. Reference:
Use Standby Databases with Autonomous Data Guard for Disaster Recovery - Oracle Help Center.
Switch Roles in an Autonomous Data Guard Configuration - Oracle Help Center.
Fail Over to the Standby in an Autonomous Data Guard Configuration - Oracle Help Center.
Reinstate the Disabled Standby in an Autonomous Data Guard Configuration - Oracle Help Center.
NEW QUESTION # 93
Which index type is designed to index catalog information?
- A. CONTEXT
- B. CTXRULE
- 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 # 94
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?
- A. the 'High Availability Container Database' in which the Autonomous instance should run
- B. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
- C. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
- D. the Client Credentials wallet which is used to connect to the Autonomous Database
- E. the Listener endpoint where the Autonomous Database should register on
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adb_dedicated_creating.htm
NEW QUESTION # 95
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?
- A. Moving an Autonomous Database instance does not include its automatic backups.
- B. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
- C. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
- D. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/databaseoverview.htm#moveRes
NEW QUESTION # 96
......
Exam Questions for 1z0-931-23 Updated Versions With Test Engine: https://www.passexamdumps.com/1z0-931-23-valid-exam-dumps.html
Pass 1z0-931-23 Exam with Updated 1z0-931-23 Exam Dumps PDF: https://drive.google.com/open?id=13FyA59eEKLTfTCSJk6NCQt2LdftPc_rY
