Get 1z0-931-23 Products Practice Material for 1z0-931-23 Exam Question Preparation [Q40-Q55]

Rate this post

Get 1z0-931-23 Products Practice Material for 1z0-931-23 Exam Question Preparation

Most Reliable Oracle 1z0-931-23 Training Materials

Oracle 1z0-931-23 Exam Syllabus Topics:

Topic	Details
Topic 1	Use ADB connectivity: Wallets, service handles Manage Autonomous Database instances: REST APIs, OCI CLI, moving resources
Topic 2	Monitor ADB performance and set up service notifications Describe ADB Dedicated and ADB Cloud@Customer resources, workflows, and functionality
Topic 3	Managing and Maintaining Autonomous Database Create Autonomous Database Shared Instances – provisioning, scaling OCPU and storage
Topic 4	Describe Autonomous Database Tools Describe the options and considerations for migrating to Autonomous Database
Topic 5	Monitor Autonomous Database Shared instances – events and alarms Describe Autonomous Database architecture, integrations, and license types

Q40. To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?

Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB

Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure

Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB

Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB

https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbddoverview.htm

Q41. 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?

Change the Automatic Maintenance Schedule to “No Preference”

You cannot permanently disable scheduled automatic maintenance

Change the Automatic Maintenance Schedule to “None”

Change the Automatic Maintenance Schedule to “Specify a Schedule,” but do not select any ^ month, week, or day

Q42. When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

Data

Schemas

Tablespaces

Reports

When using Data Pump to migrate your Oracle database to Autonomous Database, you can import data and schemas from Data Pump files. You cannot import tablespaces or reports. See Export Your Existing Oracle Database to Import into Autonomous Database for more details.

Q43. Which three of the following data sources are available when using the Data Load page on Database Actions?

Files in Oracle Cloud Storage

Backup files in block storage

Local Files

Files in AWS S3 Storage

REST endpoints

Q44. Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

through the Oracle Cloud Infrastructure service console

through SQL/Developer s

using DBMS_CLOUD_ADMIN package

through SQLPIus

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

Q45. How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

It cannot be done.

Using Database Configuration Assistant (DBCA) on the database server.

Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Connecting to the Cloud Infrastructure Command console via SSH wallet.

The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands.
https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using-oci-curl Examples of using Autonomous Database managing by REST API
https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/LabGuide900ConfigureOCI-CLI.md

Q46. Which statement is true when you provision an Autonomous Database using the cloning method?

After an Autonomous database is created using a clone, the network access option can be changed.

A clone database source can be a running database instance.

A clone database source can be from a point-in-time backup that is less than 2 hours old.

When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.

Q47. Which statement is FALSE about Data Insights?

Data Insights displays information about patterns and anomalies in the data of entities in your Oracle Autonomous Database

The results of the insight analysis appear as a series of bar charts in the Data Insights dashboard

Data insights are automatically generated by various analytic functions built into the database

Data Insights provides a wide range of graphical data presentation capabilities

Q48. What is the maximum number of days that an Autonomous Database Refreshable Clone can be trailing its source instance?

15 days

1 day

7 days

30 days

Q49. Your company has a .NET application and wants to deploy it on Autonomous Database (ADB). What software is used to connect to ADB from the .NET application?

SQL*Plus

Java

You cannot use .NET with ADB.

Oracle Data Access Components for Windows

Oracle Data Access Components (ODAC) for Windows is a collection of software components that provide data access to Oracle databases from .NET applications. ODAC includes Oracle Data Provider for .NET (ODP.NET), which is the driver that connects to Autonomous Database from .NET applications2. ODP.NET supports both .NET Framework and .NET Core applications3. ODP.NET can be used with Visual Studio and Visual Studio Code to develop and deploy .NET applications for Autonomous Database45. Reference:
Connect Microsoft .NET, Visual Studio Code, and Visual Studio with a Wallet (mTLS) – Oracle Help Center, section “Oracle Data Provider for .NET (ODP.NET)”.
Connect Microsoft .NET, Visual Studio Code, and Visual Studio Without a Wallet – Oracle Help Center, section “Oracle Data Provider for .NET (ODP.NET)”.
Oracle Data Access Components Downloads – Oracle.
NuGet Gallery | Packages matching Tags:”odp.net”.

Q50. When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)

DBNAME_MEDIUM

DBNAME_HIGH

DBNAME_CONCURRENT

DBNAME_LOW

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

Q51. How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?

Execute alter database for user MTHEO tablespace DATA quota = 10G;

Execute alter user MTHEO quota unlimited on tablespace DATA;

Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => ‘MTHEO’ , tablespace__quota => “UNLIMITED*);

Execute alter tablespace DATA set quota = 10G;

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0

Q52. Which two methods can you use to define Oracle Machine Learning users?

SQL Developer

the DBMS_CLOUD_ADMIN package

Oracle Cloud Infrastructure Console

Service Console

Q53. Which option describes the connection type that third-party software can use to connect to an Autonomous Database (ADB)?