[2023] New 1z0-931-23 exam Free Sample Questions to Practice
Cover Real 1z0-931-23 Exam Questions Make Sure You 100% Pass
NEW QUESTION # 82
Which two methods can you use to define Oracle Machine Learning users?
- A. Oracle Cloud Infrastructure Console
- B. Service Console
- C. SQL Developer
- D. the DBMS_CLOUD_ADMIN package
Answer: A
NEW QUESTION # 83
Which two methods can you use to create database users and grant roles in Autonomous Database services?
- A. SQL *Plus
- B. SQL Developer
- C. the DBMS_CLOUD_ADMIN package
- D. the Oracle Cloud Infrastructure A. service console
Answer: A,B
NEW QUESTION # 84
Your customer wants to permanently disable scheduled maintenance on the Autonomous Database on Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?
- A. Change the Automatic Maintenance Schedule to "None"
- B. You cannot permanently disable scheduled automatic maintenance
- C. Change the Automatic Maintenance Schedule to "No Preference"
- D. Change the Automatic Maintenance Schedule to "Specify a Schedule," but do not select any ^ month, week, or day
Answer: B
NEW QUESTION # 85
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
- B. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
- C. Virtual Cloud Network, Compartments, Policies, 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 # 86
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. Clone can be in a different region.
- D. All OML notebooks are cloned.
- E. All resource management rules are cloned.
Answer: B,C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-clone-notes.html#GUID-F943E7FF-8DEB-47F4-84C0-FFA5BAF9D5A9
NEW QUESTION # 87
Which two statements are true about using an Oracle Autonomous Database with private endpoints?
- A. An Autonomous Database with private endpoints can be accessed from the public Internet by adding your IP address to an Access Control List (ACL)
- B. You can configure private endpoints for an Always Free Autonomous Database
- C. A Network Security Group (NSG) is required within your virtual cloud network before you can provision a Shared Autonomous Database to use private endpoints
- D. Private endpoints can be configured when you clone an Autonomous Database on Shared Infrastructure that was initially created with public endpoints
Answer: C,D
NEW QUESTION # 88
When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?
- A. 1 hours
- B. 24 hours
- C. 30 minutes
- D. 2 hours
Answer: D
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 # 89
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
- A. SQLDeveloper
- B. OS command line from the database server.
- C. Admin page of the Cloud Service Console
- D. OCI CLI
Answer: B
NEW QUESTION # 90
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 an IDCS user. Create a database user with connect, resource, and object privileges.
- B. 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 the default privileges.
Answer: C
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-database-actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586 To enable a user to access SQL Developer Web, you need to create a database user with the appropriate privileges, enable the schema for SQL Developer Web, and provide the user with the modified URL that includes the schema name. See Enabling Users to Access SQL Developer Web for more details.
NEW QUESTION # 91
Which option describes the connection type that third-party software can use to connect to an Autonomous Database (ADB)?
- A. JDBC only
- B. any protocol supported by Oracle Net Services
- C. new ADB-specific protocols
- D. SQL*Net only
Answer: B
NEW QUESTION # 92
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. The standby database is terminated.
- B. The standby database is also stopped.
- C. Failover is automatically initiated.
- D. Switchover is automatically initiated.
Answer: B
NEW QUESTION # 93
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)
- A. Use Data Pump
- B. Use GoldenGate
- C. Use Oracle Zero Downtime Migration (ZDM)
- D. Use Recovery Manager (RMAN)
- E. Use SFTP to copy CSV files into Autonomous Database
Answer: A,B,C
Explanation:
https://www.oracle.com/sa/database/technologies/cloud-migration.html
NEW QUESTION # 94
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: D
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/manage-priorities.html#GUID-6E4DCD27-CDAA-432D-A90B-485C19EF72B0 It's 300x the number of OCPUs for TPURGEN
NEW QUESTION # 95
Which three methods can be used to migrate on-premises databases to Oracle Autonomous Database (both Shared and Dedicated)?
- A. Oracle Data Pump
- B. Orace Zero Downtime Migration (ZDM)
- C. RMAN backup & restore
- D. Original imp/exp tools
- E. Physical migration methods, such as database cloning
- F. Oracle Golden Gate
Answer: A,B,F
NEW QUESTION # 96
While creating a business model what advanced options you can enable or disable? (Choose three)
- A. Display private tables
- B. Business Object Security Feature
- C. Analytic View Base Table Query Transformation
- D. Autonomous Aggregate Cache
- E. Analytic View Transparency View
Answer: C,D,E
Explanation:
NEW QUESTION # 97
Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database.
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
Explanation:
Backup Retention
If you choose to enable automatic backups, you can choose one of the following preset retention periods: 7 days, 15 days, 30 days, 45 days, or 60 days. The system automatically deletes your incremental backups at the end of your chosen retention period.
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/backingupOS.htm
NEW QUESTION # 98
Which three are Oracle-recommended best practices for Autonomous Database alarms?
- A. Create multiple alarm metrics.
- B. Select the correct alarm interval for your metric.
- C. Use a single interval for all alarms.
- D. Suppress alarms during investigations.
- E. Create a single alarm for each metric.
- F. Routinely tune your alarms.
Answer: B,D,F
NEW QUESTION # 99
Which statement is not correct when the Autonomous Database is stopped?
- A. CPU billing is halted
- B. User with DWROLE can still access the database
- C. In-flight transactions queries are stopped
- D. Tools are no longer able to connect to a stopped instance
Answer: B
NEW QUESTION # 100
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. Only 1 of each is allowed to be allocated per environment.
- C. Create a separate VCN that contains only public subnets
- D. Create at least 2 of each resource
Answer: D
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 # 101
When an administrator rotates the instance wallet for an Autonomous Database on Shared Infrastructure, what happens to the regional wallets used with that instance?
- A. They continue to work
- B. They become invalid
- C. They revert to pending
- D. They are also rotated
Answer: A
NEW QUESTION # 102
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)
- A. DBNAME_HIGH
- B. DBNAME_MEDIUM
- 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 # 103
......
Real 1z0-931-23 Quesions Pass Certification Exams Easily: https://examtorrent.actual4test.com/1z0-931-23_examcollection.html