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.
