[Sep 20, 2022] Get Free Updates Up to 365 days On Developing 1Z0-931-21 Braindumps
Best Quality Oracle 1Z0-931-21 Exam Questions
Oracle 1Z0-931-21 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
NEW QUESTION 40
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints
- A. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.
- B. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints
- C. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
- D. You can configure Private Endpoints for an Always Free Autonomous Database
Answer: B,C
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 41
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
- A. Under Core Infrastructure then Autonomous Exadata
- B. Under Database then Autonomous Transaction Processing then Autonomous Exadata
- C. Under Solutions and Platform then Platform Services then Autonomous Exadata
- D. Under Core Infrastructure then Compute then Autonomous Exadata
Answer: B
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory.
Even though the UI has changed recently, this documentation has the user go to Menu -> Database
NEW QUESTION 42
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. JSON
- B. Text
- C. Avro
- D. Microsoft SQL Server (.mdf)
- E. Parquet
- F. Data Pump Export File
Answer: C
NEW QUESTION 43
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 Listener endpoint where the Autonomous Database should register on
- B. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
- C. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
- D. the Client Credentials wallet which is used to connect to the Autonomous Database
- E. the 'High Availability Container Database' in which the Autonomous instance should run
Answer: D
NEW QUESTION 44
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. JSON
- B. Text
- C. Avro
- D. Parquet
- E. Data Pump Export File
- F. Microsoft SQL Server (.mdf)
Answer: F
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 45
A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data.
How does the developer connect to and interact with ADB from Python?
- A. The Oracle Client and the cx_Oracle interface for Python
- B. JAVA JDK
- C. You can't use Python with ADB.
- D. SQL Developer
Answer: B
NEW QUESTION 46
Which three are Oracle-recommended best practices for Autonomous Database alarms?
- A. Create multiple alarm metrics.
- B. Create a single alarm for each metric.
- C. Suppress alarms during investigations.
- D. Select the correct alarm interval for your metric.
- E. Use a single interval for all alarms.
- F. Routinely tune your alarms.
Answer: C,D,F
NEW QUESTION 47
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
- A. through SQL/Developer s
- B. through SQLPIus
- C. through the Oracle Cloud Infrastructure service console
- D. using DBMS_CLOUD_ADMIN package
Answer: A,B
NEW QUESTION 48
Which statement is true when connecting OCI Marketplace image to shared autonomous database?
- A. ADB must be configured with NSG
- B. Cannot connect OCI Market image to shared ADB
- C. ADB must be configured with Private endpoints
- D. Compute Image and Shared ADB must be in same VCN and Subnet
Answer: D
NEW QUESTION 49
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?
- A. Users have OS access to the database machine.
- B. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
- C. Users have SYS privileges in the database.
- D. Users can customize the OS stack and add additional packages
- E. Users can customize the maintenance schedule.
Answer: B,E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbat/index.html#articletitle
NEW QUESTION 50
Which native data type is used to store spatial information?
- A. GEO_JSON
- B. SDO_RELATE
- C. SDO_LOCATION
- D. SDO_GEOMETRY
Answer: D
NEW QUESTION 51
Which is NOT needed to manage Oracle Autonomous Database with REST APIS?
- A. Fingerprint of the public key
- B. User's OCID
- C. Database ADMIN password
- D. Tenancy's OCID
Answer: C
NEW QUESTION 52
Which statement is not correct when the Autonomous Database is stopped?
- A. Tools are no longer able to connect to a stopped instance
- B. User with DWROLE can still access the database
- C. In-flight transactions queries are stopped
- D. CPU billing is halted
Answer: B
Explanation:
NEW QUESTION 53
Which statement is FALSE about Oracle Autonomous JSON Database?
- A. It supports NoSQL-style, document-centric application
- B. JSON data is stored natively in the database
- C. There is a 20 GB limit on JSON collection
- D. You can promote Autonomous JSON Database to Autonomous Transaction /Processing
Answer: C
Explanation:
NEW QUESTION 54
Which statement is correct about the Service console in an Autonomous Database?
- A. You can use Service console to move Autonomous DB between compartments
- B. You can use Service console to manage runaway SQL statements on Autonomous DB
- C. You can use Service console to enable or disable auto scaling of Autonomous DB
- D. You can use Service console to create manual backups of Autonomous database
Answer: B
Explanation:
NEW QUESTION 55
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
- A. Exadata
- B. RAC, but only when scaling beyond 16 OCPUs
- C. Transparent Data Encryption
- D. Active Data Guard
- E. Multitenant
Answer: B,D
NEW QUESTION 56
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
- A. On the Autonomous Database Console.
- B. SSH keys are not required in Oracle Cloud Infrastructure.
- 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 57
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
- B. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
- C. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
- D. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
Answer: A
NEW QUESTION 58
You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance.
Which tool would you use to automate data exploration and create pivot tables?
- A. APEX
- B. SQL Developer Web
- C. Business Models
- D. Data Load
Answer: C
Explanation:
NEW QUESTION 59
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
- B. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
- C. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
- D. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/components.html#GUID-
268B36E1-87D8-4649-A370-226E2AE3FC5C
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 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 61
......
Oracle Exam Practice Test To Gain Brilliante Result: https://www.troytecdumps.com/1Z0-931-21-troytec-exam-dumps.html