How do you change the tablespace quota for user method in autonomous database on shared infrastructure?

Q. What are three methods to load data into the Autonomous Database?

Get answer to your question and much more

Q. What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

Get answer to your question and much more

Q. Which 3 data dictionary views contain information about analytic view objects?

Get answer to your question and much more

Q. For someone that is not a service administrator to use SQL Developer Web, what packagewould you need to use to give them access?A. SQLDEV_ADMIN.GRANT_SCHEMAB. ORDS_ADMIN.ENABLE_SCHEMAC. ORDS_ADMIN.GRANT_SCHEMAD. ORDS_PRIV.ENABLE_SCHEMAAnswer: C

Q. Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)

Get answer to your question and much more

Q. Which three statements are correct when the Autonomous Database is stopped? (Choosethree.)

Get answer to your question and much more

Which two are correct actions to take in order to download the Autonomous Database Credentials? (Choose two.)
A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
B. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
C. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
E. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.

The oracle Autonomous database dedicated exadata infrastructure feature is based upon which Oracle Cloud resources?
a- Autonomous Exadata infrastructure, autonomous backup, autonomous container database, autonomous database
b- Virtual network cloud, compartments, policies, autonomous exadata infrastructure
c- Oracle machine learning zeppelin network, autonomous exadata infrastructure, fleet administrator, database administrator
d- Fleet administrator, database administrator, database user, autonomous exadata infrastructure

Which two methods can you use to create database users and grant roles in Autonomous Database services? (Choose all correct answers)

Options are :

• SQL Developer (Correct)
• The pams_cnoup_apmrn package
• SQL*Plus (Correct)
• The Oracle Cloud Infrastructure service console

Answer :
*SQL Developer (Correct)
*SQL*Plus (Correct)

Which method will NOT permit you to change the database apsrn user's password of an Oracle Autonomous Database on Shared Infrastructure? (Choose the best answer.)

Options are :

• OS command line from the database server (Correct)
• SQL Developer
• OCI CLI
• Admin page of the Cloud Service Console

Answer :
*OS command line from the database server (Correct)

Which two options are available to restore an Oracle Autonomous Database? (Choose all correct answers)

Options are :

• Specify the archived custom image. (Correct)
• Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.
• Select the snapshot of the backup.
• Specify the point in time (timestamp) to restore. (Correct)
• Select the backup from which restore needs to be done.

Answer :
*Specify the archived custom image. (Correct)
*Specify the point in time (timestamp) to restore. (Correct)

1Z0-931-21 || Oracle Autonomous Database Cloud Set 3

What are two differentiators of Oracle Autonomous Database on Dedicated Infrastructure? (Choose all correct answers)

Options are :

• Users have OS access to the database machine. (Correct)
• Users can customize the OS stack and add additional packages.
• Users have more control over the maintenance schedule.
• Users have sys privileges in the database.
• To offers greater control and Isolation starting at the Exadata cloud infrastructure level. (Correct)

Answer :
*Users have OS access to the database machine. (Correct)
*To offers greater control and Isolation starting at the Exadata cloud infrastructure level. (Correct)

Your customer has upgraded their on-premises 11.2 Database to 12.2. Dui database was migrated to a pluggable database and is now in production. How should the customer unplug their database to migrate to Autonomous Database (ADB)?

Options are :

• RO Unplug into an XML file so database files and XML file can be uploaded to object storage.
• Create a database link from the source database to the ADB environment and clone the PDB.
• Unplug into a PDB archive, which can be uploaded to object storage.
• Pluggable databases cannot be migrated to ADB using plug, unplug, or clone. (Correct)

Answer :
*Pluggable databases cannot be migrated to ADB using plug, unplug, or clone. (Correct)

How do you change the tablespace quota for user mrizo on Autonomous Database on Shared Infrastructure?

Options are :

• Execute alter database for user MTHEO tablespace DATA quota = 10G;
• Execute alter user MTHEO quota unlimited on tablespace DATA;
• Execute nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => 'MTHEO�, tablespace quota ~> "UNLIMITED') ; (Correct)
• Execute alter tablespace DATA set quota = 10G;

Answer :
*Execute nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => 'MTHEO�, tablespace quota ~> "UNLIMITED') ; (Correct)

Oracle 1Z0-1067-21 | OCI Cloud Operations Associate Set 1

Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?

Options are :

• Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour
• Month of the Quarter, Week of the Month, Day of the Week, Start Hour (Correct)
• Month of the Year, Week of the Month, Day of the Week, Start Hour
• Week of the Quarter, Day of the Week, Start Hour

Answer :
*Month of the Quarter, Week of the Month, Day of the Week, Start Hour (Correct)

Which two statements are true about Data Insights? (Choose all correct answers)

Options are :

• Data Insights is available with on-premises deployments of Oracle Database
• You can retrieve previously executed Data Insights searches. (Correct)
• Data Insights is an additional priced option.
• You can search for Data Insights against a base table or business model. (Correct)

Answer :
*You can retrieve previously executed Data Insights searches. (Correct)
*You can search for Data Insights against a base table or business model. (Correct)

Which native data type is used to store spatial information?

Options are :

• spo_GroMeTRY (Correct)
• spo_retate
• Geo_sson
• spo_nocaTron

Answer :
*spo_GroMeTRY (Correct)

Oracle Cloud Platform Enterprise Analytics Set 3

Which command should you issue to enable application continuity on Oracle Autonomous Database on Shared Infrastructure?

Options are :

• alter system set application_continuity-true
• alter session set application_continuity=true
• exec dbms_cloud_admin.enable_app_cont(''); (Correct)
• alter database set application_continuity-true

Answer :
*exec dbms_cloud_admin.enable_app_cont(''); (Correct)

You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements: Autonomous Transaction Processing License Included Shared Infrastructure. Which parameter would you NOT use?

Options are :

• db-workload
• is-dedicated
• License-model
• db-type (Correct)

Answer :
*db-type (Correct)

Which statement is correct with respect to the required action to move Oracle Autonomous Database resources to a different compartment?

Options are :

• Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
• Moving an Autonomous Database instance does not include its automatic backups.
• You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
• Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remai their current compartments. (Correct)

Answer :
*Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remai their current compartments. (Correct)

1Z0-1094-21 || Oracle Cloud Database Migration & Integration Set 4

Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?

Options are :

• Only ATP manages optimizer statistics.
• Only ADW uses columnar compression by default. (Correct)
• Only ATP supports automatic backups.
• Only ADW supports autoscaling.

Answer :
*Only ADW uses columnar compression by default. (Correct)

Which two cloud services are supported to import Data Pump files to Autonomou! Infrastructure? (Choose all correct answers)

Options are :

• Azure Blob Storage
• Google Cloud Storage
• oracle Cloud Infrastructure Object Storage Classic (Correct)
• Amazon S3
• Oracle Cloud Infrastructure Object Storage (Correct)

Answer :
*oracle Cloud Infrastructure Object Storage Classic (Correct)
*Oracle Cloud Infrastructure Object Storage (Correct)

Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose all correct answers)

Options are :

• Use oracle Zero Downtime Migration (ZDM). (Correct)
• Use GoldenGate. (Correct)
• use SFTP to copy CSV files into Autonomous Database.
• Use Data Pump. (Correct)
• Use Recovery Manager (RMAN).

Answer :
*Use oracle Zero Downtime Migration (ZDM). (Correct)
*Use GoldenGate. (Correct)
*Use Data Pump. (Correct)

1Z0-1085-21 || Oracle Cloud Infrastructure Foundations Set 13

Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?

Options are :

• Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and include container database patching. (Correct)
• If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
• You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.
• Autonomous Exadata infrastructure maintenance takes place at least once each quarter.

Answer :
*Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and include container database patching. (Correct)

Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?

Options are :

• Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure
• Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator
• Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database (Correct)
• Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure

Answer :
*Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database (Correct)

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 Autonomous Database's Data Tools. Which steps do you need to perform?

Options are :

• Create a database user with the default privileges.
• Create a REST-enabled database user (with connect and object privileges) and grant the pwRoLE role. (Correct)
• Create a database user with connect, resource, and object privileges.
• Create an IDCS user. Create a database user with connect, resource, and object privileges.

Answer :
*Create a REST-enabled database user (with connect and object privileges) and grant the pwRoLE role. (Correct)

1Z0-1072-21 & 1Z0-997-21 | Exam Practice Tests - Bundle Set 10

Which two statements are true about accessing Autonomous Database Tools? (Choose all correct answers)

Options are :

• SQL Developer Web is available exclusively on the Autonomous Database. (Correct)
• Oracle APEX can be accessed only from the Developer menu in the Service Console. (Correct)
• Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
• Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpoint networking.
• Access to Database Actions is available for all users of Autonomous Database.

Answer :
*SQL Developer Web is available exclusively on the Autonomous Database. (Correct)
*Oracle APEX can be accessed only from the Developer menu in the Service Console. (Correct)

Which three options are available to access data in an Autonomous JSON Database? (Choose all correct answers)

Options are :

• Oracle Cloud Infrastructure console using the JSON Online Developer tool (Correct)
• Regular Oracle SQL statements using a connection through the listener
• REST API calls to the database (not enabled by default) (Correct)
• Oracle JSON Developer tool downloaded from OTN
• NoSQL statements using Oracle SODA drivers (Correct)

Answer :
*Oracle Cloud Infrastructure console using the JSON Online Developer tool (Correct)
*REST API calls to the database (not enabled by default) (Correct)
*NoSQL statements using Oracle SODA drivers (Correct)

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?

Options are :

• Run the PBMS_CLOUD. INCREASE_THROUGHPUT procedure.
• Ask Support to migrate their setup to a node without noisy neighbors.
• Increase the number of OCPUs allocated to the database. (Correct)
• Remove any non-JSON data from the database.

Answer :
*Increase the number of OCPUs allocated to the database. (Correct)

1Z0-1072-21 & 1Z0-997-21 | Exam Practice Tests - Bundle Set 5

You see a clock icon in the Status column on the SQL Monitoring tab of the Performance Hub. What does it indicate?

Options are :

• The SQL statement completed its execution.
• The SQL statement is executing.
• The SQL statement is queued. (Correct)
• The SQL statement did not complete due to an error.

Answer :
*The SQL statement is queued. (Correct)

Which three event types are supported for Autonomous Database? (Choose all correct answers)

Options are :

• Change Autoscaling Configuration Compartment
• Update 1ORM Begin
• Maintenance Begin (Correct)
• Terminate End (Correct)
• Change Compartment Begin (Correct)

Answer :
*Maintenance Begin (Correct)
*Terminate End (Correct)
*Change Compartment Begin (Correct)

You have a requirement to create an Autonomous Transaction Processing database that can support up. to 300 concurrent statements per OCPU as well as parallelism. Which service will you need to connect to?

Options are :

• TP
• LOW
• TPURGENT (Correct)
• MEDIUM

Answer :
*TPURGENT (Correct)

1Z0-1094-21 || Oracle Cloud Database Migration & Integration Set 3

Which two actions are available to perform when an Autonomous Database is stopped? (Choose all correct answers)

Options are :

• Update License Type (Correct)
• Update Network Access
• Change administrator password
• Start (Correct)

Answer :
*Update License Type (Correct)
*Start (Correct)

When cloning from a backup, what is the earliest timestamp of the backup allowed?

Options are :

• 2 hours (Correct)
• 1 hour
• 24 hours
• 30 minutes

Answer :
*2 hours (Correct)

Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

Options are :

• CPU Utilization, Storage Utilization
• Query Latency, User Calls, Execute Count
• Transaction Count, Sessions, Running Statements
• IOPS, Storage Space Used By Tablespace, Apply and Transport Lag Dedicated (Correct)

Answer :
*IOPS, Storage Space Used By Tablespace, Apply and Transport Lag Dedicated (Correct)

Oracle 1Z0-1067-21 | OCI Cloud Operations Associate Set 1

Which three tools can be used to monitor the usage and activities of Autonomous Database on Infrastructure? (Choose all correct answers)

Options are :

• Performance Hub (Correct)
• RMAN
• oci metrics (Correct)
• Enterprise Manager Cloud Control (Correct)
• LOGS

Answer :
*Performance Hub (Correct)
*oci metrics (Correct)
*Enterprise Manager Cloud Control (Correct)

Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to see the effect that changing an object has on other objects?

Options are :

• Data Load
• Catalog (Correct)
• Data Insights
• JOSN

Answer :
*Catalog (Correct)

Which two license types does a customer need to benefit from Bring Your Own License (BYOL) when leveraging on-premises Enterprise Database licenses in Oracle Autonomous Database? (Choose all correct answers)

Options are :

• Exadata (Correct)
• Muttitenant
• Active Data Guard
• Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs (Correct)
• Transparent Data Encryption (TDE)

Answer :
*Exadata (Correct)
*Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs (Correct)

Oracle 1Z0-1055-20 | Oracle Financials Cloud Payables Set 4

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint? (Choose all correct answers)

Options are :

• Subnet (Correct)
• Route Table
• VCN (Correct)
• Network Security Group (Correct)
• Security List

Answer :
*Subnet (Correct)
*VCN (Correct)
*Network Security Group (Correct)

In the Autonomous Database on Dedicated Infrastructure service, what does the fleet administrator use to control OCPU utilization?

Options are :

• SQL Develope Web Console
• Compartment quotas (Correct)
• Resource Manager settings
• Oracle Machine Learning notebook

Answer :
*Compartment quotas (Correct)

Autonomous Database's auto scaling feature allows your databa base number of OCPU cores at any time. As demand increases, auto number of cores in use. Likewise, as demand drops, auto scaling automatically cores in use. Which statement is FALSE regarding the auto scaling feature?

Options are :

• The base number of OCPU cores allocated to a database is not guaranteed. (Correct)
• 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.
• Auto scaling is enabled by default and can be enabled or disabled at any time.
• 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.

Answer :
*The base number of OCPU cores allocated to a database is not guaranteed. (Correct)

Oracle 1Z0-1067-21 | OCI Cloud Operations Associate Set 3

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 on the dedicated infrastructure?

Options are :

• The Listener endpoint where the Autonomous Database should register on
• The container database in which the Autonomous instance should run (Correct)
• The compartment of the dedicated infrastructure because each compartment only runs one dedicated environment
• The Client Credentials wallet, which is used to connect to the Autonomous Database

Answer :
*The container database in which the Autonomous instance should run (Correct)

Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose all correct answers)

Options are :

• Create a single alarm for each metric. (Correct)
• Routinely tune your alarms.
• Use a single interval for all alarms.
• Select the correct alarm interval for your metric. (Correct)
• Create multiple alarm metrics.
• Suppress alarms during investigations. (Correct)

Answer :
*Create a single alarm for each metric. (Correct)
*Select the correct alarm interval for your metric. (Correct)
*Suppress alarms during investigations. (Correct)

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?

Options are :

• Create an Oracle Cloud Infrastructure Alarm for Shutdown metric.
• Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database.
• Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END."
• Create a notification alert using DBMS_SNMP package. (Correct)

Answer :
*Create a notification alert using DBMS_SNMP package. (Correct)

1Z0-1072-21 & 1Z0-997-21 | Exam Practice Tests - Bundle Set 7

Which statement is FALSE about Oracle Autonomous JSON Database?

Options are :

• JSON data is stored natively in the database.
• You can promote Autonomous JSON Database to Autonomous Transaction Processing. (Correct)
• It supports NoSQt-style, document-centric applications.
• There is a 20 GB limit on JSON collections.

Answer :
*You can promote Autonomous JSON Database to Autonomous Transaction Processing. (Correct)

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

Options are :

• 60 days
• 15 days
• 7 days
• 120 days (Correct)

Answer :
*120 days (Correct)

Which is NOT needed to manage Oracle Autonomous Database with REST APIs?

Options are :

• Fingerprint of the public key
• Tenancy's OCID
• User's OCID
• Database ADMIN password (Correct)

Answer :
*Database ADMIN password (Correct)

1Z0-1072-21 & 1Z0-997-21 | Exam Practice Tests - Bundle Set 8

Which three of the following data sources are available when using the Data Load page on Database Actions? (Choose all correct answers)

Options are :

• REST endpoints (Correct)
• Backup files in block storage
• Local Files (Correct)
• Files in Oracle Cloud Storage (Correct)
• Files in AWS S3 Storage

Answer :
*REST endpoints (Correct)
*Local Files (Correct)
*Files in Oracle Cloud Storage (Correct)

Which statement is correct about the Service console in an Autonomous Database?

Options are :

• You can use the Service console to create manual backups of an Autonomous Database.
• You can use the Service console to move an Autonomous Database between compartments.
• You can use the Service console to manage runaway SQL statements on an Autonomous Database. (Correct)
• You can use the Service console to enable or disable autoscaling of an Autonomous Database.

Answer :
*You can use the Service console to manage runaway SQL statements on an Autonomous Database. (Correct)

Which three options do NOT change when enabling auto scaling? (Choose all correct answers)

Options are :

• I/O resources
• Parallelism settings (Correct)
• Amount of storage (Correct)
• Level of concurrency (Correct)

Answer :
*Parallelism settings (Correct)
*Amount of storage (Correct)
*Level of concurrency (Correct)

1Z0-1085-21 || Oracle Cloud Infrastructure Foundations Set 14

Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?

Options are :

• Inside the Autonomous Database wallet
• In a separate key vault external to the Exadata Infrastructure (Correct)
• Inside the backups of the container database
• On the Exadata Infrastructure where Autonomous Database Dedicated Is hosted

Answer :
*In a separate key vault external to the Exadata Infrastructure (Correct)

Which three advanced options can you enable or disable while creating a business model? (Choose all correct answers)

Options are :

• Analytic View Transparency Views (Correct)
• Display private tables
• Autonomous Aggregate Cache (Correct)
• Analytic View Base Table Query Transformation (Correct)
• Business Object Security Feature

Answer :
*Analytic View Transparency Views (Correct)
*Autonomous Aggregate Cache (Correct)
*Analytic View Base Table Query Transformation (Correct)

You have been tasked with analyzing a year's worth of sales data stored in an Autonomous Data Warehouse instance. Which tool would you use to automate data exploration and create pivot tables?

Options are :

• APEX
• SQL Developer Web
• Business Models (Correct)
• Bata Load

Answer :
*Business Models (Correct)

1Z0-1085-21 || Oracle Cloud Infrastructure Foundations Set 8

The Oracle Autonomous Cloud 2020 refers to a cloud-based technology that is designed for automating many routine tasks essential for managing Oracle databases. Oracle 1Z0-931-20 exam validates your skills and demonstrates your knowledge in Autonomous Transaction Database (ATP) and Autonomous ?Data Warehouse (ADW). Further, this highly acclaimed exam helps you enhance your employability and promises higher career growth.

1. Autonomous Database Technical Overview
2. Migration and Data Loading into Autonomous Database
3. Monitoring Autonomous Database
4. Provisioning and Connectivity
5. Managing and Maintaining Autonomous Database
6. Tools, Reporting and Analytics using Autonomous Data Warehouse (ADW)

There is no prerequisite for this certification, you can go for this exam directly. A combination of Oracle training and hands-on experience is recommended.

Note: This certification comes under the Cloud Recertification policy, to read more about the guidelines click here.

• Exam Title: Oracle Autonomous Database Cloud Specialist
• Exam Number: 1Z0-931-21
• Exam Price: $244
• Format: Multiple Choice
• Duration: 90 Minutes
• Number of Questions: 60
• Passing score: 65%

How do you change the tablespace quota for user Mtheo on autonomous database on shared infrastructure?

Which role is automatically granted to any user created in Autonomous database?

What are three platforms where Oracle autonomous database service can be deployed?

Can we create tablespace in autonomous database?