Autonomous Database III Flashcards
When you are increasing the number of OCPUs in your Autonomous Database, what does its status show?
UPLIFT IN PROGRESS
SCALING IN PROGRESS
RESIZING IN PROGRESS
UPSCALE IN PROGRESS
SCALING IN PROGRESS
Which command can you use to create an Autonomous Database?
POST /20160918/autonomousDatabases
POST /20160918/createADB
POST /20160918/createautonomousDatabases
POST /20160918/createDatabases
POST /20160918/autonomousDatabases
8.You want to enable automatic indexing in a database, but any new auto indexes should be created as invisible indexes, so that they cannot be used in SQL statements. Which command will you use?
EXEC DBMS_AUTO_INDEX.CONFIGURE(‘AUTO_INDEX_MODE’,’REPORT ONLY’);
EXEC DBMS_AUTO_INDEX.CONFIGURE(‘AUTO_INDEX_MODE’,’OFF’);
EXEC DBMS_AUTO_INDEX.CONFIGURE(‘AUTO_INDEX_MODE’,’INVISIBLE’);
EXEC DBMS_AUTO_INDEX.CONFIGURE(‘AUTO_INDEX_MODE’,’IMPLEMENT’);
EXEC DBMS_AUTO_INDEX.CONFIGURE(‘AUTO_INDEX_MODE’,’REPORT ONLY’);
Your company has deployed an Autonomous Database on a dedicated infrastructure. Which THREE resources will be managed by your company?
(Choose all correct answers)
Schemas Storage Servers DB User DB servers Hypervisors Encryption Keys
Schemas
DB User
Encryption Keys
Which statement is true about Autonomous Data Guard?
Autonomous Data Guard is free.
The standby database and the primary database are always on different regions.
After a failover to the local region’s standby database you need to update the URLs for all your tools with the new primary database details.
After a failover, a new standby for the primary database is automatically provisioned.
After a failover, a new standby for the primary database is automatically provisioned.
Which TWO statements are TRUE about Oracle Spatial with Autonomous Database?
(Choose all correct answers)
Spatial consists of a schema (MDSYS) that prescribes the storage, syntax, and semantics of supported geometric data types.
Open Geospatial Consortium Web Services is available in Autonomous Database.
Spatial supports the use of JSON and GeoJSON objects.
Oracle Spatial with Autonomous Database comes with integrated Network Model and Data Model.
Spatial consists of a schema (MDSYS) that prescribes the storage, syntax, and semantics of supported geometric data types.
Spatial supports the use of JSON and GeoJSON objects.
Who manages the compartment quotas for an Autonomous Database in a dedicated infrastructure?
System Administrator
Fleet Administrator
Service Administrator
Database Administrator
Fleet Administrator
Which are the TWO prerequisites to migrate a physical database to an autonomous database?
(Choose all correct answers)
Database must not be encrypted.
All uses of CDB admin privileges must be removed.
Database must be a PDB.
All indexes must be dropped.
All uses of CDB admin privileges must be removed.
Database must be a PDB.
Which THREE statements are TRUE about private endpoints?
(Choose all correct answers)
You can change the network access of an autonomous database in a shared Exadata infrastructure from private endpoint to public endpoint.
You need to set up transit routing in your VCN and use a service gateway to connect.
You can configure an existing Autonomous Database (ADB) to use a private endpoint.
You can configure a private endpoint while cloning your ADB.
You can change the network access of an autonomous database in a shared Exadata infrastructure from private endpoint to public endpoint.
You can configure an existing Autonomous Database (ADB) to use a private endpoint.
You can configure a private endpoint while cloning your ADB.
Which Autonomous Database Developer tool can be used to build web applications rapidly?
Jupyter Notebooks
Web Reporting Studio
APEX
SQL
APEX
REPORTADB is a refreshable clone of PRODADB. Which TWO statements are TRUE?
(Choose all correct answers)
REPORTADB can be changed to READ WRITE without disconnecting it from PRODADB.
APEX URLs will not work for REPORTADB.
It is possible to create cascading refreshable clones.
If you do not perform a refresh within seven days, then REPORTADB will be no longer refreshable.
APEX URLs will not work for REPORTADB
If you do not perform a refresh within seven days, then REPORTADB will be no longer refreshable.
Which TWO tasks are performed by a Fleet Administrator?
(Choose all correct answers)
Manage Autonomous Databases.
Provision Autonomous Container Databases.
Provision Autonomous Database instances.
Provision Autonomous Exadata Infrastructure.
Create IAM users.
Provision Autonomous Exadata Infrastructure.
Provision Autonomous Container Databases.
Which TWO statements are TRUE about an Oracle Autonomous Transaction Processing database?
(Choose all correct answers)
Memory configuration, data formats, indexes, and access structures are automatically optimized to optimize response time.
Use data summaries such as storage indexes on the Exadata storage cells to quickly answer the data that is needed in the query.
It is best suited for Analytics Workload.
It stores data in Row Format.
Memory configuration, data formats, indexes, and access structures are automatically optimized to optimize response time.
It stores data in Row Format.
Which Oracle Package is used to load data to an ADB from object storage?
DBMS_CLOUD
DBMS_LOAD
DBMS_RPC
DBMS_MIGRATE
DBMS_LOAD
You want to migrate a schema from an on-premises database to an ATP dedicated instance using Data Pump export. You specified the ENCRYPTION parameter as DATA_ONLY and Oracle Encryption Wallet is open.
Which type of encryption mode will be used in this scenario?
Password
Dual
Transparent
None
Transparent
Which statement is TRUE about auto indexing in an Autonomous Database?
It provides PL/SQL APIs for configuring automatic indexing in a database and generating reports related to automatic indexing operations.
It analyzes the application workload, and accordingly creates new indexes and drops the existing underperforming indexes to improve database performance.
Auto indexing is enabled by default.
It cannot rebuild indexes that are marked as unusable due to table partitioning maintenance operations.
It analyzes the application workload, and accordingly creates new indexes and drops the existing underperforming indexes to improve database performance.
Which THREE predefined database service names are available in an Autonomous Data Warehouse?
(Choose all correct answers)
tpurgent high tp medium low
High, Medium, Low
How many Network Security Groups (NSGs) can you configure for an Autonomous Database?
three
five
seven
nine
five
Which TWO statements are TRUE about Auto Scaling?
(Choose all correct answers)
Enabling auto scaling also increases the concurrency and parallelism settings for the predefined services.
Scaling up automatically expands CPU but not IO resources.
If you are provisioning an always-free database, auto scaling is not available.
It can be enabled when provisioning an ADB instance or anytime using the Oracle Cloud Infrastructure console.
If you are provisioning an always-free database, auto scaling is not available.
It can be enabled when provisioning an ADB instance or anytime using the Oracle Cloud Infrastructure console.
Which TWO statements are TRUE about Access Control Lists (ACLs) configured for Autonomous Databases?
(Choose all correct answers)
A database restore overwrites the existing ACLs.
All services that are subsets of an ADB, such as SQL Developer Web, APEX, and OML notebooks, are also blocked by ACLs.
Access Control Lists can be configured for autonomous databases only at the time of provisioning.
ACLs can be configured for individual IP addresses, CIDR block ranges, and VCNs.
All services that are subsets of an ADB, such as SQL Developer Web, APEX, and OML notebooks, are also blocked by ACLs.
ACLs can be configured for individual IP addresses, CIDR block ranges, and VCNs.
In which TWO situations can Data Pump be used to migrate to an Autonomous Database?
(Choose all correct answers)
source Database 10g and later
when source is a flat file
when moving a relatively small amount of data
cross endian platforms
source Database 10g and later
cross endian platforms
Which TWO are true about Autonomous JSON Database?
(Choose all correct answers)
They are schemaless.
In a SODA collection, you can have a collection of image documents or a collection that contains both JSON documents and image documents.
You can promote an Autonomous JSON Database service to an Autonomous Data Warehouse service.
There is no storage limit for JSON collections.
They are schemaless.
There is no storage limit for JSON collections.
Which THREE can be used in ADB for authentication to object storage? Which THREE are used by IAM service to authenticate a principal ?
(Choose all correct answers)
Wallet Credentials Resource Principal Username and Password SSH API signing key
Resource Principal
Username and Password
API signing key
Which THREE developer tools come out of the box with Autonomous Database?
(Choose all correct answers)
Oracle REST Data Services Narrative Reports Web Reporting Studio SQL Developer Web APEX
Oracle REST Data Services
SQL Developer Web
APEX
Which TWO Data Guard Replication Modes are available in Autonomous Database Dedicated?
(Choose all correct answers)
Max Protection
Max Availability
Max Performance
Max Synchronization
Max Availability
Max Performance
Which TWO Oracle Cloud Infrastructure console tools can be used to monitor the performance of an autonomous database service instance?
(Choose all correct answers)
OCI Metrics
APEX
Performance Hub
SQL Developer
OCI Metrics
Performance Hub
Which are the THREE pre-requisites to configure a private endpoint with Autonomous Databases (ADBs)?
(Choose all correct answers)
There must be a private subnet with DHCP option.
There must be at least one Network Security Group (NSG) within your VCN.
There must be a Vault Key configured for the ADB.
There must be a Web Application Firewall (WAF) configured within the region.
There must be a VCN within the region of the ADB.
There must be a private subnet with DHCP option.
There must be at least one Network Security Group (NSG) within your VCN.
There must be a VCN within the region of the ADB.
Which can be used to ensure that your Autonomous Database is accessible only from a given set of IPs?
Access Control List
IPSec List
Security List
IP Vault
ACL
Which TWO infrastructure support deployment of Oracle Autonomous Database?
(Choose all correct answers)
Shared Exadata Infrastructure
Virtual Machines on Oracle Cloud Infrastructure
Dedicated Exadata Infrastructure
Oracle Bare Metal Servers
Shared Exadata Infrastructure
Dedicated Exadata Infrastructure
Which is the recommended data loading tool to migrate data from third-party databases?
SQL Loader
SQL Developer Data Import Wizard
SQL Developer Migration Workbench
Oracle Data Pump
Oracle Data Pump
Which chart shows the average number of running SQL statements historically?
Running SQL Statements Response Time Queued Statements SQL statements executed per second Average SQL Statements Which chart shows the average number of running SQL statements historically?
Running SQL Statements
Which TWO statements are TRUE for an Autonomous Database?
(Choose all correct answers)
You must shut down your database before you can increase the storage allocated to it.
You are allowed to increase the storage size, but you cannot decrease it.
If you want to increase the base OCPU count to 150 , you will have to contact Oracle.
Users can access and use the database even when it is in the process of upscaling.
If you want to increase the base OCPU count to 150 , you will have to contact Oracle.
Users can access and use the database even when it is in the process of upscaling.
What is the pre-requisite for taking a manual backup of an Oracle Autonomous Database?
You cannot take manual backups of an Oracle Autonomous Database.
Your database must be stopped.
You must have an Object Storage bucket and your database must be configured to connect to it
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.
Which TWO statements are true about API Signing Key?
(Choose all correct answers)
An RSA key pair in PEM format must have a minimum of 1024 bits.
It is an RSA key pair in PEM format.
It is required when using OCI API in conjunction with SDK/CLI.
It must be generated with a passphrase.
It is an RSA key pair in PEM format.
It is required when using OCI API in conjunction with SDK/CLI.
DBSRV1 is an Autonomous Database with the display name PRODDB. You plan to take manual backup of this database periodically. What must be the name of the bucket that will be used to store manual backups?
backup_proddb
BACKUP_DBSRV1
BACKUP_PRODDB
backup_dbsrv1
backup_dbsrv1
Which feature is available in Autonomous Database Shared but not in Autonomous Database Dedicated?
Java in Database
Data Guard – Active Standby
Oracle Machine Learning (OML) Notebooks
Transparent Application Continuity
Oracle Machine Learning (OML) Notebooks
Which TWO statements are TRUE about patching an Autonomous Database?
(Choose all correct answers)
The database is not accessible to the user during patching.
Oracle patching generally does not take more than two hours.
Oracle patches the database during a scheduled maintenance window.
Users can change the patching schedule.
Oracle patching generally does not take more than two hours.
Oracle patches the database during a scheduled maintenance window.
Which THREE statements are true about Oracle Data Pump?
(Choose all correct answers)
It allows you to specify the level of compression of the export dump file.
It can overwrite an existing dump file during an export operation.
It can perform remapping operations on schemas and data files.
It can export specified views as tables.
It can overwrite an existing dump file during an export operation.
It can perform remapping operations on schemas and data files.
It can export specified views as tables.
Which terminology is used to refer to a communication channel for sending messages to a subscription, such as email or SMS?
Event
Topic
Subject
Notification
Topic
Which TWO are TRUE regarding cloning an Autonomous Database?
(Choose all correct answers)
A refreshable (read-only) clone of the source database can be from its backup. You cannot change the licensing type during cloning. A new autonomous database can be cloned from a live running database instance. The cloned database version can be higher than the source database version.
A new autonomous database can be cloned from a live running database instance.
The cloned database version can be higher than the source database version.
