1Z0-931-21 Practice Exam and Study Guides - Verified By Fast2test Updated 114 Questions
2022 Updated Verified Pass 1Z0-931-21 Study Guides & Best Courses
Oracle 1Z0-931-21 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
NEW QUESTION 66
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?
- 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 evaluates user types, how users are authenticated, and the password policies assigned to each user.
- D. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
Answer: B
NEW QUESTION 67
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 68
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: C
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION 69
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. Autonomous Transaction Processing only
- B. Autonomous Data Warehouse only
- C. Hybrid Columnar compression
- D. ATP and ADW
Answer: D
Explanation:
NEW QUESTION 70
A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.
What should they do to remove this bottleneck?
- A. Ask Support to migrate their setup to a node without noisy neighbors.
- B. Remove any non-JSON data from the database.
- C. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.
- D. Increase the number of OCPUs allocated to the database.
Answer: A
NEW QUESTION 71
Which statement is not correct when the Autonomous Database is stopped?
- A. User with DWROLE can still access the database
- B. CPU billing is halted
- C. Tools are no longer able to connect to a stopped instance
- D. In-flight transactions queries are stopped
Answer: A
Explanation:
NEW QUESTION 72
Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?
- A. Month of the Quarter, Week of the Month, Day of the Week, Start Hour
- B. Week of the Quarter, Day of the Week, Start Hour
- C. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour
- D. Month of the Year, Week of the Month, Day of the Week, Start Hour
Answer: A
Explanation:
NEW QUESTION 73
For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?
- A. ORDS_PRIV.ENABLE_SCHEMA
- B. SQLDEV_ADMIN.GRANT_SCHEMA
- C. ORDS_ADMIN.ENABLE_SCHEMA
- D. ORDS_ADMIN.GRANT_SCHEMA
Answer: D
NEW QUESTION 74
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. db-workload
- C. is-dedicated
- D. license-model
Answer: C
NEW QUESTION 75
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
- A. Under Solutions and Platform then Platform Services then Autonomous Exadata
- B. Under Core Infrastructure then Compute then Autonomous Exadata
- C. Under Database then Autonomous Transaction Processing then Autonomous Exadata
- D. Under Core Infrastructure then Autonomous Exadata
Answer: B
NEW QUESTION 76
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. SQL Developer
- B. The Oracle Client and the cx_Oracle interface for Python
- C. JAVA JDK
- D. You can't use Python with ADB.
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connecting-nodejs.html#GUID-AB1E323A-65B9-47C4-840B-EC3453F3AD53
https://developer.oracle.com/databases/database-for-python-developers-1.html
NEW QUESTION 77
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
- A. through SQLPIus
- B. through SQL/Developer s
- C. using DBMS_CLOUD_ADMIN package
- D. through the Oracle Cloud Infrastructure service console
Answer: A,B
Explanation:
https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-service
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B
"To create users in your database, connect to the database as the ADMIN user using any SQL client tool." https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-create.html#GUID-54CA837B-CD6A-4ED2-A960-5874535818CB
NEW QUESTION 78
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
- A. Under Solutions and Platform then Platform Services then Autonomous Exadata
- B. Under Database then Autonomous Transaction Processing then Autonomous Exadata
- C. Under Core Infrastructure then Compute then Autonomous Exadata
- D. Under Core Infrastructure 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 79
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 Insight
- B. Catalog
- C. Data Load
- D. JSON
Answer: B
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 80
Which two of the following statements are correct?
- A. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.
- B. ODI Web Edition is available only on Oracle Linux.
- C. The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.
- D. All of the capabilities of ODI Classic are available with ODI Web Edition,
Answer: A,B
NEW QUESTION 81
You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.
What statement describes the step to provide the developer a new workspace in APEX?
- A. Create an IDCS user with the APEX role.
- B. Create a database user with the APEX role.
- C. Create a new developer account.
- D. Access the APEX Administration Services and create the workspace for the developer.
Answer: D
Explanation:
https://docs.oracle.com/en/database/oracle/application-express/19.1/htmig/creating-workspace-and-adding-Oracle-AE-users.html#GUID-1040F145-452A-49D4-BCF6-A80851AFFA74 Create a New Instance Administrator Login to the INTERNAL workspace as the ADMIN user, or another existing admin user.
Click the "Create User" link on the right-hand menu.
For a new admin user enter mandatory items and the following.
Workspace : INTERNAL
Default Schema : APEX_180200 {or whatever the highest version is}
User is an administrator: Yes
Account Availability : Unlocked
Password and Confirmation Password.
Require Change of Password on First Use : Yes
Click the "Create User" button.
https://oracle-base.com/articles/misc/apex-tips-basic-apex-management
NEW QUESTION 82
You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.
What statement describes the step to provide the developer a new workspace in APEX?
- A. Create an IDCS user with the APEX role.
- B. Create a database user with the APEX role.
- C. Create a new developer account.
- D. Access the APEX Administration Services and create the workspace for the developer.
Answer: D
NEW QUESTION 83
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. is-dedicated
- C. db-workload
- D. license-model
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
NEW QUESTION 84
According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.
Which statement is true?
- A. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
- B. Create at least 2 of each resource
- C. Create a separate VCN that contains only public subnets
- D. Only 1 of each is allowed to be allocated per environment.
Answer: A
NEW QUESTION 85
Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?
- A. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
- B. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.
- C. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
- D. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.
Answer: B
NEW QUESTION 86
......
Ultimate Guide to the 1Z0-931-21 - Latest Edition Available Now: https://www.fast2test.com/1Z0-931-21-premium-file.html