Updated Nov-2022 Pass 1z0-931-22 Exam - Real Practice Test Questions
Download Free Oracle 1z0-931-22 Real Exam Questions
NEW QUESTION 29
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?
- A. Users can customize the OS stack and add additional packages
- B. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
- C. Users have OS access to the database machine.
- D. Users can customize the maintenance schedule.
- E. Users have SYS privileges in the database.
Answer: B,D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbat/index.html#articletitle
NEW QUESTION 30
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?
- A. Data Redaction
- B. Transparent Data Encryption
- C. Audit Vault
- D. Database Vault
- E. Customer Managed Keys
Answer: B,D,E
Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3
NEW QUESTION 31
What is the default port number for accessing a newly created Autonomous Database?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: C
Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf
NEW QUESTION 32
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
- A. Current settings for ACLs are cloned.
- B. All underlying data for OML notebooks is cloned.
- C. All resource management rules are cloned.
- D. All OML notebooks are cloned.
- E. Clone can be in a different region.
Answer: B,E
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-clone-notes.html#GUID-F943E7FF-8DEB-47F4-84C0-FFA5BAF9D5A9
NEW QUESTION 33
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
- A. Under Database then Autonomous Transaction Processing then Autonomous Exadata
- B. Under Core Infrastructure then Autonomous Exadata
- C. Under Core Infrastructure then Compute then Autonomous Exadata
- D. Under Solutions and Platform then Platform Services then Autonomous Exadata
Answer: A
Explanation:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory.
Even though the UI has changed recently, this documentation has the user go to Menu -> Database
NEW QUESTION 34
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
- A. Autonomous Data Warehouse only
- B. Autonomous Transaction Processing only
- C. Hybrid Columnar compression
- D. ATP and ADW
Answer: D
Explanation:
NEW QUESTION 35
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
- A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator
- B. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure
- C. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure
- D. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database
Answer: D
NEW QUESTION 36
Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?
- A. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.
- B. An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.
- C. When you restore a database, the existing ACLs are not overwritten by the restore.
- D. ACLs can only be used with private endpoints.
Answer: C
NEW QUESTION 37
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- B. Execute alter tablespace DATA set quota = 10G;
- C. Execute alter user MTHEO quota unlimited on tablespace DATA;
- D. Execute alter database for user MTHEO tablespace DATA quota = 10G;
Answer: A
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0
NEW QUESTION 38
Which three of the following data sources are available when using the Data Load page on Database Actions?
- A. Local Files
- B. Files in AWS S3 Storage
- C. Backup files in block storage
- D. Files in Oracle Cloud Storage
- E. REST endpoints
Answer: A,B,D
NEW QUESTION 39
When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?
- A. 1 hours
- B. 2 hours
- C. 30 minutes
- D. 24 hours
Answer: B
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 40
A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.
What should they do to remove this bottleneck?
- A. Remove any non-JSON data from the database.
- B. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.
- C. Ask Support to migrate their setup to a node without noisy neighbors.
- D. Increase the number of OCPUs allocated to the database.
Answer: C
NEW QUESTION 41
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 at least 2 of each resource
- C. Only 1 of each is allowed to be allocated per environment.
- D. Create a separate VCN that contains only public subnets
Answer: B
Explanation:
Refer to Best Practices When Planning and Instituting Access Controls section in the https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/plan-and-create-access-constraints1.html#GUID-ED48C3D3-FC0F-41D5-882A-FC2D916FD6AA
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/plan-and-create-accessconstraints1.Html
NEW QUESTION 42
Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?
- A. Month of the Quarter, Week of the Month, Day of the Week, Start Hour
- B. Week of the Quarter, Day of the Week, Start Hour
- C. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour
- D. Month of the Year, Week of the Month, Day of the Week, Start Hour
Answer: A
Explanation:
NEW QUESTION 43
Which three options are available to access data in an Autonomous JSON Database?
- A. Oracle Cloud Infrastructure console using the JSON Online Developer tool
- B. NOSQL statements using Oracle SODA drivers
- C. Regular Oracle SQL statements using a connection through the listener
- D. REST API calls to the database (not enabled by default)
- E. Oracle JSON Developer tool downloaded from OTN
Answer: A,B,D
NEW QUESTION 44
......
1z0-931-22 Dumps 100 Pass Guarantee With Latest Demo: https://dumpstorrent.prep4surereview.com/1z0-931-22-latest-braindumps.html
