1Z0-931-21 Dumps PDF 2022 Strategy Your Preparation Efficiently
Latest Verified & Correct Oracle 1Z0-931-21 Questions
NEW QUESTION 24
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. Hybrid Columnar compression
- B. ATP and ADW
- C. Autonomous Transaction Processing only
- D. Autonomous Data Warehouse only
Answer: D
NEW QUESTION 25
Which native data type is used to store spatial information?
- A. SDO_GEOMETRY
- B. GEO_JSON
- C. SDO_LOCATION
- D. SDO_RELATE
Answer: A
NEW QUESTION 26
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. Data Load
- C. SQL Developer Web
- D. Business Models
Answer: B
Explanation:
NEW QUESTION 27
What happened with the standby database when disabling Autonomous Data Guard?
- A. The standby database is transformed in a refreshable clone
- B. The standby database is terminated
- C. The standby database is started read only
- D. The standby database is started readwrite
Answer: B
NEW QUESTION 28
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. alter session set application_continuity=true
- B. alter database set application_continuity=true
- C. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
- D. alter system set application_continuity=true
Answer: D
NEW QUESTION 29
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
- A. Transparent Data Encryption
- B. RAC, but only when scaling beyond 16 OCPUs
- C. Multitenant
- D. Active Data Guard
- E. Exadata
Answer: B,C
Explanation:
Refer to https://www.oracle.com/autonomous-database/autonomous-data-warehouse/pricing/ If you run Oracle Database Enterprise Edition and the required options listed below, then your BYOL requirements are as follows:
For 1-16 OCPUs of a single Oracle Autonomous Data Warehouse instance:
For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate up to 2 OCPUs of the BYOL Cloud Service.
For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate 1 OCPU of the BYOL Cloud Service.
For 17 OCPUs or more of a single Oracle Autonomous Data Warehouse:
For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate up to 2 OCPUs of the BYOL Cloud Service.
For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate 1 OCPU of the BYOL Cloud Service.
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html "Do customers need Exadata licenses to benefit from BYOL?"
NEW QUESTION 30
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)
- A. DBNAME_MEDIUM
- B. DBNAME_CONCURRENT
- C. DBNAME_HIGH
- D. DBNAME_LOW
Answer: D
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 31
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. Access the APEX Administration Services and create the workspace for the developer.
- C. Create a database user with the APEX role.
- D. Create a new developer account.
Answer: B
NEW QUESTION 32
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. Access the APEX Administration Services and create the workspace for the developer.
- C. Create a database user with the APEX role.
- D. Create a new developer account.
Answer: B
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 33
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 find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
- 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 assess the security of your cloud database configurations by analyzing database configurations.
Answer: B
Explanation:
https://www.oracle.com/database/technologies/security/data-safe.html
https://www.oracle.com/a/tech/docs/dbsec/data-safe/faq-security-data-safe.pdf Data Safe works with the following Oracle Databases Oracle on-Premises Databases Oracle Cloud Databases
- Autonomous Database on Shared Exadata Infrastructure
- Autonomous Database on Dedicated Exadata Infrastructure
- Exadata DB systems
- Database Cloud Service on Virtual Machine
- Database Cloud Service on Bare Metal
- Oracle Database on Compute
NEW QUESTION 34
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. Navigate to Identity, select Users panel on the console and select "Add Public Key".
- D. SSH keys cannot be added from console. They have to be added using REST APIs only.
Answer: C
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 35
Which two are correct actions to take in order to Download the Autonomous Database Credentials?
- A. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
- B. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
- C. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
- D. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
- E. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
Answer: C,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1
NEW QUESTION 36
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
- A. Transparent Data Encryption
- B. Multitenant
- C. Active Data Guard
- D. RAC, but only when scaling beyond 16 OCPUs
- E. Exadata
Answer: C,D
NEW QUESTION 37
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. is-dedicated
- B. db-type
- 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 38
Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.
Which statement is FALSE regarding the auto scaling feature?
- A. The base number of OCPU cores allocated to a database is not guaranteed.
- B. Auto scaling is enabled by default and can be enabled or disabled at any time.
- C. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands.
- D. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.
Answer: C
NEW QUESTION 39
You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?
- A. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric
- B. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"
- C. Create a notification alert using DBMS_SNMP package
- D. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database
Answer: B
Explanation:
NEW QUESTION 40
Which statement is FALSE about Oracle Autonomous JSON Database?
- A. You can promote Autonomous JSON Database to Autonomous Transaction /Processing
- B. There is a 20 GB limit on JSON collection
- C. JSON data is stored natively in the database
- D. It supports NoSQL-style, document-centric application
Answer: B
Explanation:
NEW QUESTION 41
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-workload
- B. is-dedicated
- C. db-type
- D. license-model
Answer: C
Explanation:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
NEW QUESTION 42
You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?
- A. Create a database user with the default privileges.
- B. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
- C. Create an IDCS user. Create a database user with connect, resource, and object privileges.
- D. Create a database user with connect, resource, and object privileges.
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-database-actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586
NEW QUESTION 43
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. SQLDEV_ADMIN.GRANT_SCHEMA
- B. ORDS_PRIV.ENABLE_SCHEMA
- C. ORDS_ADMIN.GRANT_SCHEMA
- D. ORDS_ADMIN.ENABLE_SCHEMA
Answer: D
Explanation:
As an alternative, the ADMIN can provide Web Access for a user, REST enable a user, with SQL commands. As the ADMIN user run the following code:
BEGIN
ORDS_ADMIN.ENABLE_SCHEMA(
.
.
);
COMMIT;
END;
/
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/sql-developer-web.html#GUID-4B404CE3-C832-4089-B37A-ADE1036C7EEA
NEW QUESTION 44
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter database for user MTHEO tablespace DATA quota = 10G;
- B. Execute alter user MTHEO quota unlimited on tablespace DATA;
- C. Execute alter tablespace DATA set quota = 10G;
- D. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0
NEW QUESTION 45
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
- A. Under Database then Autonomous Transaction Processing then Autonomous Exadata
- B. Under Solutions and Platform then Platform Services then Autonomous Exadata
- C. Under Core Infrastructure then Autonomous Exadata
- D. Under Core Infrastructure then Compute then Autonomous Exadata
Answer: D
NEW QUESTION 46
Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases,
auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.
Which statement is FALSE regarding the auto scaling feature?
- A. The base number of OCPU cores allocated to a database is not guaranteed.
- B. Auto scaling is enabled by default and can be enabled or disabled at any time.
- C. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands.
- D. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.
Answer: A
NEW QUESTION 47
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?
- A. 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.
- B. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
- C. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
- D. Moving an Autonomous Database instance does not include its automatic backups.
Answer: A
NEW QUESTION 48
......
Oracle 1Z0-931-21 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
1Z0-931-21 PDF Dumps Are Helpful To produce Your Dreams Correct QA's: https://www.dumpstests.com/1Z0-931-21-latest-test-dumps.html
100% Pass Guaranteed Download Oracle Autonomous Database Exam PDF Q&A: https://drive.google.com/open?id=1YYm29eIDmccCNLRNTiTCgknqoeUPELUh