Pass Oracle 1Z0-931-21 Exam in First Attempt Guaranteed [Nov-2022]
Exam Sure Pass Oracle Certification with 1Z0-931-21 exam questions
NEW QUESTION 66
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. alter system set application_continuity=true
- B. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
- C. alter database set application_continuity=true
- D. alter session set application_continuity=true
Answer: A
NEW QUESTION 67
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 68
Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)
- A. Azure Blob Storage
- B. Amazon S3
- C. Oracle Cloud Infrastructure Object Storage Classic
- D. Oracle Cloud Infrastructure Object Storage
- E. Google Cloud Storage
Answer: C,D
Explanation:
Reference:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpud/load-data-using-oracle-data-pump.html#GUID-
025C4566-1BDB-4EF2-BFB7-0CBA8C47EA5D
Data Pump Import lets you import data from Data Pump files residing on the Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic.
You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to Autonomous Database.
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/#articletitle
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/index.html#ADBBK-GUID-37922C56-0412-45CD-B10C-2088A000113F
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data-pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF
NEW QUESTION 69
Which three options are available to access data in an Autonomous JSON Database?
- A. NOSQL statements using Oracle SODA drivers
- B. REST API calls to the database (not enabled by default)
- C. Regular Oracle SQL statements using a connection through the listener
- D. Oracle JSON Developer tool downloaded from OTN
- E. Oracle Cloud Infrastructure console using the JSON Online Developer tool
Answer: A,B,E
NEW QUESTION 70
Which statement is NOT correct when setting up compartment quotas?
- A. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
- B. Compartment quotas are set by Oracle.
- C. There are three types of quota policy statements which are set, unset and zero.
- D. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
Answer: B
Explanation:
https://docs.oracle.com/en-us/iaas/Content/General/Concepts/resourcequotas.htm
NEW QUESTION 71
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. You can configure Private Endpoints for an Always Free Autonomous Database
- D. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
Answer: B,D
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 72
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. You can't use Python with ADB.
- C. The Oracle Client and the cx_Oracle interface for Python
- D. JAVA JDK
Answer: D
NEW QUESTION 73
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
- A. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
- B. Query Latency, User Calls, Execute Count
- C. CPU Utilization, Storage Utilization
- D. Transaction Count, Sessions, Running Statements
Answer: C
NEW QUESTION 74
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?
- A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'DW'
- B. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'
- C. Allow group ADB-Admins to manage autonomous-database in tenancy.
- D. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htm
NEW QUESTION 75
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
- A. SQLDeveloper
- B. Admin page of the Cloud Service Console
- C. OS command line from the database server.
- D. OCI CLI
Answer: C
NEW QUESTION 76
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. Auto scaling is enabled by default and can be enabled or disabled at any time.
- B. 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.
- C. The base number of OCPU cores allocated to a database is not guaranteed.
- 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: B
NEW QUESTION 77
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours.
The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart.
The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance,
but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?
- A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
- B. ADW since operational reporting is a higher priority in this scenario.
- C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
- D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
Answer: D
Explanation:
Autonomous Transaction Processing provides all of the performance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications,
including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store.
As a service Autonomous Transaction Processing does not require database administration.
With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software.
Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.
NEW QUESTION 78
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 connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
- B. Create a database user with connect, resource, and object privileges.
- C. Create a database user with the default privileges.
- D. Create an IDCS user. Create a database user with connect, resource, and object privileges.
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-database-actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586
NEW QUESTION 79
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. Parquet
- B. Avro
- C. Data Pump Export File
- D. Microsoft SQL Server (.mdf)
- E. JSON
- F. Text
Answer: D
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 80
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Memory Usage
- B. Backup Retention
- C. Index Storage
- D. Undo Management
- E. Data Organization
Answer: A,C
NEW QUESTION 81
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- A. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
- B. 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.
- C. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
- D. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
- 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: B,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 82
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. Create at least 2 of each resource
- B. Create a separate VCN that contains only public subnets
- C. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
- D. Only 1 of each is allowed to be allocated per environment.
Answer: A
Explanation:
Refer to Best Practices When Planning and Instituting Access Controls section in the https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/plan-and-create-access-constraints1.html#GUID-ED48C3D3-FC0F-41D5-882A-FC2D916FD6AA
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/plan-and-create-accessconstraints1.Html
NEW QUESTION 83
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.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 84
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
- A. Clone can be in a different region.
- B. All OML notebooks are cloned.
- C. Current settings for ACLs are cloned.
- D. All resource management rules are cloned.
- E. All underlying data for OML notebooks is cloned.
Answer: B,D
NEW QUESTION 85
......
Oracle 1Z0-931-21 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
Real Oracle 1Z0-931-21 Exam Questions Study Guide: https://validdumps.free4torrent.com/1Z0-931-21-valid-dumps-torrent.html