1Z0-931-23
Master the Autonomous Database Certification Quiz
Test your knowledge and skills on Oracle’s Autonomous Database with our comprehensive 100-question quiz. Designed for those looking to certify their expertise, this quiz covers a wide array of topics that are essential for mastering Autonomous Database management.
Join today to:
- Challenge your understanding of Autonomous Database features.
- Prepare effectively for certification exams.
- Enhance your cloud database management skills.
In the Autonomous Database on Dedicated Infrastructure service, what does the fleet administrator use to control OCPU utilization?
Compartment quotas
Oracle Machine Learning notebook
SQL Developer Web Console
Resource Manager settings
Which option should you use to create a graph with Graph Studio?
NoSQL configuration
A graph license key
Graph created by a special tool downloaded from oracle.com
Tables in an Autonomous Database Instance
Graph analytics algorithms
What are the two differentiators of Autonomous Database on Dedicated Infrastructure?
(Choose two.)
Users have SYS privileges in the database
Users have OS access to the database machine
Users can customize the OS stack and add additional packages
Users have more control over the maintenance schedule
Users are offered greater control and isolation starting at the Exadata Cloud Infrastructure level
Which method does not permit you to change the database ADMIN user's password of an Oracle Autonomouns Database on Shared Infrastrucuture
OCI CLI
SQL Developer
Admin page of the Cloud Service Console
OS command line from the database server
In which four ways can Oracle database optimally access data in Object Storage? (Choose four.)
Scan avoidance using block skipping when reading parquet and orc files
Scan avoidance using partitioned external tables
Scan avoidance using columnar pruning for .csv files
Optimized data archive using hybrid partitioned tables
Optimized data archive using partitioned external tables
Scan avoidance using columnar pruning for columnar stores like parquet and orc
How do you change the tablespace quota for user MTHEO on Autonomous Database on Shared Infrastructure?
Execute alter user MTHEO quota unlimited on tablespace DATA;
Execute
DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username=>'MTHEO',tablespace_quota=>'UNLIMITED');
Execute alter database for user MTHEO tablespace DATA quota =10G
Execute alter tablespace DATA set quota =10G;
Which statement is FALSE about Oracle Data Safe? (Choose two.)
It helps you assess the security of your cloud database configurations by analyzing database configurations.
It supports only Autonomous Databases.
It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.
It helps you evaluate risk to data, assess user security, monitor user activity, and address data security compliance requirements.
It evaluates user types, how users are authenticated, and the password policies assigned to each user.
What is the difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?
Only ATP supports automatic backups.
Only ATP manages optimizer statistics.
Only ADW uses columnar compression by default.
Only ADW supports autoscalling.
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)
Using SFTP to copy CSV files into an Autonomous Database
Using GoldenGate
Using Recovery Manager (RMAN)
Using Data Pump
Using Oracle Zero Downtime Migration (ZDM)
Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?
Catalog
JSON
Data Insight
Data Load
Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?
The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.
The marketplace OCI image can be used with an Always Free Autonomous Database account.
A Private Endpoint is required to connect to the Autonomous Database on shared Exadata Infrastructure.
The Autonomous Database must belong to a Network Security Group (NSG).
The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.
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 will you need to connect to?
Low
TPURGENT
TP
MEDIUM
Which statement is true about the use of Access Control List (ACLs) with an Autonomous Database on Shared Infrastructure?
ACLs can only be used with private endpoint.
When you restore database, the existing ACLs are not overwritten by the restore.
An ACL can only be set during the creation of an Autonomous database on shared infrastructure.
An ACL can be set up for an IP Address or a virtual cloud network but not both at the same time.
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?
APEX
SQL Developer Web
Business Models
Data Load
Where are the customer-managed encryption keys stored for Autonomous Database on dedicated infrastructure?
In a separate key vault external to the exadata infrastructure.
Inside the backup of the container database.
Inside the Autonomous database wallet.
On the exadata infrastructure where the Autonomous database dedicated is hosted.
Which two statements are true about using an Oracle Autonomous Database with private endpoints? (Choose two.)
A network security group is required within your virtual cloud network before you can provision a shared autonomous database to private endpoints.
Private endpoints can be configured when you clone a shared autonomous database that was initially created with public endpoints.
An Autonomous database with private endpoints can be accessed from the public internet by adding your ip address to an access control list (ACL).
You can configure private endpoints for an always free autonomous database.
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in the oralce autonomous database?
Transparent Data Encryption (TDE)
Active Data Guard
Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
Multitenant
Exadata
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?
IOPS, Storage used by tablespace, apply and transport lag
CPU Utilization, Storage Utilization
Transaction Count, Running Statements, Sessions
Query Latency, User Calls, Execute Count
An Autonomous Database user with an instance wallet has left the company. The user had shared a database user ID with other users when accessing the Autonomous Database. Other than changing the shared user password, what can an administrator do to protect the instance?
Delete user
Trust the user who left, not to access the database
Rotate the instance wallet and share the new wallet with the remaining users
Shutdown and restart the database
A new Python developer has joined your team and needs to access the Autonomous Database data. How does the developer connect to and interact with the Autonomous Database from Python?
By using SQL Developer
By using Oracle Client and the DBD-oracle interface
By using JDBC Driver
By using Oracle Client and the cx_oracle interface
Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?
Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating system updates) and includes container database patching.
Autonomous Exadata infrastructure maintenance takes place at least once each quarter.
If a scheduled container database maintenance run cannot take place, Oracle automatically reschedules the container database maintenance for the following quarter.
You can change you container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow.
Oracle Autonomous Database on Dedicated Infrastructure is composed on which Oracle Cloud resource?
Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator
Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
Autonomous Database's auto scaling features allows your database to use up to three times the current base number of OCPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use. Which statement is FALSE regarding the auto scaling feature?
The base number of OCPU cores allocated to a database is not guaranteed.
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.
For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that are not being used by other auto scaling databases to meet high-load demands.
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?
Db-type
Is-dedicated
License-model
Db-workload
Which native data type is used to store spatial information?
GEO_JSON
SDO_RELATE
SDO_LOCATION
SDO_GEOMETRY
When cloning from a backup, what is the earliest timestamp of the backup allowed? OR when you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?
1 hour
30 minutes
2 hours
24 hours
Which three advanced options can you enable or disable while creating a business model? (Choose three.)
Analytic View Base Table Query Transformation
Autonomous Aggregate Cache
Analytic view Transparency view
Business Object Security Feature
Display private tables
Which command should you issue to enable application continuity on Oracle Autonomous Database on Shared?
Exec dbms_cloud_admin.enable_app_count('');
Alter system set application_continuity=true
Alter session set application_continuity=true
Alter database set application_continuity=true
Your customer has upgraded their on-premises 11.2. Databases to 12.2. During this migration, the database was migrated to a pluggable database (PDB) and is now in production. How should the customer unplug their database to migrate to an Autonomous Database?
Create a database link from the source database to the Autonomous Database environment and clone the PDB.
Unplug into an XML file so that the database and XML files can be uploaded to the Object Storage.
PDBs cannot be migrated to an Autonomous database using plug, unplug or clone.
Unplug into a PDB archive, which can be uploaded to Object Storage.
You are the admin user of an Autonomous Database instance. A new business analyst has joined the team and would like to explore the Autonomous Database tables using Autonomous Database's Data Tools. Which step should you perform to enable the new team member?
Create a REST-enabled database user (with connect and object privileges) and grant the DWROLE role.
Create an IDCS user. Create a database user with connect, resource and object privileges.
Create a database user with connect, resource and object privileges.
Create a database user with the default privileges.
Which two options are available for restoring an Autonomous Database? (Choose two.)
Specifying the archived custom image.
Specifying the point in time (timestamp) to restore.
Selecting the backup from which restore needs to be done.
Selecting the snapshot of the backup.
Using Recovery Manager (RMAN) to connect to Autonomous Database and back it up.
Which three tools can be used to monitor the usage and activities of an Autonomous Database on Dedicated Infrastructure?
Enterprise Manager Cloud Control
Logs
OCI Metrics
RMAN
Performance Hub
During the provisioning of an Autonomous Database on dedicated hardware, what should the database adminstrator select to determine where the Autonomous Database is created on the dedicated infrastructure?
The Client Credentials wallet, which is used to connect to the Autonomous Database.
The listener endpoint where the Autonomous Database should register on.
The compartment of the dedicated infrastructure because each compartment only runs one dedicated environment.
The container database in which the Autonomous Database should run.
Which two statements are true about Data Insights? (Choose two.)
Data Insights is available with on-premises deployments of Oracle Database.
Data Insights is an additional priced options.
You can retrieve previously executed Data Insights searches.
You can search for Data Insights against a base table or business model.
Which three options are available to access data in an Autonomous JSON Database? (Choose three.)
Oracle Cloud Infrastructure console using the JSON Online Developer tool
Oracle JSON Developer tool downloaded from Oracle Technology Network (OTN)
NoSQL statements using Simple Oracle Document Access (SODA)
Regular Oracle SQL statements using connection through the listener.
REST API calls to the database (not enabled by default)
A customer want 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?
Run the DBMS_CLOUD.INCREASE_THROUGHPUT precedure.
Ask support to migrate their setup to a node without noisy neighbors.
Remove any non-JSON data from the database.
Increase the number of OCPUs allocated to the database.
Which three options do NOT change when enabling auto scaling? (Choose three.)
I/O resources
Level of concurrency
Parallelism settings
Amount of storage
Number of OCPUs displayed in the console
Which statement is correct about the Service console in an Autonomous Database?
You can use the Service console to create manual backups of an Autonomous Database.
You can use Service console to manage runaway SQL statements on an Autonomous Database.
You can use Service console to move an Autonomous Database between compartments.
You can use Service console to enable or disable auto scaling of an Autonomous Database.
Which two methods can you use to create database users and grant roles in Autonomous Database services? (Choose two.)
SQL*Plus
DBMS_CLOUDADMIN package
Oracle Cloud Infrastructure (OCI) service console
SQL Developer
Which of the following two statements are correct? (Choose two.)
Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.
ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.
ODI Web Edition is available only on Oracle Linux.
All capabilities of ODI Classic are available with ODI Web Edition .
Which is NOT needed to manage Oracle Autonomous Database with REST APIs?
Database ADMIN password
Tenancy's OCID
Fingerprint of the public key
User's OCID
While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?
120 days
15 days
60 days
7 days
Which statement is correct with respect to the required action to move Oracle Autonomous Database resources to a different compartment?
Moving an Autonomous Database instance does not include its automatic backups.
Moving the compartment of the Autonomous Database also moves the Autonomous Container Database and Autonomous Exadata Infrastrucute.
You do not require 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. Associate (non-dependent) resources remain in their current compartments.
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?
Switchover is automatically initiated.
Standby database is terminated.
Failover is automatically initiated.
Standby database is also stopped.
Which two cloud services allow you to import Data Pump files to an Autnomous Database on Dedicated Infrastructure? (Choose two.)
Azure Blob Storage
Oracle Cloud Infrastructure Object Storage
Google Cloud Storage
Oracle Cloud Infrastructure Object Storage Classic
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
Navigate to Identity, select Users panel on the console and select "Add Public Key"
SSH keys cannot be added from the console.
They have to be added using REST APIs only.
SSH keys are not required in Oracle Cloud infrastructure.
On the Autonomous Database console.
A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to the data tools page for the business analyst. When restoring /cloning the ADB, you must select a backup which is atleast _____hours/minutes old?
1 day
2 hours
5 min
24 hours
What REST verb is used to create an Autonomos Database service using REST APIs?
A "POST" REST call
An "INSERT" REST call
A "GET" REST call
A "PUT" REST call
What is the best prcatice when planning and instituting Access controls for your Autonomous dedicated environment regarding Subnets, Compartments and User Groups?
Create a separate VCN that contains only public subnets
Only 1 of each is allowed to be allocated per environment.
Only 1 subnet and 1 compartment are allowed, multiple groups highly advised.
Create at least 2 of each resources.
Which can be Scaled independently of the number of CPUs in an Autonomous Database?
Memory
Parallelism
Concurrency
Storage
Sessions
What are the two advantages of using Data Pump to migrate your oracle database to autonomous database? (Choose two.)
Data Pump is faster to migrate databases than using RMAN
Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
Data Pump creates the tablespaces used by your Autonomous Database.
Data Pump is platform independent - it can migrate Oracle databases running on any platform.
Which three are use cases for Graph Studio? (Choose three.)
Churn Analysis
3-D modelling
Facial recognition
Pattern matching
Clustering
Which set of options can be specified when defining the preferred maintenance schedule of the Exadata Infrastructure for Autonomous Database Dedicated?
Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour
Week of the Quarter, Day of the Week, Start Hour
Month of the Year, Week of the Month, Day of the Week, Start Hour
Month of the Quarter, Week of the Month, Day of the Week, Start Hour
Which three of the following data sources are available when using the Data Load page on Database Actions? (Choose three.)
Files in AWS S3 Storage
REST endpoints
Local Files
Backup files in block storage
Files in Oracle Cloud Storage
Which three event types are supported for Autonomous Database? (Choose three.)
Update IORM Begin
Change Auto Scaling Configuration Compartment
Terminate End
Maintenance Begin
Change Compartment Begin
Which stage of the indexing pipeline divides text into tokens?
Filter
Lexer
Tokenizer
Sectioner
Which two statements are true about accessing the Autonomous Database Tools? (Choose two.)
SQL Developer Web is available exclusively on Autonomous Database.
Access to Database Action is available for all users of Autonomous Database.
Oracle APEX can be accessed only from the Developer menu in the Service Console
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.
Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
You need to setup a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?
Add a 'BEFORE SHUTDOWN On DATABASE' trigger within the database
Create a notification alert using DBMS_SNMP package
Create and Oracle Cloud Infrastructure Alarm for Shutdown metric
Create a rule for the Oracle Cloud Infrastructure Event for 'Autonomous Database STOP END'
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with private endpoint? (Choose three.)
Route Table
Subnet
Network Security Group
VCN
Security List
Which statement is FALSE about Oracle Autonomous JSON Database?
There is 20g limit on JSON collection.
It supports NoSQL-style, document-centric application.
JSON data is stored natively in the database.
You can promote Autonomous JSON Database to Autonomous Transaction Processing
What happens with the standby database when disabling Autonomous Data Guard?
The standby database is started read-write
The standby database is transformed in a refreshable clone
The standby database is started read-only
The standby database is terminated.
You see a clock icon in the Status column on the SQL Monitoring tab of Performance Hub. What does it indicate?
The SQL statement is queued.
The SQL statement completed its execution.
The SQL statement is executing.
The SQL statement did not complete either due to an error.
Which three are Oracle-recommended best practices for Autonomous Darabase alarms? (Choose three.)
Suppress alarms during investigations
Routinely tune your alrams
Select the correct alarm interval for your metric
Create multiple alarm metrics
Which statement si FALSE about setting up compartment quotas?
Compartment quotas use policies that allows allocation of resources with a high level of flexibility.
Compartment quotas cannot be set on the root compartment.
You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.
Quotas set to a parent compartment override quotas set on a child compartments.
Which two actions can be performed when an Autonomous Database is stopped? (Choose two.)
Update License type
Change Administrator password
Update Network Access
Start
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Chosse two.)
The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
The target table will be created in Autonomous Database if it does not already exist.
The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
The default eight day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?
Create_baseline_template
Modify_baseline_window_size
Modiy_snapshot_settings
Update_object_info
As a database architect, you are tasked with configuring a high concurency, production OLTP application tp connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode. Which Connection is appropriate for such workload?
TP
TPURGENT
MEDIUM
HIGH
Which Autonomous Databse Service is NOT used to connect to an Autonomous Transaction Processing instance?
TPURGENT
MEDIUM
LOW
HIGH
TPPERFORMANT
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transacion Processing database instance and what are they called?
Five. They are called tpurgent, tp, high, medium and low.
Three. They are called high, medium and low.
None. These are no pre-defined service names in tnsnames.ora
Two. They are called ATP and ADW.
Which Autonomous Database Cloud Service ignores hints in SQL Statements by defaults?
Neither service ignore hints by default
Both services ignore hints by default
Autonomous Data Warehouse
Autonomous Transaction Processing
When running lots of concurrent queries in the autonomous database, you should use which predefined service connection? OR Which predefined service connection should you use when running lots of high concurrent queries in Auonomous Database?
DBNAME_CONCURRENT
DBNAME_MEDIUM
DBNAME_HIGH
DBANME_LOW
Which statement is true when you provision an Autonomous Database using cloning method?
There is only one type of cloning option available in Autonomous database.
A clone database source can be from a point-in-time backup that is less than 2 hours old.
You can clone a database in a security zone to create a database that isn't in security zone.
A clone database source can be running database instance.
Your customer has upgraded their on premises 11.2 to 12.2. During this migration, the database was migrated to a pluggable database and is now in production. How shoud the customer unplug their database to migrate to An Autonomous Database (ADB)?
Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
Create a database link from source database to ADB environment and clone PDB.
Unplug into a PDB archive which can be uploaded to archive storage.
Unplug to an xml file so database files and xml file can be uploaded to object storage.
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
Avro
Parquet
Micrsoft SQL Server (.mdf)
JSON
Which statement is NOT correct when the Autonomous Database is stopped?
CPU billing is halted.
User with DWROLE can still access the database.
In-flight transactions queries are stopped.
Tools are no longer able to connect to a stopped instance.
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
The DBMS_CLOUD.DELETE_FILE procedure removes the credential file from the Autonomous Data Warehouse.
The DBMS_CLOUD.PUT_OBJECT procedure copies a file from cloud object storage to Autonomous Data Warehouse.
The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE validates the source file for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a bad file table in Autonomous Data Warehouse.
The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores cloud object credentials in the Autonomous Data Warehouse.
When using Data Pump to migrate your Oracle Database to Autonomous Database, which two objects are impoted? OR Which two objects are imported when using Data Pump to migrate your Oracle Database to Autonomous Database? (Choose two.)
Schemas
Tablespaces
Reports
Data
While the Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle Database, which statement is true about the workloads?
Autonomous Data Warehouse workloads are optimized for mixed workloads.
Autonomous Transaction Processing workloads are optimized for data warehouse, data mart and data lake.
Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
Data that is bulk uploaded, by default uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse format is columnar.
Which statement is correct about service console in Autonomous Database?
You can use service console to move Autonomous DB between compartments.
You can use service console to manage runaway SQL statements on Autonomous DB
You can use service console to create manual backups of Autonomous database
You can use service console to enable or disable auto scaling of Autonomous DB
Which task is NOT automatically performed by the Oracle Autonomous Database?
Mask your sensitive data
Patching the database
Automatically optimize workload
Backing up the database
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?
Oracle Database Result Cache is enabled by default for all SQL statements.
Parallelism is not enabled by default.
You have direct access to the database node.
Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
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?
1800
2700
1500
900
Given the steps:
1. Create Oracle Machine Learning User
2. Create Projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts.
Which two steps are out of order when working with Oracle Machine Learning? (Choose two.)
Create Projects
Create Notebooks
Create Oracle Machine Learning User
Run SQL Scripts
Create Workspaces
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
Through SQL/Developer's
Through the Oracle Cloud Infrastructure service console
Through SQLPlus
Using DBMS_CLOUD_ADMIN package
You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX. What statement describes the step to provide the developer a new workspace in APEX?
Access the APEX Administrator Services and create the workspace for the developer.
Create a new developer account
Create a database user with the APEX role.
Create a IDCS user with the APEX role.
What is the correct way to list all files in the default data pump directory?
You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW)
By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
Log onto ADW server and issue is-al on the command line.
By executing select * from utl_file.list('DATA_PUMP_DIR');
Which option is not available to pick (no. Of days) when configuring the backup retention for Oracle Container Database?
60
120
7
15
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s). How can they achieve this?
Change the Automatic Maintenance Schedule to 'Specify a Schedule;' but do not select any month, week or day.
Change the Automatic Maintenance Schedule to 'No Preference'.
Change the Automatic Maintenance Schedule to 'None'.
You cannot permanently disable scheduled Automatic Maintenance.
Which cloud service is NOT supported to import data pumpfiles from using Dedicated Exadata Infrastructure?
OCI Object Storage
Amazon S3
Google Cloud Storage
OCI Object Storage Classic
Which of these database feature is not part of the Autonomous Database?
Real Application Cluster
Java in the Database
Flashback Database
Online Indexing
What is the pre-requisite for taking a manual backup of an Autonomous Database?
Your database must be stopped.
Your database must be deployed on Oracle Exadata Cloud@Customer X8M
You must have an object storage bucket and your database must be configured to connect to it.
You cannot take manual backups of autonomous database
Which procedure can be used to load data directly into the existing Autonomous Database tables?
DBMS_CLUD.CREATE_EXTERNAL_TABLE
DBMS_CLUD.PUT_OBJECT
DBMS_CLUD.LIST_FILES
DBMS_CLUD.COPY_DATA
Which statement is not correct when using Automatic Indexing on Autonomos Data Warehouse?
You can use the DBMS_AUTO_INDEX package to report on the automatic task and to set your preferences.
Process includes identify candidates, create invisible auto indexes, verify with implement if performance improved and delete unused.
It is enabled by default
You can control behavior at the statement level using the USE_AUTO_INDEXES or NO_USEAUTO_INDEXES hint
The indexing feature is implemented as an automatic task that runs at a fixed interval.
What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?
Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.
Fleet Administrator create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.
Fleet Administrator create, monitor and manage Autonomous Database.
Fleet Administrator are responsible for patching and backups of all container database.
Which management operation is correct about Autonomous databases on shared Exadata Infrastructure?
You can skip a scheduled maintenance run. For Autonomous database on a shared Exadata Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.
You cannot configure the scheduling for your autonomous databases on shared Exadata Infrastructure.
You can perform a "rolling restart" on all the autonomous databases. During a rolling restart, each node on the autonomous database is restarted separately while the remaining nodes continue to be available.
You can choose to use release update or release update revision updates for your autonomous databases on shared infrastructure.
Which two are correct actions to take in order to download the Autonomous Database Credentials?
Click on the Object Storage and find your Autonomous bucket and Download the wallet credentials
Click on the Autonomous database in the menu, click a database name, then choose DB connection button, then download the wallet.
Find the service console for your Autonomous Database, then pick administration, then download the credential wallet.
Click the compute section of the menu, then choose instance configurations, then download wallet.
Which clause is used in Property Graph query language to specify patterns?
Match
Between
Distinct
Like
{"name":"1Z0-931-23", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge and skills on Oracle’s Autonomous Database with our comprehensive 100-question quiz. Designed for those looking to certify their expertise, this quiz covers a wide array of topics that are essential for mastering Autonomous Database management.Join today to:Challenge your understanding of Autonomous Database features.Prepare effectively for certification exams.Enhance your cloud database management skills.","img":"https:/images/course8.png"}