|Which two actions can be performed from the OCI Console for an Oracle Autonomous Database? Increase Storage allocated for Database Scale up/down CPU Increase Network Bandwidth Scale up/down Memory.
Which statements are true about using Oracle Cloud Infrastructure? (Choose three) It supports only Virtual Machine and Bare Metal DB Systems. It provides high availability and scalability. It provides complete lifecycle automation. It supports only Bare Metal DB Systems. It supports only Exadata systems. It enables you to run everything from small VMs to large bare metal clusters.
Which statements are true about Autonomous Transaction Processing? (Choose two) Data is stored in row format. Complex SQL queries are optimized. Data is stored in columnar format. Missing indexes are detected and created. .
Which statement is true about Autonomous Data Warehouse? Missing indexes are detected and created. Response time is optimized for queries. Data is stored in row format. Data is stored in columnar format.
Which operations are included in automated data center operations? Provisioning a database Patching a database Online backups of a database Automatically handling failures and errors All of the above.
Which statement is true about Autonomous Transaction Processing? It is used for OLTP and mixed workloads. It is used for analytic workloads. Data is stored in columnar format. It is used with data marts and machine learning.
Which are the capabilities of Oracle Autonomous Database that can accelerate innovation? (Choose three) Instant scaling of storage Built-in AI and ML helps find patterns that could identify undiscovered anomalies Scaling of CPUs with very little downtime Provisions a data warehouse in seconds.
Which statements are true about Autonomous Database Cloning? (Choose two) Containing just the data of the source Autonomous Database Containing just the metadata of the source Autonomous Database As a refreshable (read-only) clone of the source Autonomous Database As a refreshable (read-write) clone of the source Autonomous Database.
Which statement is true about Notification Service? It helps you broadcast messages to distributed components using a Exadata-subscribe model. It helps you broadcast messages to distributed components using a private-subscribe model. It helps you broadcast messages to distributed components using a publish-subscribe model. It helps you broadcast messages to distributed components using a hybrid-subscribe model.
Which two are required for Autonomous Database Manual Backups? (Choose two) The name format for the bucket in object storage must follow backup_<databasename> The name format for the bucket in object storage must follow backup#<databasename> The object bucket name must be in lowercase. The object bucket name must be in uppercase.
Which statement is true about moving Autonomous Database Resources? After a resource is moved to a new tenant, inherent policies apply later and affect access to that resource. After a resource is moved to a new compartment, inherent policies apply later and affect access to that resource. After a resource is moved to a new compartment, inherent policies apply immediately and affect access to that resource. After a resource is moved to a new tenant, inherent policies apply immediately and affect access to that resource.
Which three are required for provisioning an Oracle Autonomous Database instance? (Choose three) Number of CPUs Backup Location FRA Size Number of Tablespaces Database Name Workload Type.
At what levels can we implement isolation with Autonomous Database Dedicated Deployment? (Choose three) Region level Subnet Level Container Database level Virtual Cloud Network (VCN) level Database level.
Ideally which of the following tasks will a Fleet Administrator perform? (Choose two) Provision Autonomous Exadata Infrastructure Create IAM users Provision Autonomous Container Databases Manage Autonomous Databases Provision Autonomous Database Instances.
Which levels of access can be defined in the policies? (Choose four) Create Manage Inspect Write Use Read.
Which actions can be performed from the Autonomous Container Database (CDB) details page? (Choose four) Change maintenance schedule Move CDB to a different compartment Stop CDB Stop Autonomous Database Change backup retention policy for CDB Restart CDB.
What are the inputs you provide when creating an Autonomous Exadata Infrastructure resource? (Choose three) VCN Availability Domain Storage Shape.
Which statements are true about OCI Command Line Interface? (Choose two) Is easy to use and lightweight to install Calls OCI REST APIs Does not use REST APIs Runs on Linux operating systems only Is easy to use but involves complex installation and configuration.
Which statements are true about scaling on demand? (Choose two) Independently scale compute or storage. Resizing needs a restart. Resizing occurs instantly, fully online. Compute and storage must be scaled together.
What is the main use case for REST APIs? Monitoring only Monitoring & DevOps DevOps only Monitoring, DevOps, & Development Monitoring & Development.
Which statements are true about REST APIs and RESTful services? (Choose two) RESTful services are complex when compared to traditional XML SOAP communications. REST APIs also use the HTTP communication protocol but mainly use JSON for communication. REST stands for Representational State Transfer. REST APIs only use JSON for communication.
Which of these do you need to enter when you set up the Config File using the OCI setup config command? (Choose three) Location of the config file OCI Region OCID User OCID File format of the config file Tenancy OCID.
Which statements are true about automated tuning? (Choose three) Partitioning not covered under the automated tuning Fast performance out of the box with zero tuning Built-in resource management plans Parallel execution of the queries needs to be monitored manually. Simple web-based monitoring console.
With which of the following does Oracle Machine Learning allow access to data in Autonomous Database? Data Ingestion and Selection only Data Viewing and Discovery and Data Ingestion and Selection Data Ingestion and Selection and Data Viewing and Discovery Data Ingestion and Selection and Data Viewing and Discovery, and Data Analysis.
Which are the prerequisites for connecting to an Autonomous Database using SQL Developer? (Choose three) Service Name Credential Wallet Public Key Private key Listener port number DB username and password DB System Public IP.
Which is true about a workspace in Oracle APEX? It is not associated with any schemas. It can be associated with multiple schemas in the same database. It can be associated only with one schema. It can be associated with multiple schemas from different databases.
Which three actions can be performed by a workspace administrator? (Choose three) Manage workspace to schema assignments. Add space to a schema. Approve workspace requests. Monitor workspace activity. View usage reports for a workspace. Manage user accounts.
Which statements are true about built-in SQL Worksheet and Notebook? (Choose two) Quickly start running queries with built-in web-based notebooks Need to install client query tool for the PL/SQL Based on Apache Tomcat No need to install a client query tool .
Which statement is true about Oracle Text? (Choose two) It supports PDFs only. It renders search result to HTML format only. It combines relational content searching via SQL. It provides full-text content searching.
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? Block Volume File Storage Archive Storage Object Storage.
Which statements are true about Oracle Autonomous JSON Database? (Choose two) It supports MySQL-Style database applications. It supports NoSQL-Style document-centric applications. It allows to store JSON data in the database. It does not support autoscaling.
Which clause is used in Property Graph query language to specify patterns? Like Between Match Distinct.
Which statement is true about Spatial studio? It comes with an Autonomous Database at an additional cost. It is a fully managed service available in OCI. It does not need additional resources. It is a self-service application to create interactive maps.
Which procedure can be used to load data directly into the existing Autonomous Database tables? DBMS_CLOUD.LIST_FILES DBMS_CLOUD.CREATE_EXTERNAL_TABLE DBMS_CLOUD.PUT_OBJECT DBMS_CLOUD.COPY_DATA.
Which methods can be used to migrate an on-prem database to Oracle Autonomous Database? (Choose two) Data Pump GoldenGate Data Guard RMAN.
What is used by Database migration service for migration? Backup Cloud Module GoldenGate replication RMAN Backup Data Guard.
For which cloud services does DBMS_CLOUD provide support for loading data from files to tables in Autonomous Database? (Choose three) OCI Object Storage Azure Blob Storage Amazon AWS S3 Google Cloud Storage.
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 are the TWO prerequisites to migrate a physical database to an autonomous database? (Choose all correct answers) Database must be a PDB. All uses of CDB admin privileges must be removed. Database must not be encrypted. All indexes must be dropped.
In which format is data stored in an Oracle Autonomous Data Warehouse database? Row Format Columnar Format Fast Changing Dimension Format Slow Changing Dimension Format.
Which are the THREE pre-requisites to configure a private endpoint with Autonomous Databases (ADBs)? (Choose all correct answers) There must be a Web Application Firewall (WAF) configured within the region. There must be at least one Network Security Group (NSG) within your VCN. There must be a private subnet with DHCP option. There must be a VCN within the region of the ADB. There must be a Vault Key configured for the ADB.
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 DB User Storage Servers Hypervisors DB servers Encryption Keys.
Which feature is available in Autonomous Database Shared but not in Autonomous Database Dedicated? Data Guard / Active Standby Oracle Machine Learning (OML) Notebooks Java in Database Transparent Application Continuity.
What is the pre-requisite for taking a manual backup of an Oracle Autonomous Database? 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. Your database must be stopped. You cannot take manual backups of an Oracle Autonomous Database.
Who manages the compartment quotas for an Autonomous Database in a dedicated infrastructure? System Administrator Fleet Administrator Database Administrator Service Administrator.
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.
Which chart shows the average number of running SQL statements historically? SQL statements executed per second Running SQL Statements Response Time Queued Statements Average SQL Statements.
Which TWO statements are true about API Signing Key? (Choose all correct answers) It must be generated with a passphrase. 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. .
Which THREE statements are TRUE when provisioning an Autonomous Database? (Choose all correct answers) The provisioned database is fully encrypted. It is deployed on a private software-defined network. The provisioned database automatically masks user data. The provisioned database has a scalable RAC cluster running on Exadata.
You have moved an Autonomous Database from compartment C01 to C02. Which TWO are TRUE? (Choose all correct answers) You need to shut down the database in C01 before you can move it to C02. 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.
Which THREE predefined database service names are available in an Autonomous Data Warehouse? (Choose all correct answers) medium low tpurgent tp high.
Which Autonomous Database Developer tool can be used to build web applications rapidly? Web Reporting Studio Jupyter Notebooks APEX SQL.
Which TWO are TRUE regarding cloning an Autonomous Database? (Choose all correct answers) 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. A refreshable (read-only) clone of the source database can be from its backup. You cannot change the licensing type during cloning.
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 statement is TRUE about auto indexing in an Autonomous Database? 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 provides PL/SQL APIs for configuring automatic indexing in a database and generating reports related to automatic indexing operations. It cannot rebuild indexes that are marked as unusable due to table partitioning maintenance operations.
Which THREE can be used in ADB for authentication to object storage? Which THREE are used by IAM service to authenticate a principal? API signing key Wallet Credentials Resource Principal SSH Username and Password.
Which is the recommended data loading tool to migrate data from third-party databases? SQL Developer Data Import Wizard SQL Loader Oracle Data Pump SQL Developer Migration Workbench.
Which TWO statements are TRUE about patching an Autonomous Database? (Choose all correct answers) Oracle patches the database during a scheduled maintenance window. Oracle patching generally does not take more than two hours. Users can change the patching schedule. The database is not accessible to the user during patching.
Which ROLE is automatically granted to any user created in Autonomous Database? DTPROLE DBROLE DUSERROLE DWROLE.
For which resource consumption will you be charged when your Autonomous Database is stopped temporarily? data security allocated number of OCPUs allocated storage network consumption.
Which TWO tasks are performed by a Fleet Administrator? (Choose all correct answers) Manage Autonomous Databases. Provision Autonomous Database instances. Provision Autonomous Exadata Infrastructure. Create IAM users. Provision Autonomous Container Databases.
Which TWO Data Guard Replication Modes are available in Autonomous Database Dedicated? (Choose all correct answers) Max Protection Max Synchronization Max Availability Max Performance.
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 None Transparent.
In which TWO situations can Data Pump be used to migrate to an Autonomous Database? (Choose all correct answers) when moving a relatively small amount of data cross endian platforms source Database 10g and later when source is a flat file.
Which TWO statements are TRUE about Access Control Lists (ACLs) configured for Autonomous Databases? A database restore overwrites the existing ACLs. 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. Access Control Lists can be configured for autonomous databases only at the time of provisioning.
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 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.
Which TWO statements are TRUE about an Oracle Autonomous Transaction Processing database? (Choose all correct answers) 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. Use data summaries such as storage indexes on the Exadata storage cells to quickly answer the data that is needed in the query.
Which can be used to ensure that your Autonomous Database is accessible only from a given set of IPs? Access Control List IP Vault Security List IPSec List.
Which TWO Oracle Cloud Infrastructure console tools can be used to monitor the performance of an autonomous database service instance? (Choose all correct answers) SQL Developer Performance Hub APEX OCI Metrics.
Which terminology is used to refer to a communication channel for sending messages to a subscription, such as email or SMS? Event Topic Notification Subject.
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','IMPLEMENT'); EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF'); EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY'); .
Which TWO statements are TRUE about Auto Scaling? (Choose all correct answers) If you are provisioning an always-free database, auto scaling is not available. Scaling up automatically expands CPU but not IO resources. Enabling auto scaling also increases the concurrency and parallelism settings for the predefined services. It can be enabled when provisioning an ADB instance or anytime using the Oracle Cloud Infrastructure console.
Which THREE statements are TRUE about private endpoints? (Choose all correct answers) 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 need to set up transit routing in your VCN and use a service gateway to connect.
Which TWO are true about Autonomous JSON Database? (Choose all correct answers) You can promote an Autonomous JSON Database service to an Autonomous Data Warehouse service. 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. There is no storage limit for JSON collections.
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. If you do not perform a refresh within seven days, then REPORTADB will be no longer refreshable. It is possible to create cascading refreshable clones.
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.
Which THREE developer tools come out of the box with Autonomous Database? (Choose all correct answers) Web Reporting Studio Oracle REST Data Services SQL Developer Web APEX.
How many Network Security Groups (NSGs) can you configure for an Autonomous Database? three nine seven five.
Which FOUR levels of access can be defined in policies? (Choose all correct answers) Use Create Inspect Write Manage Read.
Which statement is true about Autonomous Data Guard? After a failover, a new standby for the primary database is automatically provisioned. Autonomous Data Guard is free. The standby database and the primary database are always on different regions. After a failover to the local regions standby database you need to update the URLs for all your tools with the new primary database details.
Which TWO statements are TRUE about Oracle Spatial with Autonomous Database? (Choose all correct answers) Spatial supports the use of JSON and GeoJSON objects. Open Geospatial Consortium Web Services is available in Autonomous Database. 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.
Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure? 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.
Which three tools can be used to monitor the usage and activities of Autonomous Database on Infrastructure? (Choose all correct answers) Performance Hub RMAN oci metrics Enterprise Manager Cloud Control LOGS.
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? Data Load Catalog Data Insights JOSN.
Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose all correct answers) Create a single alarm for each metric. Routinely tune your alarms. Use a single interval for all alarms. Select the correct alarm interval for your metric. Create multiple alarm metrics. Suppress alarms during investigations.
You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do? 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.
Which statement is FALSE about Oracle Autonomous JSON Database? JSON data is stored natively in the database. You can promote Autonomous JSON Database to Autonomous Transaction Processing. It supports NoSQt-style, document-centric applications. There is a 20 GB limit on JSON collections.
While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented? 60 days 15 days 7 days 120 days.
Which is NOT needed to manage Oracle Autonomous Database with REST APIs? Fingerprint of the public key Tenancy's OCID User's OCID Database ADMIN password.
Which three of the following data sources are available when using the Data Load page on Database Actions? (Choose all correct answers) REST endpoints Backup files in block storage Local Files Files in Oracle Cloud Storage Files in AWS S3 Storage.
Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure? Inside the Autonomous Database wallet In a separate key vault external to the Exadata Infrastructure Inside the backups of the container database On the Exadata Infrastructure where Autonomous Database Dedicated Is hosted.
Which three advanced options can you enable or disable while creating a business model? (Choose all correct answers) Analytic View Transparency Views Display private tables Autonomous Aggregate Cache Analytic View Base Table Query Transformation Business Object Security Feature.
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 Bata Load.
What happens with the standby database when disabling Autonomous Data Guard? The standby database is started read/write. The standby database is terminated. The standby database is started read-only. The standby database is transformed in a refreshable clone.
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? Failover is automatically initiated. The standby database is also stopped. The standby database is terminated. Switchover is automatically initiated.
Which statement is FALSE about setting up compartment quotas? Compartment quotas use policies that allow allocation of resources with a high level of flexibility. You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions. Compartment quotas cannot be set on the root compartment. Quotas set on a parent compartment override quotas set on child compartments.
Which option should you use to create a graph with Graph Studio? A graph license key Tables in an Autonomous Database instance Graph created by a special tool downloaded from oracle.com Graph analytics algorithms NoSQL configuration.
Which three are use cases for Graph Studio? (Choose all correct answers) Clustring Facial recognition Churn analysis Pattern matching 3-D modeling.
Which two actions are available to perform when an Autonomous Database is stopped? (Choose all correct answers) Update License Type Update Network Access Change administrator password Start.
When cloning from a backup, what is the earliest timestamp of the backup allowed? 2 hours 1 hour 24 hours 30 minutes.
Which two of the following statements are correct? (Choose all correct answers) All of the capabilities of ODI Classic are available with ODI Web Edition. ODI Web Edition is available only on Oracle Linux. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace. The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.
Which four file formats are supported when loading data from Cloud Storage? (Choose all correct answers) AVRO JSON DOC DDL CSV Parquet.
In which four ways can Oracle Database optimally access data in Object Storage? (Choose all correct answers) Scan avoidance using columnar pruning for .csv files Optimized data archive using hybrid partitioned tables Scan avoidance using columnar pruning for columnar stores like parquet and orc Optimized data archive using partitioned external tables Scan avoidance using partitioned external tables Scan avoidance using block skipping when reading parquet and orc files.
Which statement is true about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure? When you restore a 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 (VCN) but not both at the same time. ACLs can only be used with private endpoints.
Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure? The Autonomous Database must belong to a Network Security Group (NSG). A Private Endpoint is required to connect to the Autonomous Database on shared Exadata 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. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.
A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data. How does the developer connect to and interact with ADB from Python? Using JDBC Driver Using SQL Developer Using the Oracle Client and the cx_Oracle interface.
An Autonomous Database (ADB) user with an instance wallet has left the company. The user had shared a database user ID with other users when accessing ADB. Other than changing the shared user password, what can an administrator do to protect the instance? Delete the user. Trust the user who left to not access the database. Rotate the instance wallet and share the new wallet with the remaining users. Shut down and restart the instance.
Which stage of the indexing pipeline divides text into tokens? FILTER Sectioner LEXER ToxeNrzER.
Which two methods can you use to create database users and grant roles in Autonomous Database services? (Choose all correct answers) SQL Developer The pams_cnoup_apmrn package SQL*Plus The Oracle Cloud Infrastructure service console.
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 Month of the Quarter, Week of the Month, Day of the Week, Start Hour Month of the Year, Week of the Month, Day of the Week, Start Hour Week of the Quarter, Day of the Week, Start Hour.
Which two statements are true about Data Insights? (Choose all correct answers) Data Insights is available with on-premises deployments of Oracle Database You can retrieve previously executed Data Insights searches. Data Insights is an additional priced option. You can search for Data Insights against a base table or business model.
Which native data type is used to store spatial information? spo_GroMeTRY spo_retate Geo_sson spo_nocaTron.
Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases? Only ATP manages optimizer statistics. Only ADW uses columnar compression by default. Only ATP supports automatic backups. Only ADW supports autoscaling.
Which two cloud services are supported to import Data Pump files to Autonomous Infrastructure? (Choose all correct answers) Azure Blob Storage Google Cloud Storage oracle Cloud Infrastructure Object Storage Classic Amazon S3 Oracle Cloud Infrastructure Object Storage.
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose all correct answers) Use oracle Zero Downtime Migration (ZDM). Use GoldenGate. use SFTP to copy CSV files into Autonomous Database. Use Data Pump. Use Recovery Manager.
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources? 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 Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure.
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? Create a database user with the default privileges. Create a REST-enabled database user (with connect and object privileges) and grant the pwRoLE role. 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 two statements are true about accessing Autonomous Database Tools? (Choose all correct answers) SQL Developer Web is available exclusively on the Autonomous Database. Oracle APEX can be accessed only from the Developer menu in the Service Console. 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.
Which three options are available to access data in an Autonomous JSON Database? (Choose all correct answers) Oracle Cloud Infrastructure console using the JSON Online Developer tool Regular Oracle SQL statements using a connection through the listener REST API calls to the database (not enabled by default) Oracle JSON Developer tool downloaded from OTN NoSQL statements using Oracle SODA drivers.
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? 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. Remove any non-JSON data from the database.