1Z0-931-20 Exam Questions
125 real 1Z0-931-20 exam questions with expert-verified answers and explanations. Page 1 of 3.
- Question #1Autonomous Database Concepts
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
dedicated ExadataAutonomous Container DatabaseADB componentsExadata infrastructure - Question #2Developing with Autonomous Database
For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?
ORDS_ADMINSQL Developer Webschema enableORDS - Question #3Autonomous Database Concepts
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
dedicated infrastructureworkload typesAutonomous Data WarehouseAutonomous Transaction Processing - Question #4Loading and Transforming Data
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
DBMS_CLOUDfile formatsAvroShared Exadata Infrastructure - Question #5Provisioning and Connecting to Autonomous Database
What is the default port number for accessing a newly created Autonomous Database?
port numberTLS connection1522network access - Question #6Provisioning and Connecting to Autonomous Database
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?
dedicated infrastructureFleet Administratorprovisioning orderAutonomous Container DB - Question #7Loading and Transforming Data
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
DBMS_CLOUD.COPY_DATAObject Storagecredentialsdata loading - Question #8Provisioning and Connecting to Autonomous Database
According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and...
access controlssubnetscompartmentsuser groups - Question #9Provisioning and Connecting to Autonomous Database
You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism. Which service wi...
connection servicesTPURGENTconcurrencyparallelism - Question #10Autonomous Database Concepts
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?
Fleet Administratordedicated infrastructurerolesAutonomous Exadata Infrastructure - Question #11Managing and Monitoring Autonomous Database
does this mean?
SQL monitoringquery statusqueued statementsperformance hub - Question #12Developing with Autonomous Database
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...
SQL Developer Webuser privilegesschema enablementdatabase user creation - Question #13Managing and Monitoring Autonomous Database
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, impleme...
Oracle Data Safesecurity controlssensitive datacompliance - Question #14Loading and Transforming Data
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
DBMS_CLOUDexternal tablesObject Storagecredentials - Question #15
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- Question #16
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
- Question #17Managing and Monitoring Autonomous Database
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?
rolling restartmaintenanceshared ExadataRelease Update - Question #18Provisioning and Connecting to Autonomous Database
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created o...
dedicated infrastructureprovisioningDatabase AdministratorAutonomous Container DB - Question #19Provisioning and Connecting to Autonomous Database
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to
SSH keyOCI ConsoleIdentityuser management - Question #20Migrating to Autonomous Database
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production. How should the...
PDB migrationplug-unplugon-premise migrationpluggable database - Question #21
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s). How can they achieve this?
- Question #22Developing with Autonomous Database
A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data. How does the developer connect to and interact with ADB from Python?
Pythoncx_OracleOracle Clientdeveloper connectivity - Question #23Managing and Monitoring Autonomous Database
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
backup and recoverypoint-in-time recoveryrestore optionsADW - Question #24Developing with Autonomous Database
You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a What statement describes the step to provide the developer a new workspace in APEX?
APEXworkspace provisioningAPEX Administration Servicesdeveloper access - Question #25Loading and Transforming Data
What are three methods to load data into the Autonomous Database?
GoldenGateData PumpSQL*Loaderdata loading methods - Question #26Provisioning and Connecting to Autonomous Database
Which statement is true when you provision an Autonomous Database using the cloning method?
ADB cloningclone sourceOML workspacesprovisioning methods - Question #27Provisioning and Connecting to Autonomous Database
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
OCI CLIREST APIprovisioning methodscloud console - Question #28Provisioning and Connecting to Autonomous Database
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints
private endpointsVCNnetwork accessshared infrastructure - Question #29Provisioning and Connecting to Autonomous Database
What REST verb is used to create an Autonomous Database service using REST APIs?
REST APIHTTP POSTOCI APIdatabase provisioning - Question #30Managing and Monitoring Autonomous Database
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?
ADB DedicatedOCPU utilizationResource Managerfleet administrator - Question #31Managing and Monitoring Autonomous Database
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 share...
instance walletwallet rotationdatabase securitycredential management - Question #32Loading and Transforming Data
What is the correct way to list all files in the default data pump directory?
DBMS_CLOUDLIST_FILESDATA_PUMP_DIRData Pump - Question #33Managing and Monitoring Autonomous Database
Which statement is correct about managing and monitoring of Autonomous Database?
Service Consolecompartmentsauto scalingdatabase management - Question #34Autonomous Database Concepts
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?
ADB DedicatedExadata infrastructureSYS privilegesisolation - Question #35Managing and Monitoring Autonomous Database
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
Admin passwordOCI CLIpassword managementshared infrastructure - Question #36Provisioning and Connecting to Autonomous Database
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
metadata-only cloneprivate endpointOML notebooksACL settings - Question #37Managing and Monitoring Autonomous Database
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 incr...
auto scalingTPURGENT serviceconcurrent statementsOCPU scaling - Question #38Managing and Monitoring Autonomous Database
Which statement is NOT correct when setting up compartment quotas?
compartment quotasquota policiesresource allocationOCI governance - Question #39Autonomous Database Concepts
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?
Transparent Data EncryptionDatabase VaultCustomer Managed Keyssecurity features - Question #40Managing and Monitoring Autonomous Database
When enabling auto-scaling, which three options do not change?
auto scalingparallelismconcurrencyOCPU - Question #41
Which statement is true when the Autonomous Database has auto scaling enabled?
- Question #42Managing and Monitoring Autonomous Database
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
Exadata infrastructuremaintenance historyADB DedicatedOCI console navigation - Question #43Migrating to Autonomous Database
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
Data Pumpdatabase migrationschemastablespaces - Question #44Provisioning and Connecting to Autonomous Database
Which two are correct actions to take in order to Download the Autonomous Database Credentials?
wallet downloaddatabase credentialsService ConsoleActions menu - Question #45Developing with Autonomous Database
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
automatic indexingdbms_auto_indexinvisible indexesADW performance - Question #46Autonomous Database Concepts
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?
parallelismHybrid Columnar CompressionResult Cacheshared Exadata - Question #47Managing and Monitoring Autonomous Database
While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during...
dedicated infrastructuremaintenance patchingRelease UpdateAutonomous Container Database - Question #48Autonomous Database Concepts
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hou...
workload typesOLTPmixed workloadservice selection - Question #50Autonomous Database Concepts
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
ATP vs ADWworkload optimizationrow formatdata storage - Question #51Managing and Monitoring Autonomous Database
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 automat...
auto scalingOCPU limitsdedicated infrastructurescaling behavior