1Z0-931-22 OCI Autonomous DB
Master the 1Z0-931-22 OCI Autonomous DB Quiz
Test your knowledge and skills on Oracle's Autonomous Database with our comprehensive quiz designed for aspiring professionals and database enthusiasts.
- 107 challenging questions
- Covering key features and fun
ctionalities - Multiple choice, checkbox, and scenario-based questions
Which is the recommended data loading tool to migrate data from third-party databases?
SQL Developer Data Import Wizard
SQL Loader
SQL Developer Migration Workbench
Oracle Data Pump
In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?
In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.
In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.
In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.
In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.
Which two system privileges does a user need to create analytic views? (Choose two)
Create analytic view
Create analytic level
Create analytic measure
Create attribute dimension
Create analytic hierarchy
Which is correct about security features that are available in Oracle Autonomous Database?
Data Redaction but not TDE.
Neither Data Redaction nor TDE are supported.
TDE but not Data Redaction.
Data Redaction and TDE are both supported.
Which statement is true about Oracle Text? (Choose two)
It provides full-text content searching.
It supports pdf only.
It combines relational content searching via SQL.
It renders search results to HTML format only.
Which can be used to ensure that your Autonomous Database is accessible only from a given set of IPs?
IPSec List
IP Vault
Access Control List
Security List
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option? (Choose two.)
Current settings for acls are cloned.
All OML notebooks are cloned.
All underlying data for OML notebooks is cloned.
All resource management rules are cloned.
Clones can be in a different region.
You want to move some unstructured data consisting of images and videos to cloud storage. Which Storage would you use and is most cost-effective?
File Storage
Archive Storage
Object Storage
Block Volume
Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?
The Oracle Client Credential file is downloaded as a ZIP file.
You Must have an oracle client credential wallet in order to connect to autonomous database.
The Wallet for the Autonomous Database is same as the TDE wallet
In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the 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_ADMIN.ENABLE_SCHEMA
ORDS_PRIV.ENABLE_SCHEMA
SQLDEV_ADMIN.GRANT_SCHEMA
ORDS_ADMIN.GRANT_SCHEMA
Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?
Import Table
Load data using Data Pump
Create a Data Set
Replicate the table using Golden Gate
Which is true about a workspace in Oracle APEX?
It can be associated with multiple schemas in same database.
It is not associated with any schemas.
It can be associated only with one schema.
It can be associate with multiple schemas with different databases.
With which of the following does Oracle Machine Learning allow access to data in Autonomous Database?
Data Ingestion and Selection only.
None of the above
Data Ingestion and selection and data viewing and discovery and data analysis.
Data Viewing and Discovery and Data Ingestion and Selection.
Which statement is true in regards to database links?
Connect to Autonomous Database from remote database using a database link.
You can call PL/SQL procedures and functions using a database link.
Create a database link from one Autonomous Database to another Autonomous Database instance.
Connect from Autonomous Database to remote database using a database link.
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure Console?
It cannot be done.
Using the cloud infrastructure command line interface or rest api calls
Connecting to the cloud infrastructure console using the ssh wallet.
Using the dbca on the database server
Which two statements are true with regards to Oracle Data Sync? (Choose two)
Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata
Data Sync can use a normal OCI client connection to connect to an oracle database.
Data Sync can connect to any jdbc compatible source like MongoDB, Redshift and Sybase.
Data Sync can load your data in parallel in order to speed up the loading process.
Which TWO Data Guard Replication Modes are available in Autonomous Database Dedicated? (Choose two.)
Max Synchronization
Max Availability
Max Performance
Max Protection
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?
Under Database then Autonomous Transaction processing then autonomous exadata
Under solutions and platforms then platform services then autonomous exadata
Under Core Infrastructure then Autonomous Exadata
Under Core Infrastructure then compute then Autonomous Exadata
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','INVISIBLE');
EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY');
EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','IMPLEMENT');
EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF');
In Graph Studio which you can use to create a graph?
A graph license key
Graph analytics algorithms
NoSQL configuration
Graph created by a special tool downloaded from Oracle.com
Tables in an Autonomous Database instance
What is the default retention period for both Automatic and Manual Autonomous Database Backups?
7 days
One Year
45 days
60 days
Which statement is true regarding database client credentials file required to connect to your Autonomous Database?
The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.
Place the credential files on a share drive that all users can use to connect to the database.
Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.
When you share the credential files with authorized users, mail the wallet password and the file in the same email.
Which statement is NOT correct when setting up compartment quotas?
Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
There are three types of quota policy statements which are set,unset and zero
Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
Compartment quotas are set by oracle.
For Fleet admins to access dedicated exadata infrastructure, which policy should be assigned?
Allow group adb-admins to manage autonomous-database in tenancy where target.workloadType='OLTP'
Allow group adb-admins to manage autonomous-database-family in tenancy
Allow group adb-admins to manage autonomous-database in tenancy where target.workloadType='DW'
Allow group adb-admins to manage autonomous-database in tenancy
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?
Active transactions are paused.
Active transactions are terminated and rolled back.
Active transactions continue running unaffected.
Scaling cannot happen while there are active transactions in the database.
Which are the three pre-requisities for connecting to an Autonomous database using SQL Developer? (Choose Three)
DB Username and Password
DB System Public IP
Credential Wallet
Service Name
Public Key
Listener Port Number
How many Network Security Groups (NSGs) can you configure for an Autonomous Database?
9
7
3
5
Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this. Which statement is true regarding Oracle Data Sync?
Data Sync can not transform your data while loading it into the destination table.
Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
Data Sync can only load data from one source into one destination table.
Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.
What is used by Database Migration Service for migration?
DataGuard
RMAN Backup
Backup Cloud Module
Goldengate Replication
Which statement is true about Spatial studio?
It is a fully managed service available in OCI.
It does not need additional resources.
It comes with Autonomous Database at additional cost
It is a self-service application to create interactive maps
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
ATP and ADW
Autonomous Data Warehouse only
Autonomous Transaction Processing only
Hybrid Columnar Compression
You have moved an Autonomous Database from compartment C01 to C02. Which TWO are TRUE? (Choose two.)
An Autonomous Data Guard for the database is created in C01 post successful migration to C02.
The Automatic Backups are moved to C02, as well.
Any Policy defined on C02 will be immediately applied to the database
You need to shut down the database in C01 before you can move it to C02.
What is the default port number for accessing a newly created Autonomous Database?
1521
1524
1523
1522
Which statement is true when connecting OCI Marketplace image to shared autonomous database?
Compute Image and Shared ADB must be in same VCN and Subnet
ADB must be configured with NSG
ADB must be configured with Private endpoints
Cannot connect OCI Market image to shared ADB
When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?
Scan partition tables
Scan hybrid partition tables
Prun column in parquet files
Prun columns in csv files
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 maintenance?
Release Update (RU)
Prior Release Update Revision (PRUR)
Prior Release Update (PRU)
Quarterly Bundle Patch (QBP)
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 hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well. Which Oracle Cloud Infrastructure database service is appropriate for this scenario?
Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
ADW since operational reporting is a higher priority in this scenario.
It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?
Transparent Data Encryption
Database Vault
Customer Managed Keys
Data Redaction
Audit Vault
Which statement is true when the Autonomous Database has auto scaling enabled?
Database concurrency is scaled up when needed by the workload.
Increases the number of sessions available to the database.
Scales the PGA and SGA size when needed for the workload.
Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.
Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)
RMAN Cross-Platform backup and restore
Golden Gate on-premise installation
PDB unplug / plug operation
Datapump export / import
Dataguard Physical Standby
Golden Gate Cloud service
What are three methods to load data into the Autonomous Database?
Oracle GoldenGate
Transportable Tablespace
RMAN Restore
Oracle Data Pump
SQL*Loader
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 do you need to take?
Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
Create a database user with the default privileges.
Create a database user with connect, resource, and object privileges.
Create an IDCS user. Create a database user with connect, resource, and object privileges.
Which statement is FALSE for Oracle Data Safe? (Choose the best answer.)
Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations
Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user
Oracle Data Safe only supports Autonomous Database
Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?
Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB
Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure
Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB
Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator ->Autonomous Container DB -> Autonomous DB
Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer?
ADMIN
ADBDEV
DWROLE
ADWC
What predefined user is created when provisioning an Autonomous Database (ADB) instance to which you connect to create other users and grant roles?
DWDEV
ADMIN
SCOTT
SYS
Which tab in the Data Load Explore tool shows the size of the table and the number of rows and columns?
Hierarchies tab
Statistics tab
Measures tab
Data Sources tab
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
Backup Retention
Memory Usage
Data Organization
Undo Management
Which index type is designed to index catalog information?
CONTEXT
CTXRULE
CONTRAINS
CTXCAT
Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?
You must first manually create your database credentials using dbms_cloud.create_credential before accesing your Oracle Object Storage Bucket.
Data can be uploaded from several cloud storage sources including S3, Azure, Google Cloud and Oracle Object Storage.
Data formats supported include: text, csv, json, avro and parquet.
Data can be loaded from a local data source
Data can be loaded from a remote database using Database Links (DBLinks).
Which subset of services is offered via OCI-CLI (command line interface) for Autonomous Database (ADB) via calls made to the OCI APIs?
Start, Delete, Update, Query, Stop
Create, Get, List, Stop, Restore
Create, Query, Update, List, Start
Create, Query, List, Stop, Restore
Which of the following two statements regarding Data Transforms are correct?
Data Transforms allow you to design data transformations in the form of data loads, data, flows, and workflows.
Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition.
All capabilities to transform data in ODI Classic are available with ODI Web Edition.
Workflows for data transform is only available on the ODI Web Edition.
What two actions can you do when a refreshable clone passes the refresh time limit?
You can use the instance as a read only database
You can disconnect from the source to make the database a read/write database.
You can extend the refresh time limit
You can manually refresh the clone.
Which are two available options when creating an Autonomous Database?
APEX Service on Shared Infrastructure
Autonomous JSON Database on Shared Infrastructure
Autonomous JSON Database on Dedicated Infrastructure
APEX Service on Dedicated Infrastructure
What is the default time range in Performance Hub?
1 Week
1 Hour
24 Hours
15 Minutes
Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?
Oracle Cloud Infrastructure Vault, Oracle Database Vault.
Oracle Database Vault, Oracle Key Vault.
Oracle Audit Vault, Oracle Key Vault.
Oracle Key Vault, Oracle Cloud Infrastructure Vault.
Which option describes the connection types that third-party software an use to connect to an Autonomous Database (ADB)?
JDBC only
New ADB-specific protocols
Any protocol supported by Oracle Net Services
SQL*NET only
Your company has a .NET application and wants to deploy it on Autonomous Database (ADB). What software is used to connect to ADB from the .NET application?
You cannot use .NET with ADB
Java
SQL*Plus
Oracle Data Access Components for Windows.
Which two objects are imported when using Data Pump to migrate your Oracle database Autonomous Database?
Data
Report
Schemas
Tablespaces
Who, and in which order, provisions dedicated Exadata Infrastructure resources?
The database administrator provisions the Autonomous Container DB and the Autonomous DB. Then, the fleet administrator provisions the Autonomous Exadata Infrastructure.
The Fleet administrator provisions the Autonomous Exadata Infrastructure. Then, The database administrator provisions the Autonomous Container DB and then the Autonomous DB.
The database administrator provisions the Autonomous Exadata Infrastructure. Then, The Fleet administrator provisions the Autonomous Container DB and then the Autonomous DB. •
The Fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB and then, the database administrator provisions the Autonomous DB.
As a database architect you are tasked with configuring a high concurrency, production OLTP (EXAM) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode. Which connection service is appropriate for such a workload?
TP
TPURGENT
MEDIUM
HIGH
Which file is NOT a component of the client credentials wallet used to connect to an Oracle Autonomous Database?
Cwallet.sso
Sqlnet.ora
Trustore.jks
Keystore.jks
Ewallet.p12
Protocol.ora
Which three operations are available for a quarterly maintenance update on Autonomous Container Database?
Reschedule patching
Reschedule and patch immediately.
Apply a partial patch.
Patch immediately.
Skip patching.
Which two actions can you perform with Autonomous Data Guard enabled on Autonomous Database on Shared Infrastructure?
Switchover
View Apply Lag
Reinstate
Failover
Change Protection Mode
Which statement is FALSE about Data Insights?
Data Insights provides a wide range of graphical data presentation capabilities.
The results of the Insight analysis appear as a series of bar charts in the Data Insights dashboard.
Data Insights display information about patterns and anormalles in the data of entities in your Oracle Autonnomous Database.
Data Insight are automatically generated by varios analytic functions built into the database
Which are the two restrictions for and Always free Autonomous Database?
Oracle Application Express (APEX) not included
Supports only ATP as a workload type
Maximum of two Always Free Database per OCI tenancy
Maximum of one OCUP per Database
How can you keep Autonomous Database tables in sync with an on-premises data source?
Use THE ords package on the Data Load page
Use the FEED DATA option on the Data Load page
Use the Cloud Locations card on the Data Load page
Use the Link Data option on the Data Load page.
Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endponits with security rules to allow incoming and outgoing traffic to and form the Autonomous Database instance?
The destination port range is set to 1522.
The source is set to the address range you want to allow to connect to your database.
The IP Protocol is set to TCP.
A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance.
You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling?
Click Scale Up/Down and select the Auto Scaling checkbox.
Shut down the Instance, click Scale Scale Up/Down and select the Auto Scaling checkbox, then restart the Instance.
Use a Rest call to enable Auto Scaling.
Use a Rest call to Shut down the Instance, Then a second Rest call to enable Auto Scalling, and a REST call to restart the instance.
Which of the following is not required for connecting to ADB via SQLDeveloper?
Connection Name
Username
Password
Service
Database name
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 nonpeak hours. The architecture team is debating whether such reports should be run on the online transaction processing (OLTP) database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well. Which Oracle Cloud Infrastructure database service is appropriate for this scenario?
Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority In this scenario.
The application should be deployed on a Kubernetes Cluster because it needs to be highly available.
Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types.
It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
Which two cloud services allow you to import Data Pump files to an Autonomous Database on Dedicated Infrastructure?
Oracle Cloud Infrastructure Object Storage
Amazon S3
Azure Blob Storage
Oracle Cloud Infrastructure Object Storage Classic
Google Cloud Storage
Which workload is particularly suited to Oracle Autonomous JSON Database?
Transactions
Data Lakes
Schemaless, document centric
Data Marts
Which three functions are provided by Spatial Studio?
Map visualization
Custom SQL queries
Spatial data editing
Spatial analysis
Geocoding
Which two statements apply to the Autonomous Database service on Dedicated Infrastructure?
You, as the customer, are responsible for all patching operations.
Patching occurs on the first Sunday of each quarter.
You can set mantenance windows for each individual Autonomous Container Database.
You can set mantenance windows for an Autonomous Exadata Infrastructure.
Which two statements are true about Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for Autonomous Data Guard?
RTO and RPO are 0 minutes for manual failovers.
RPO is adjustable, but RTO is always 5 minutes.
RPO is 0 minutes for an automatic failover.
RTO and RPO are adjustable through the OCI console.
RTO is 2 minutes for an automatic failover.
Users connect to Autonomous Data Warehouse by using one of the following consumer groups: High, (EXAM) Medium, and Low.?
High provides highest concurrency and lowest resources, and Dop is 1.
Low provides highest concurrency and lowest resources, and Dop is 1.
Medium provides intermediate resource and concurrency, and queries run serially.
High provides highest resource and lowest concurrency, and Degree od parallelism (DoP) is 1.
Which statement is FALSE about the Catalog tool?
You can delete an entity from the autonomous Database via the Catalog tool.
You can view the data definition of an entity.
Impact shows the entities that depend on the source.
You can limit the display of entities to only those with certain names, schemas, types, or applications by entering values in the Search field.
What are three characteristics of Data Lake data captured in Object Storage?
High concurrency
High transaction performance
Multiple subject areas
Mixed data types
Schema on read
Which is a feature of a graph query language?
Scripting language
Run key-value queries
Object-oriented language
Ability to specify patterns
When you are increasing the number of OCPUs in your Autonomous Database, what does its status show?
SCALING IN PROGRESS
UPSCALE IN PROGRESS
UPLIFT IN PROGRESS
RESIZING IN PROGRESS
Which Oracle Package is used to load data to an ADB from object storage?
DBMS_LOAD
DBMS_CLOUD
DBMS_MIGRATE
DBMS_RPC
Which terminology is used to refer to a communication channel for sending messages to a subscription, such as email or SMS?
Event
Topic
Notiificaiton
Subject
Whuch two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)
An OCI region is a localized geographic area and an availability domain is one or more data centers located within a region.
Because availability domains do not share infrastructure such as power or cooling or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.
A single fault domain can be associated with multiple regions and availability domains.
Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.
Which statement is true about OCPUs and storage when you choose to scale your Autonomous Database?
Use auto scaling to increase storage
OCPUs and storage can be scaled independently.
OCPUs and storage must remain in sync.
Increasing OCPUs will automatically increase storage.
Which two statements are true regarding active transactions when scaling OCPUs in ab Autononmous Database?
Scaling can happen while there are active transactions in the database.
Active transactions are paused.
Active transactions are terminated and rolled back.
Active transactions continue running unaffected.
Which TWO infrastructure support deployment of Oracle Autonomous Database? (Choose all correct answers)
Dedicated Exadata Infrastructure
Virtual Machines on Oracle Cloud Infrastructure
Shared Exadata Infrastructure
Oracle Bare Metal Servers
Which command can you use to create an Autonomous Database?
POST /20160918/createautonomousDatabases
POST /20160918/autonomousDatabases
POST /20160918/createDatabases
POST /20160918/createADB
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_DBSRV1
BACKUP_PRODDB
Backup_proddb
Backup_dbsrv1
Which is an Autonomous Database critical event?
NewMaintenanceSchedule
ScheduleMaintenanceWarning
DatabaseConnection
MaintenanceBegin
AdminPasswordWarning
Which statement is true when the Autonomous Database has auto scaling enabled?
Database concurrency is scaled up when needed by the workload.
Scales the PGA and SGA size when needed for the workload.
It enables the database to use up to 3x OCPU/IO resources immediately when needed by the workload.
It Increases the number of sessions available to the database.
What can you do with graphs? (Choose two.)
Facial recognition
Product recommendations
3-D modeling
Find patterns that are anomalous and use that to detect fraud.
On which two infrastructure classes can the Autonomous Database service be deployed?
Dedicated Exadata Infrastructure
Oracle Cloud Infrastructure Virtual Machines
Shared Exadata Infrastructure
Exadata Cloud Service
Which two statements are true for Spatial Studio?
It is a free app on the OCI Marketplace.
It is a self service no-code web tool for Spatial.
It is a developer IDE for Spatial.
It is a managed OCI service.
Which privilege is NOT included in the DWROLE role?
ALTER SESSION
CREATE ANALYTIC VIEW
READ. WRITE ON directory DATA_RUMP_D1R
UNLIMITED TABLESPACE
Which three options are supported when migrating to Autonomous Database (ADB)?
PDB unplug / plug operation
Golden Gate Cloud service
Data Pump export / import
RMAN Cross-Platform backup and restore
Data Guard Physical Standby
Golden Gate on-premises installation
Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?
Maximum Protection
Maximum Performance
Maximum Continuity
Maximum Availability
Which statement is FALSE about Autonomous Data Guard on Autonomous Database on Dedicated Infrastructure?
Switchover, Failover, and Reinstate operations can be initiated by a user.
Autonomous Data Guard is enabled at the Container database level.
The standby database is available for read-only workloads.
A standby database can be on the same Exadata machine as the primary database.
Which two are ways Oracle Database can optimally access data in Object Storage?
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 partitioned external tables
Which two of the following data sources are available when using the Data Load page on Database Actions?
Backup files in block storage
REST endpoints
Files in Oracle Cloud Storage
Local Files
Which three options do NOT change when enabling auto scaling?
Amount of storage
I/O resources
Level of concurrency
Parallelism settings
Number of OCPUs displayed in the console
Which three statements are true about changing license options in Oracle Autonomous Database?
You can upgrade from an Always Free Autonomous Database account to a paid account any time.
You cannot update the License Included option to BYOL after the Database has been created
You cannot update your BYOL to License Included after the Database has been created.
You can update the License Included option to BYOL after the Database has been created.
You can update your Bring Your Own License (BYOL) to License Included after the Database has been created.
Which statement is FALSE about Oracle Text?
It uses standard SQL queries
It requires an Oracle Text license for Autonomous Database.
It is suited to search document collections.
It provides indexing, word and theme searches.
Which four resources need to be provisioned by the fleet administrator and the database administrator before a developer can connect to an Autonomous Database on Dedicated Infrastructure as a database user?
Oracle Database licenses
Autonomous Database instance
Identity and Access Management (IAM) policy rules that allow access to the database
Autonomous Container Database
Virtual Cloud Network and Subnet
Autonomous Exadata Infrastructure
Network Security Group(s)
Which option is not available to access data in an Autonomous JSON Database?
Regular Oracle SQL statements using a connection string to the database.
NoSQL statements using Simple Oracle Document Access (SODA) drivers
Oracle Cloud Infrastructure console using the JSON Developer tool.
REST API calls to the database.
{"name":"1Z0-931-22 OCI Autonomous DB", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge and skills on Oracle's Autonomous Database with our comprehensive quiz designed for aspiring professionals and database enthusiasts.107 challenging questionsCovering key features and functionalitiesMultiple choice, checkbox, and scenario-based questions","img":"https:/images/course4.png"}
More Quizzes
Sustav za upravljanje bazom podataka (34. - 70.)
371866
Oracle Database
10527
Big Data Analytics Quiz 1
10511
Analytics: deep dive session
6317
Singlestore quiz-booth 42
5260
MYSQL
1050
SQL QUIZ
1586
Apache Cassandra Quiz
9438
DBA LEVEL III COC EXAM: PREPARED BY TECHNIFY TUTOR
1050
Database Fundamentals Quiz
351829
Assessment on Hadoop Fundamentals and MapReduce
1050
DATABSE SYSTEM CONCEPTS QUIZ
361829