2024 Valid 1z0-931-23 Real Exam Questions (Updated) 100% Dumps & Practice Exam
[UPDATED 2024] Oracle 1z0-931-23 Questions Prepare with Free Demo of PDF
NEW QUESTION # 67
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
- A. Transaction Count, Sessions, Running Statements
- B. CPU Utilization, Storage Utilization
- C. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
- D. Query Latency, User Calls, Execute Count
Answer: C
NEW QUESTION # 68
Which option should you use to create a graph with Graph Studio?
- A. Graph created by a special tool downloaded from oracle.com
- B. A graph license key
- C. Graph analytics algorithms
- D. Tables in an Autonomous Database instance
- E. NoSQL configuration
Answer: D
NEW QUESTION # 69
In Graph Studio which you can use to create a graph?
- A. Graph created by a special tool downloaded from Oracle.com
- B. A graph license key
- C. Graph analytics algorithms
- D. Tables in an Autonomous Database instance
- E. NoSQL configuration
Answer: D
Explanation:
NEW QUESTION # 70
While creating a business model what advanced options you can enable or disable? (Choose three)
- A. Analytic View Base Table Query Transformation
- B. Display private tables
- C. Analytic View Transparency View
- D. Autonomous Aggregate Cache
- E. Business Object Security Feature
Answer: A,C,D
Explanation:
NEW QUESTION # 71
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. Users can customize the maintenance schedule.
- D. Users have SYS privileges in the database.
- E. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
Answer: C,E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbat/index.html#articletitle
NEW QUESTION # 72
Which three functions are provided by Spatial Studio?
- A. Spatial data editing
- B. Map visualization
- C. Custom SQL queries
- D. Spatial analysis
- E. Geocoding
Answer: B,D,E
NEW QUESTION # 73
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: B
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION # 74
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)
- A. Use Oracle Zero Downtime Migration (ZDM)
- B. Use SFTP to copy CSV files into Autonomous Database
- C. Use GoldenGate
- D. Use Data Pump
- E. Use Recovery Manager (RMAN)
Answer: A,C,D
Explanation:
https://www.oracle.com/sa/database/technologies/cloud-migration.html
NEW QUESTION # 75
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter user MTHEO quota unlimited on tablespace DATA;
- B. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- C. Execute alter tablespace DATA set quota = 10G;
- D. Execute alter database for user MTHEO tablespace DATA quota = 10G;
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0
NEW QUESTION # 76
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
Explanation:
NEW QUESTION # 77
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. Users can customize the maintenance schedule.
- D. Users have SYS privileges in the database.
- E. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
Answer: C,E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbat/index.html#articletitle
NEW QUESTION # 78
Which statement is true when connecting OCI Marketplace image to shared autonomous database?
- A. Cannot connect OCI Market image to shared ADB
- B. Compute Image and Shared ADB must be in same VCN and Subnet
- C. ADB must be configured with NSG
- D. ADB must be configured with Private endpoints
Answer: B
NEW QUESTION # 79
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?
- A. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
- B. Moving an Autonomous Database instance does not include its automatic backups.
- 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 # 80
Which four file formats are supported when loading data from Cloud Storage?
- A. CSV
- B. Parquet
- C. DDL
- D. AVRO
- E. JSON
- F. DOC
Answer: A,B,D,E
NEW QUESTION # 81
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)
- A. DBNAME_CONCURRENT
- B. DBNAME_LOW
- C. DBNAME_HIGH
- D. DBNAME_MEDIUM
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
NEW QUESTION # 82
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. Log onto ADW server and issue is -al on the command line.
- C. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
- 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 # 83
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?
- A. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
- B. Parallelism is not enabled by default.
- C. You have direct access to the database node.
- D. Oracle Database Result Cache is enabled by default for all SQL statements.
Answer: A,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/appendix-autonomous-database-data-warehouse-workload.html#GUID-604A08F8-8021-43CE-AA95-823045E14BD8
NEW QUESTION # 84
Your customer wants to permanently disable scheduled maintenance on the Autonomous Database on Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?
- A. You cannot permanently disable scheduled automatic maintenance
- B. Change the Automatic Maintenance Schedule to "Specify a Schedule," but do not select any ^ month, week, or day
- C. Change the Automatic Maintenance Schedule to "None"
- D. Change the Automatic Maintenance Schedule to "No Preference"
Answer: A
NEW QUESTION # 85
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?
- A. Subnet
- B. Network Security Group
- C. Security List
- D. Route Table
- E. VCN
Answer: A,B,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 # 86
......
1z0-931-23 Deluxe Study Guide with Online Test Engine: https://www.practicedump.com/1z0-931-23_actualtests.html
NEW 2024 Certification Sample Questions 1z0-931-23 Dumps & Practice Exam: https://drive.google.com/open?id=1WhObMLvNWpx_hJx5e_flUtuKfz-fjjie