[Nov 12, 2023] Get New 1z0-931-23 Certification – Valid Exam Dumps Questions
100% Passing Guarantee - Brilliant 1z0-931-23 Exam Questions PDF
NEW QUESTION # 51
Which three are Oracle-recommended best practices for Autonomous Database alarms?
- A. Select the correct alarm interval for your metric.
- B. Create a single alarm for each metric.
- C. Create multiple alarm metrics.
- D. Suppress alarms during investigations.
- E. Routinely tune your alarms.
- F. Use a single interval for all alarms.
Answer: A,D,E
NEW QUESTION # 52
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. TP
- B. TPURGENT
- C. LOW
- D. MEDIUM
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 # 53
Which two are ways Oracle Database can optimally access data in Object Storage?
- A. Optimized data archive using hybrid partitioned tables
- B. Scan avoidance using columnar pruning for .csv files
- C. Optimized data archive using partitioned external tables
- D. Scan avoidance using partitioned external tables
Answer: A,D
NEW QUESTION # 54
On which two infrastructure classes can the Autonomous Database service be deployed?
- A. Exadata Cloud Service
- B. Shared Exadata Infrastructure
- C. Dedicated Exadata Infrastructure
- D. Oracle Cloud Infrastructure Virtual Machines
Answer: B,C
NEW QUESTION # 55
How do you change the tablespace quota for user MTHEO on Autonomous Database on Shared Infrastructure?
- A. Execute alter tablespace DATA det quota = 10G;
- B. Execute alter database for user MTHEO tableapace DATA quota = 10G;
- C. Execute alter user MTHEO quota unlimited on tablespace DATA;
- D. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username = MTHEO', V U tablespace_quota -> UNLIMITED');
Answer: D
NEW QUESTION # 56
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. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
- C. Access to Database Actions is available for all users of Autonomous Database.
- D. 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.
- E. SQL Developer Web is available exclusively on the Autonomous Database.
Answer: A,D
NEW QUESTION # 57
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- A. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
- B. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
- C. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
- D. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
- E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
Answer: C,D,E
Explanation:
DELETE_FILE Procedure
This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.
CREATE_CREDENTIAL Procedure
This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. Use stored credentials for data loading or for querying external data residing in the Cloud.
PUTJDBJECT Procedure
This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).
VALIDATE EXTERNAL TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.
To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.
This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're moving the log import.log to object store with a DBMS_CLOUD.PUT_OBJECT command.
VALIDATE_EXTERNAL_TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Database. The overloaded form enables you to use the operation_id parameter.
PUT_OBJECT Procedure
This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB) DELETE FILE Procedure This procedure removes the specified file from the specified directory on Autonomous Database.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Database.
NEW QUESTION # 58
Which two statements are true about Oracle Cloud Infrastructure (OCI)?
- A. Regions are dependent on other regions and must be located within five thousand kilometers of each other
- B. 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
- C. A single fault domain can be associated with multiple regions and availability domains
- D. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region
Answer: B,D
NEW QUESTION # 59
What is the number of concurrent statements that can be handled by the medium database service name?
- A. 1-25 X OCPU
- B. unlimited
- C. OS
- D. 20 X OCPU
Answer: A
NEW QUESTION # 60
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 are not required in Oracle Cloud Infrastructure.
- B. On the Autonomous Database Console.
- C. SSH keys cannot be added from console. They have to be added using REST APIs only.
- 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 # 61
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: D
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION # 62
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 # 63
Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?
- A. In a separate key vault external to the Exadata Infrastructure
- B. inside the Autonomous Database wallet
- C. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted
- D. inside the backups of the container database
Answer: A
NEW QUESTION # 64
Which three tasks are performed from the service console of an Autonomous Database on Shared Infrastructure?
- A. Rotate the wallet
- B. Set resource management rules
- C. Enable autoscaling
- D. Download the wallet
- E. Manage Oracle Machine Learning users
Answer: A,C,D
NEW QUESTION # 65
Where do you find the URL for Database Actions?
- A. in Oracle Cloud Infrastructure Object Storage
- B. on the SQL Developer Client Connection tab
- C. in the database with a SQL query
- D. in the Database Users card under Database Actions
Answer: D
NEW QUESTION # 66
......
Free 1z0-931-23 braindumps download: https://www.examcollectionpass.com/Oracle/1z0-931-23-practice-exam-dumps.html
1z0-931-23 Dumps 2023 - NewOracle Exam Questions: https://drive.google.com/open?id=1fxfi2Qt0l9i0CTX407T1O1djhb-aMkIL