Oracle Autonomous Database Certified Official Practice Test 1Z0-931-21 - Nov-2022
Ace Oracle 1Z0-931-21 Certification with Actual Questions Nov 18, 2022 Updated
NEW QUESTION 55
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: B
NEW QUESTION 56
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?
- A. Oracle Database Result Cache is enabled by default for all SQL statements.
- B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
- C. You have direct access to the database node.
- D. Parallelism is not enabled by default.
Answer: B,D
NEW QUESTION 57
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?
- A. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.
- B. Change the Automatic Maintenance Schedule to 'No Preference'.
- C. Change the Automatic Maintenance Schedule to 'None'd.
- D. You cannot permanently disable scheduled Automatic Maintenance.
Answer: A
NEW QUESTION 58
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: C
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 59
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?
- A. Moving an Autonomous Database instance does not include its automatic backups.
- B. 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.
- C. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
- D. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
Answer: B
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/databaseoverview.htm#moveRes
NEW QUESTION 60
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
- B. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
- C. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
- D. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
Answer: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/components.html#GUID-
268B36E1-87D8-4649-A370-226E2AE3FC5C
NEW QUESTION 61
Which two methods can you use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure
- A. SQL Developer
- B. SQL *Plus
- C. service console
- D. the DBMS_CLOUD_ADMIN package
Answer: A,B
NEW QUESTION 62
Which is NOT needed to manage Oracle Autonomous Database with REST APIS?
- A. Tenancy's OCID
- B. Fingerprint of the public key
- C. User's OCID
- D. Database ADMIN password
Answer: D
NEW QUESTION 63
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)
- A. DBNAME_CONCURRENT
- B. DBNAME_LOW
- C. DBNAME_MEDIUM
- D. DBNAME_HIGH
Answer: B
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 64
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 65
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. license-model
- C. is-dedicated
- D. db-workload
Answer: C
NEW QUESTION 66
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 notification alert using DBMS_SNMP package
- C. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"
- D. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database
Answer: C
Explanation:
NEW QUESTION 67
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
- A. Navigate to Identity, select Users panel on the console and select "Add Public Key".
- B. On the Autonomous Database Console.
- C. SSH keys are not required in Oracle Cloud Infrastructure.
- D. SSH keys cannot be added from console. They have to be added using REST APIs only.
Answer: A
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 68
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. Business Models
- B. Data Load
- C. SQL Developer Web
- D. APEX
Answer: B
Explanation:
NEW QUESTION 69
Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?
- A. Oracle Cloud Infrastructure Object Storage
- B. Oracle Cloud Infrastructure Object Storage Classic
- C. Amazon S3
- D. Google Cloud Storage
Answer: D
Explanation:
NEW QUESTION 70
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
- A. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database
- B. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure
- C. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure
- D. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator
Answer: A
NEW QUESTION 71
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. Shutdown and restart the instance.
- C. Rotate the instance wallet and share the new wallet with the remaining users.
- D. Trust the user who left to not access the database.
Answer: B
NEW QUESTION 72
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Backup Retention
- B. Memory Usage
- C. Undo Management
- D. Index Storage
- E. Data Organization
Answer: B,D
NEW QUESTION 73
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. Avro
- B. Data Pump Export File
- C. Parquet
- D. Microsoft SQL Server (.mdf)
- E. Text
- F. JSON
Answer: A
NEW QUESTION 74
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
- A. through SQL/Developer s
- B. using DBMS_CLOUD_ADMIN package
- C. through SQLPIus
- D. through the Oracle Cloud Infrastructure service console
Answer: A,C
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 75
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. ATP and ADW
- B. Autonomous Transaction Processing only
- C. Hybrid Columnar compression
- D. Autonomous Data Warehouse only
Answer: D
NEW QUESTION 76
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
- A. Admin page of the Cloud Service Console
- B. OS command line from the database server.
- C. OCI CLI
- D. SQLDeveloper
Answer: B
NEW QUESTION 77
Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is stopped.
Which statement is true?
- A. Failover is automatically initiated.
- B. Switchover is automatically initiated.
- C. The standby database is also stopped.
- D. The standby database is terminated.
Answer: C
NEW QUESTION 78
......
Try Free and Start Using Realistic Verified 1Z0-931-21 Dumps Instantly.: https://prep4sure.examtorrent.com/1Z0-931-21-exam-papers.html
