[Sep-2021] Verified Oracle Exam Dumps with 1Z0-931-20 Exam Study Guide
Best Quality Oracle 1Z0-931-20 Exam Questions Actual4Labs Realistic Practice Exams [2021]
NEW QUESTION 61
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 62
Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?
- A. HIGH
- B. TPPERFORMANT
- C. MEDIUM
- D. TPURGENT
- E. LOW
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-
44F1-8FF8-F5AC650F15BE
NEW QUESTION 63
When exporting a notebook, what type of file is created?
- A. TXT
- B. JSON
- C. XML
- D. ASCII
- E. SQL
Answer: B
Explanation:
Export a Notebook
You can export a notebook as a .json (JavaScript Object Notation) file, and later import it in to the same or a different environment.
To export a notebook:
- In the Notebooks page, click the notebook that you want to export. The notebook opens in the notebook editor.
- In the top panel of the notebook editor, click export. The notebook is saved to your local folder as a .json file.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/get-started-notebooks-data-analysis-and-data-visualization.html#GUID-009B9073-4B45-4505-8DAD-F1F04FD3E160
NEW QUESTION 64
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 underlying data for OML notebooks is cloned.
- C. Current settings for ACLs are cloned.
- D. All OML notebooks are cloned.
- E. All resource management rules are cloned.
Answer: D,E
NEW QUESTION 65
Which two methods can you use to create users and grant roles in Autonomous Database services?
(Choose two.)
- A. using DBMS_CLOUD_ADMIN package
- B. through the Oracle Cloud Infrastructure service console
- C. through SQLPIus
- D. through SQL/Developer s
Answer: C,D
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
NEW QUESTION 66
Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low.
Which statement about these consumer groups is correct?
- A. Low provides highest concurrency, lowest resources, and DoP =1.
- B. High provides highest concurrency and lowest resources, and DoP is 1.
- C. Medium provides intermediate resource and concurrency, and queries run in a serial.
- D. High provides highest resources, lowest concurrency, and DoP is 1.
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7
NEW QUESTION 67
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. Subnet
- C. Security List
- D. Route Table
- E. VCN
Answer: A,B,E
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 68
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. The base number of OCPU cores allocated to a database is not guaranteed.
- C. Auto scaling is enabled by default and can be enabled or disabled at any time.
- 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 69
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
- A. Neither service ignores hints by default.
- B. Both services ignore hints by default.
- C. Autonomous Data Warehouse.
- D. Autonomous Transaction Processing.
Answer: C
Explanation:
http://blog.umairmansoob.com/tag/oracle-autonomous-data-warehouse/
NEW QUESTION 70
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?
- A. Active Data Guard
- B. RAC, but only when scaling beyond 16 OCPUs
- C. Transparent Data Encryption
- D. Multitenant
- E. Exadata
Answer: A,B
NEW QUESTION 71
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?
- A. Create a database link from source database to the ADB environment and clone the PDB.
- B. Unplug into a pdb archive which can be uploaded to object storage.
- C. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
- D. Unplug to an xml file so database files and xml file can be uploaded to object storage.
Answer: C
Explanation:
Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.
NEW QUESTION 72
Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?
- A. 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.
- 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. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
Answer: B
NEW QUESTION 73
Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?
- A. In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.
- B. Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.
- C. Adding, removing, or modifying tablespaces is allowed.
- D. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to.
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/experienced-database-users.html#GUID-58EE6599-6DB4-4F8E-816D-0422377857E5
NEW QUESTION 74
When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?
- A. Increasing OCPUs will automatically increase storage.
- B. Storage in TB cannot be larger than the number of OCPUs.
- C. OCPUs and storage must remain in sync.
- D. OCPUs and storage can be scaled independently.
Answer: D
Explanation:
You simply specify the number of OCPUs and the storage capacity in TB's for the database. At any time, you may scale, increase or decrease either the OCPUs or the storage capacity.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-add-resources.html#GUID-DA72422A-5A70-42FA-A363-AB269600D4B0
NEW QUESTION 75
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection?
- A. DBNAME_MEDIUM
- B. DBNAME_HIGH
- C. DBNAME_LOW
- D. DBNAME_CONCURRENT
Answer: C
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 76
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
- A. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
- B. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
- C. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
- D. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
- E. The target table will be created in Autonomous Database if it does not already exist.
Answer: B,C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/file-uri-formats.html#GUID-5D3E1614-ADF2-4DB5-B2B2-D5613F10E4FA
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID-9428EA51-5DDD-43C2-B1F5-CD348C156122
NEW QUESTION 77
You must implement a backup solution for your Autonomous Data Warehouse (ADW) that will enable you to restore data as old as one year with a recovery point objective (RPO) of 10 days. Which database backup strategy would you select?
- A. Take quarterly manual backups to supplement the automated backups and preserve them for 12 months.
- B. Use the automated backups.
- C. Take weekly manual backups to supplement the automated backups and preserve them for 12 months.
- D. Take monthly manual backups to supplement the automated backups and preserve them for 12 months.
Answer: C
NEW QUESTION 78
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 only supports Autonomous Databases.
- B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
- 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: A
NEW QUESTION 79
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?
- A. None. There are no pre-defined service names in tnsnames.ora.
- B. Two. They are called ATP and ADW.
- C. Three. They are called high, medium and low.
- D. Five. They are called tpurgent, tp, high, medium and low.
Answer: D
Explanation:
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://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATP
NEW QUESTION 80
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: B
NEW QUESTION 81
What is the default retention period for both Automatic and Manual Autonomous Database Backups?
- A. One Year
- B. 60 days
- C. 7 days
- D. 90 days
- E. 30 days
Answer: B
NEW QUESTION 82
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?
- A. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
- B. the Listener endpoint where the Autonomous Database should register on
- C. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
- D. the 'High Availability Container Database' in which the Autonomous instance should run
- E. the Client Credentials wallet which is used to connect to the Autonomous Database
Answer: E
NEW QUESTION 83
......
Authentic Best resources for 1Z0-931-20: https://www.actual4labs.com/Oracle/1Z0-931-20-actual-exam-dumps.html