Download Free Oracle 1Z0-931-21 Real Exam Questions Download
Latest Oracle 1Z0-931-21 Real Exam Dumps PDF
Oracle 1Z0-931-21 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
NEW QUESTION 14
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints
- A. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
- B. You can configure Private Endpoints for an Always Free Autonomous Database
- C. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.
- D. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints
Answer: A,C
NEW QUESTION 15
When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?
- A. 2 hours
- B. 1 hours
- C. 24 hours
- D. 30 minutes
Answer: A
Explanation:
Clone Sources
You can use a running database to create a clone. For databases running on shared Exadata infrastructure, you can also use a backup as the source of your clone. When using a backup, you can select a listed backup to clone from, or create a point-in-time clone. Point-in-time clones contain all data up to a specified timestamp. The specified timestamp must be in the past.
Note When you create a clone from a backup, you must select a backup that is at least two hours old.
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbcloning.htm
NEW QUESTION 16
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 17
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Data Organization
- B. Undo Management
- C. Backup Retention
- D. Index Storage
- E. Memory Usage
Answer: D,E
NEW QUESTION 18
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. alter session set application_continuity=true
- B. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
- C. alter system set application_continuity=true
- D. alter database set application_continuity=true
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-42B9DDB0-12A7-4EE3-9860-30EFA41061E9 If it was asking for Autonomous Database Dedicated Infrastructure, then answer would be execute DBMS_APP_CONT_ADMIN.ENABLE_AC( 'databaseid_tpurgent.adb.oraclecloud.com', 'LEVEL1', 600);
NEW QUESTION 19
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. ATP and ADW
- B. Autonomous Data Warehouse only
- C. Autonomous Transaction Processing only
- D. Hybrid Columnar compression
Answer: B
NEW QUESTION 20
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
- A. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
- B. It is enabled by default.
- C. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
- D. The indexing feature is implemented as an automatic task that runs at a fixed interval.
- E. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-index.html#GUID-D51A4F85-3AE5-4B7D-9B27-32CEDE8DBD79 - Auto Indexing is disabled by default in Autonomous Database
NEW QUESTION 21
Which statement is true when connecting OCI Marketplace image to shared autonomous database?
- A. Compute Image and Shared ADB must be in same VCN and Subnet
- B. ADB must be configured with NSG
- C. Cannot connect OCI Market image to shared ADB
- D. ADB must be configured with Private endpoints
Answer: A
NEW QUESTION 22
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. Autonomous Data Warehouse only
- B. Autonomous Transaction Processing only
- C. ATP and ADW
- D. Hybrid Columnar compression
Answer: C
Explanation:
NEW QUESTION 23
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. license-model
- B. db-type
- C. db-workload
- D. is-dedicated
Answer: B
Explanation:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
NEW QUESTION 24
You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs.
What is the total number of concurrent statements that the TPURGENT service can support?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-priorities.html#GUID-6E4DCD27-CDAA-432D-A90B-485C19EF72B0 It's 300x the number of OCPUs for TPURGEN
NEW QUESTION 25
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)
- A. DBNAME_LOW
- B. DBNAME_HIGH
- C. DBNAME_MEDIUM
- D. DBNAME_CONCURRENT
Answer: A
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 26
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?
- A. Database Vault
- B. Audit Vault
- C. Transparent Data Encryption
- D. Customer Managed Keys
- E. Data Redaction
Answer: A,C,D
Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3
NEW QUESTION 27
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter tablespace DATA set quota = 10G;
- B. Execute alter database for user MTHEO tablespace DATA quota = 10G;
- C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- D. Execute alter user MTHEO quota unlimited on tablespace DATA;
Answer: A
NEW QUESTION 28
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?
- A. Parallelism
- B. Memory
- C. Concurency
- D. Storage
- E. Sessions
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:
NEW QUESTION 29
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)
- A. Use Data Pump
- B. Use GoldenGate
- C. Use SFTP to copy CSV files into Autonomous Database
- D. Use Oracle Zero Downtime Migration (ZDM)
- E. Use Recovery Manager (RMAN)
Answer: A,B,D
Explanation:
https://www.oracle.com/sa/database/technologies/cloud-migration.html
NEW QUESTION 30
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
- A. It is enabled by default.
- B. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
- C. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
- D. The indexing feature is implemented as an automatic task that runs at a fixed interval.
- E. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
Answer: D
NEW QUESTION 31
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?
- A. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB
- B. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB
- C. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure
- D. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbddoverview.htm
NEW QUESTION 32
You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs.
What is the total number of concurrent statements that the TPURGENT service can support?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 33
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
- A. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
- B. 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.
- C. 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.
- D. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
- E. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
Answer: B,C,D
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 34
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?
- A. Network Security Group
- B. Route Table
- C. Subnet
- D. VCN
- E. Security List
Answer: A,C,D
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 35
Which statement is true when you provision an Autonomous Database using the cloning method?
- A. A clone database source can be a running database instance.
- B. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
- C. A clone database source can be from a point-in-time backup that is less than 2 hours old.
- D. After an Autonomous database is created using a clone, the network access option can be changed.
Answer: A
Explanation:
NEW QUESTION 36
......
PDF (New 2022) Actual Oracle 1Z0-931-21 Exam Questions: https://www.dumpstests.com/1Z0-931-21-latest-test-dumps.html
1Z0-931-21 Exam Dumps, 1Z0-931-21 Practice Test Questions: https://drive.google.com/open?id=1YYm29eIDmccCNLRNTiTCgknqoeUPELUh