
Updated Free Oracle 1Z0-931-21 Test Engine Questions with 114 Q&As
The Best Oracle Autonomous Database 1Z0-931-21 Professional 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 49
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 an IDCS user. Create a database user with connect, resource, and object privileges.
- C. 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.
- D. Create a database user with connect, resource, and object privileges.
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-database-actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586
NEW QUESTION 50
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: B
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION 51
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?
- A. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure
- B. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB
- C. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB
- D. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB
Answer: B
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbddoverview.htm
NEW QUESTION 52
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 a separate VCN that contains only public subnets
- C. Create at least 2 of each resource
- D. Only 1 of each is allowed to be allocated per environment.
Answer: A
NEW QUESTION 53
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. JAVA JDK
- C. The Oracle Client and the cx_Oracle interface for Python
- D. You can't use Python with ADB.
Answer: C
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 54
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
- A. Query Latency, User Calls, Execute Count
- B. Transaction Count, Sessions, Running Statements
- C. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag
- D. CPU Utilization, Storage Utilization
Answer: D
NEW QUESTION 55
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: C
NEW QUESTION 56
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 user MTHEO quota unlimited on tablespace DATA;
- C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- D. Execute alter database for user MTHEO tablespace DATA quota = 10G;
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0
NEW QUESTION 57
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. 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.
- 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 available to a database depends on the total number of cores available in the Exadata infrastructure instance.
- D. The base number of OCPU cores allocated to a database is not guaranteed.
Answer: A
NEW QUESTION 58
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?
- A. Users have OS access to the database machine.
- B. Users can customize the maintenance schedule.
- C. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
- D. Users can customize the OS stack and add additional packages
- E. Users have SYS privileges in the database.
Answer: C,E
NEW QUESTION 59
Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?
- A. The OCI compute instance can be used with an Always-Free Autonomous Database account.
- B. A Private Endpoint is required to connect to the Shared-Autonomous Database.
- C. The Autonomous Database must belong to a Network Security Group (NSG).
- D. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.
- E. The OCI compute instance does not support connecting to a Shared Autonomous Database.
Answer: A
NEW QUESTION 60
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.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
- C. 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.
- D. 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.
- E. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
Answer: C,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 61
An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.
Other than changing the shared user password, what can the admin do to protect the instance?
- A. Delete the user.
- B. Rotate the instance wallet and share the new wallet with the remaining users.
- C. Trust the user who left to not access the database.
- D. Shutdown and restart the instance.
Answer: D
NEW QUESTION 62
What happened with the standby database when disabling Autonomous Data Guard?
- A. The standby database is started read only
- B. The standby database is transformed in a refreshable clone
- C. The standby database is terminated
- D. The standby database is started readwrite
Answer: C
NEW QUESTION 63
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?
- A. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure
- B. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB
- C. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB
- D. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB
Answer: B
NEW QUESTION 64
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- A. alter system set application_continuity=true
- B. alter session set application_continuity=true
- C. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
- D. alter database set application_continuity=true
Answer: A
NEW QUESTION 65
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?
- A. TPPERFORMANT
- B. MEDIUM
- C. TPURGENT
- D. HIGH
- E. LOW
Answer: A
Explanation:
Predefined Database Service Names for Autonomous Transaction Processing The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
* tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
* tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
* high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
* medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
* low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
NEW QUESTION 66
Which two statements are true about accessing Autonomous Database Tools?
- A. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
- B. Oracle APEX can be accessed only from the Developer menu in the Service Console.
- C. SQL Developer Web is available exclusively on the Autonomous Database.
- D. Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpoint networking.
- E. Access to Database Actions is available for all users of Autonomous Database.
Answer: B,D
NEW QUESTION 67
Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?
- A. A Private Endpoint is required to connect to the Shared-Autonomous Database.
- B. The OCI compute instance can be used with an Always-Free Autonomous Database account.
- C. The Autonomous Database must belong to a Network Security Group (NSG).
- D. The OCI compute instance does not support connecting to a Shared Autonomous Database.
- E. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.
Answer: E
NEW QUESTION 68
Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?
- A. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.
- B. The marketplace OCI image can be used with an Always Free Autonomous Database account.
- C. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.
- D. The Autonomous Database must belong to a Network Security Group (NSG).
- E. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.
Answer: C
NEW QUESTION 69
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 database set application_continuity=true
- D. alter system 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 70
......
Try 100% Updated 1Z0-931-21 Exam Questions [2022]: https://www.braindumpspass.com/Oracle/1Z0-931-21-practice-exam-dumps.html