Free Oracle Autonomous Database 1Z0-931-21 Ultimate Study Guide (Updated 114 Questions)
Get to the Top with 1Z0-931-21 Practice Exam Questions
NEW QUESTION 56
Which two options are available to restore an Oracle Autonomous Database?
- A. Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.
- B. Select the snapshot of the backup.
- C. Select the backup from which restore needs to be done.
- D. Specify the point in time (timestamp) to restore.
- E. Specify the archived custom image.
Answer: C,D
NEW QUESTION 57
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 an IDCS user. Create a database user with connect, resource, and object privileges.
- D. Create a database user with the default privileges.
Answer: A
NEW QUESTION 58
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
- A. Microsoft SQL Server (.mdf)
- B. Data Pump Export File
- C. Parquet
- D. Avro
- E. JSON
- F. Text
Answer: A
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 59
Which two actions are available to perform when an Autonomous Database is stopped?
- A. Start
- B. Update License Type
- C. Change administrator password
- D. Update Network Access
Answer: A,B
NEW QUESTION 60
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. Trust the user who left to not access the database.
- B. Delete the user.
- C. Rotate the instance wallet and share the new wallet with the remaining users.
- D. Shutdown and restart the instance.
Answer: C
Explanation:
NEW QUESTION 61
Which three of the following data sources are available when using the Data Load page on Database Actions?
- A. Local Files
- B. REST endpoints
- C. Files in Oracle Cloud Storage
- D. Files in AWS S3 Storage
- E. Backup files in block storage
Answer: A,C,D
NEW QUESTION 62
Which statement is true when you provision an Autonomous Database using the cloning method?
- A. A clone database source can be from a point-in-time backup that is less than 2 hours old.
- B. A clone database source can be a running database instance.
- C. After an Autonomous database is created using a clone, the network access option can be changed.
- D. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
Answer: D
NEW QUESTION 63
Which statement is true when connecting OCI Marketplace image to shared autonomous database?
- A. ADB must be configured with NSG
- B. Cannot connect OCI Market image to shared ADB
- C. Compute Image and Shared ADB must be in same VCN and Subnet
- D. ADB must be configured with Private endpoints
Answer: C
NEW QUESTION 64
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. is-dedicated
- B. db-workload
- C. license-model
- D. db-type
Answer: D
Explanation:
https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html
NEW QUESTION 65
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 available to a database depends on the total number of cores available in the Exadata infrastructure instance.
- B. The base number of OCPU cores allocated to a database is not guaranteed.
- C. 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.
- D. Auto scaling is enabled by default and can be enabled or disabled at any time.
Answer: B
NEW QUESTION 66
Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?
- A. Amazon S3
- B. Google Cloud Storage
- C. Oracle Cloud Infrastructure Object Storage Classic
- D. Oracle Cloud Infrastructure Object Storage
Answer: B
Explanation:
NEW QUESTION 67
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.
- C. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'
- 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 68
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
- A. On the Autonomous Database Console.
- B. SSH keys cannot be added from console. They have to be added using REST APIs only.
- C. Navigate to Identity, select Users panel on the console and select "Add Public Key".
- D. SSH keys are not required in Oracle Cloud Infrastructure.
Answer: C
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 69
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 70
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_MEDIUM
- C. DBNAME_CONCURRENT
- D. DBNAME_HIGH
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 71
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
- A. through SQLPIus
- B. using DBMS_CLOUD_ADMIN package
- C. through the Oracle Cloud Infrastructure service console
- D. through SQL/Developer s
Answer: A,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
"To create users in your database, connect to the database as the ADMIN user using any SQL client tool." https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-create.html#GUID-54CA837B-CD6A-4ED2-A960-5874535818CB
NEW QUESTION 72
......
Pass Oracle 1Z0-931-21 exam - questions - convert Tets Engine to PDF: https://www.prepawaytest.com/Oracle/1Z0-931-21-practice-exam-dumps.html