CREATE TEST

ERASED TEST, YOU MAY BE INTERESTED ON 1Z0-931-24

COMMENTS	STATISTICS	RECORDS

TAKE THE TEST

Title of test: 1Z0-931-24 Description: Oracle Autonomous Database Cloud 2024 Professional Author: oracle Other tests from this author Creation Date: 05/03/2025 Category: Computers Number of questions: 181

Share the Test:

New Comment

No comments about this test.

Content:

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. What is the correct way to list all files in the default data pump directory? By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR'); You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW). Log onto ADW server and issue is -al on the command line. By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ' ) ;. What REST verb is used to create an Autonomous Database service using REST APIs? An "INSERT" REST call A "GET" REST call A "POST" REST call A "PUT" REST call. When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported? Data Schemas Tablespaces Reports. What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? Users have OS access to the database machine. Users can customize the maintenance schedule. It offers greater control and isolation starting at the Exadata cloud infrastructure level. Users have SYS privileges in the database. Users can customize the OS stack and add additional packages. What is the default port number for accessing a newly created Autonomous Database? 1524 1522 1521 1523 1526. Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.) The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files 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 on Autonomous Data Warehouse. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous 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. 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? Create an IDCS user with the APEX role. Access the APEX Administration Services and create the workspace for the developer. Create a new developer account. Create a database user with the APEX role. 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 administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources. Fleet Administrators are responsible for patching and backups of all container databases. Fleet Administrators create, monitor and manage Autonomous Databases. 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. 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. While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads? Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations. Autonomous Data Warehouse workloads are optimized for mixed workloads. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar. 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 'None’d. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day. You cannot permanently disable scheduled Automatic Maintenance. Change the Automatic Maintenance Schedule to 'No Preference'. Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint? Network Security Group Security List VCN Route Table Subnet. Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option? Current settings for ACLs are cloned. Clone can be in a different region. All OML notebooks are cloned. All underlying data for OML notebooks is cloned. All resource management rules are cloned. Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database? The Autonomous Database must be in the same VCN and Subnet as the Compute instance. The OCI compute instance does not support connecting to a Shared Autonomous Database. The Autonomous Database must belong to a Network Security Group (NSG). The OCI compute instance can be used with an Always-Free Autonomous Database account. A Private Endpoint is required to connect to the Shared-Autonomous Database. 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 management operation is correct about Autonomous Databases on shared Exadata infrastructure? You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure. 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 of an Autonomous Database is restarted separately while the remaining nodes continue to be available. Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure? Admin page of the Cloud Service Console OCI CLI OS command line from the database server. SQLDeveloper. 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? TPURGENT TP MEDIUM LOW. Which workload type does the Autonomous Database on dedicated infrastructure service currently support? Autonomous Transaction Processing only ATP and ADW Autonomous Data Warehouse only Hybrid Columnar compression. During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure? the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator the Client Credentials wallet which is used to connect to the Autonomous Database the 'High Availability Container Database' in which the Autonomous instance should run the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment the Listener endpoint where the Autonomous Database should register on. 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? SQL Developer JAVA JDK You can't use Python with ADB. The Oracle Client and the cx_Oracle interface for Python. Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU 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? For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands. The base number of OCPU cores allocated to a database is not guaranteed. 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. Auto scaling is enabled by default and can be enabled or disabled at any time. Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? Parallelism is not enabled by default. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default. Oracle Database Result Cache is enabled by default for all SQL statements. You have direct access to the database node. 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). An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB. Other than changing the shared user password, what can the admin do to protect the instance? Trust the user who left to not access the database. Shutdown and restart the instance. Rotate the instance wallet and share the new wallet with the remaining users. Delete the user. Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints. You can configure Private Endpoints for an Always Free Autonomous Database. Which two options are available to restore an Autonomous Data Warehouse? (Choose two.) Backup and recovery must be done using Recovery Manager(RMAN). Select the snapshot of the backup. Select the archived redo logs. Select the backup from which restore needs to be done. Specify the point in time (timestamp) to restore. You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements: • Autonomous Transaction Processing • License Included • Shared Infrastructure Which parameter would you NOT use? db-workload is-dedicated db-type license-model. Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance? TPPERFORMANT MEDIUM HIGH LOW TPURGENT. Which two are correct actions to take in order to Download the Autonomous Database Credentials? Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet). Which three event types are supported for Autonomous Database? Terminate End Maintenance Begin Change Compartment Begin Change Autoscaling Configuration Compartment Update IORM Begin. What are three methods to load data into the Autonomous Database? Oracle GoldenGate Transportable Tablespace RMAN Restore Oracle Data Pump SQL*Loader. Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database? Exadata Active Data Guard RAC, but only when scaling beyond 16 OCPUs Transparent Data Encryption Multitenant. The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources? Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator, Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure. Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse? Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused. You can use the dbms_auto_index package to report on the automatic task and to set your preferences. It is enabled by default. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints. The indexing feature is implemented as an automatic task that runs at a fixed interval. How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console? It cannot be done. Using Database Configuration Assistant (DBCA) on the database server. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls. Connecting to the Cloud Infrastructure Command console via SSH wallet. When enabling auto-scaling, which three options do not change? Number of OCPUs displayed in the console. Amount of storage I/O resources parallelism settings Level of concurrency. Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure? If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching. Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production. How should the customer unplug their database to migrate to Autonomous Database (ADB)? Pluggable databases cannot be migrated to ADB using plug, unplug or clone. Create a database link from source database to the ADB environment and clone the PDB. Unplug to an xml file so database files and xml file can be uploaded to object storage. Unplug into a pdb archive which can be uploaded to object storage. 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 = ‘DW’ Allow group ADB-Admins to manage autonomous-database in tenancy. Allow group ADB-Admins to manage autonomous-database-family in tenancy. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'. When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean? The SQL statement completed its execution. The SQL statement is executing. The SQL statement is queued. The SQL statement did not complete either due to an error. When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata? Under Core Infrastructure then Compute then Autonomous Exadata Under Solutions and Platform then Platform Services then Autonomous Exadata Under Database then Autonomous Transaction Processing then Autonomous Exadata Under Core Infrastructure then Autonomous Exadata. Which statement is NOT correct when setting up compartment quotas? There are three types of quota policy statements which are set, unset and zero. Compartment quotas use policies that allow allocation of resources with a high level of flexibility. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending. Compartment quotas are set by Oracle. Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment? Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments. Moving an Autonomous Database instance does not include its automatic backups. You do not need to have sufficient access permissions on the compartment that the resource is being moved to. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure. 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? 900 1800 2700 1500. Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements. Which statement is FALSE? Oracle Data Safe only supports Autonomous Databases. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user. According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups. Which statement is true? 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 resource. Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.) The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully. The target table will be created in Autonomous Database if it does not already exist. For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access? SQLDEV_ADMIN.GRANT_SCHEMA ORDS_ADMIN.ENABLE_SCHEMA ORDS_ADMIN.GRANT_SCHEMA ORDS_PRIV.ENABLE_SCHEMA. Which statement is true when you provision an Autonomous Database using the cloning method? After an Autonomous database is created using a clone, the network access option can be changed. A clone database source can be a running database instance. A clone database source can be from a point-in-time backup that is less than 2 hours old. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database. Which statement is correct about managing and monitoring of Autonomous Database? You can use Service console to move Autonomous DB between compartments. 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. You can use Service console to manage runaway SQL statements on Autonomous DB. Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure? Data Pump Export File Avro Parquet Text JSON Microsoft SQL Server (.mdf). How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure? Execute alter database for user MTHEO tablespace DATA quota = 10G; Execute alter user MTHEO quota unlimited on tablespace DATA; Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace quota => "UNLIMITED*); Execute alter tablespace DATA set quota = 10G;. Which three security features are available in Oracle Autonomous Database Shared Infrastructure? Transparent Data Encryption Database Vault Customer Managed Keys Data Redaction Audit Vault. Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls? On the Autonomous Database Console. SSH keys are not required in Oracle Cloud Infrastructure. SSH keys cannot be added from console. They have to be added using REST APIs only. Navigate to Identity, select Users panel on the console and select "Add Public Key". In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization? Oracle Machine Learning notebook Compartment quotas Resource Manager settings SQL Developer Web Console. What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure? alter database set application_continuity=true alter session set application_continuity=true exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ; alter system set application_continuity=true. Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.) through the Oracle Cloud Infrastructure service console through SQL/Developer s using DBMS_CLOUD_ADMIN package through SQLPIus. When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.) DBNAME_MEDIUM DBNAME_HIGH DBNAME_CONCURRENT DBNAME_LOW. Which can be Scaled Independently of the number of CPUs In an Autonomous Database? Parallelism Storage Concurency Memory Sessions. 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. Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? Undo Management Index Storage Memory Usage Data Organization Backup Retention. Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.) Oracle Cloud Infrastructure Object Storage Google Cloud Storage Amazon S3 Azure Blob Storage Oracle Cloud Infrastructure Object Storage Classic. Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database. 120 60 15 7. 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. A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst. When restoring/cloning the ADB, you must select a backup which is atleast hours/minutes old. 24 hrs 2 hrs 5 min 1 day. 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. Which three are use cases for Graph Studio? (Choose three.) 3-D modelling Churn analysis Pattern matching Facial recognition Clustering. What happened with the standby database when disabling Autonomous Data Guard? The standby database is started readwrite The standby database is transformed in a refreshable clone The standby database is terminated The standby database is started read only. 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 NoSQL-style, document-centric application There is a 20 GB limit on JSON collection. Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure? Oracle Cloud Infrastructure Object Storage Google Cloud Storage Amazon S3 Oracle Cloud Infrastructure Object Storage Classic. Which statement is not correct when the Autonomous Database is stopped? In-flight transactions queries are stopped Tools are no longer able to connect to a stopped instance User with DWROLE can still access the database CPU billing is halted. Which statement is correct about the Service console in an Autonomous Database? You can use Service console to enable or disable auto scaling of Autonomous DB You can use Service console to manage runaway SQL statements on Autonomous DB You can use Service console to move Autonomous DB between compartments You can use Service console to create manual backups of Autonomous database. Which Autonomous Database Cloud service ignores hints in SQL Statements by default? Autonomous Transaction Processing Autonomous Data Warehouse Neither service ignores hints by default Both services ignore hints by default. Which Database Actions tool is used to get information about the entries on your Oracle Autonomous Database and to see the effect that changing an object has on other objects. Data Load Catalog JSON Data Insight. 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 Databases Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary. Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated? Week of the Quarter, Day of the Week, Start Hour Month of the Year, Week of the Month, Day of the Week, Start Hour 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. You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance. Which tool would you use to automate data exploration and create pivot tables? Business Models Data Load SQL Developer Web APEX. When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database? 2 hours 30 minutes 1 hours 24 hours. In Graph Studio which you can use to create a graph? A graph license key Tables in an Autonomous Database instance NoSQL configuration Graph analytics algorithms Graph created by a special tool downloaded from Oracle.com. While creating a business model what advanced options you can enable or disable? (Choose three) Business Object Security Feature Analytic View Transparency View Autonomous Aggregate Cache Display private tables Analytic View Base Table Query Transformation. You need to set up 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 rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END" Create a notification alert using DBMS_SNMP package Create an Oracle Cloud Infrastructure Alarm for Shutdown metric. Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.) Use SFTP to copy CSV files into Autonomous Database Use Oracle Zero Downtime Migration (ZDM) Use Recovery Manager (RMAN) Use GoldenGate Use Data Pump. Which two actions are available to perform when an Autonomous Database is stopped? Start Update Network Access Change administrator password Update License Type. In which four ways can Oracle Database optimally access data in Object Storage? optimized data archive using partitioned external tables optimized data archive using hybrid partitioned tables scan avoidance using block skipping when reading parquet and ore files scan avoidance using columnar pruning for columnar stores like parquet and orc scan avoidance using partitioned external tables scan avoidance using columnar pruning for .csv files. Which two statements are true about accessing Autonomous Database Tools? Access to Database Actions is available for all users of Autonomous Database. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database. SQL Developer Web is available exclusively on the Autonomous 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. Oracle APEX can be accessed only from the Developer menu in the Service Console. Which two options are available to restore an Oracle Autonomous Database? Select the backup from which restore needs to be done. Specify the point in time (timestamp) to restore. Select the snapshot of the backup. Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up. Specify the archived custom image. Which statement is FALSE about Oracle Data Safe? It supports only Autonomous Databases. It helps you assess the security of your cloud database configurations by analyzing database configurations. It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary. It evaluates user types, how users are authenticated, and the password policies assigned to each user. It helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements. Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure? IOPS, Storage Space Used By Tablespace, Apply and Transport Lag CPU Utilization, Storage Utilization Query Latency, User Calls, Execute Count Transaction Count, Sessions, Running Statements. Which three options are available to access data in an Autonomous JSON Database? Oracle Cloud Infrastructure console using the JSON Online Developer tool Oracle JSON Developer tool downloaded from OTN NOSQL statements using Oracle SODA drivers REST API calls to the database (not enabled by default) Regular Oracle SQL statements using a connection through the listener. 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 DBMS_CLOUD.INCREASE_THROUGHPUT procedure. Remove any non-JSON data from the database. Increase the number of OCPUs allocated to the database. Ask Support to migrate their setup to a node without noisy neighbors. 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. Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure? inside the Autonomous Database wallet inside the backups of the container database In a separate key vault external to the Exadata Infrastructure on the Exadata Infrastructure where Autonomous Database Dedicated is hosted. Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases? Only ATP manages optimizer statistics. Only ATP supports automatic backups. Only ADW uses columnar compression by default. Only ADW supports autoscaling. 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. ACLs can only be used with private endpoints. An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time. Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure? Oracle Cloud Infrastructure Object Storage Classic Oracle Cloud Infrastructure Object Storage Google Cloud Storage Amazon S3 Azure Blob Storage. Which two statements are true about Data Insights? You can retrieve previously executed Data Insights searches. Data Insights is available with on-premises deployments of Oracle Database. Data Insights is an additional priced option. You can search for Data Insights against a base table or business model. Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure? RMAN Logs OCI Metrics Performance Hub Enterprise Manager Cloud Control. 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? The standby database is terminated. The standby database is also stopped. Switchover is automatically initiated. Failover is automatically initiated. Which four file formats are supported when loading data from Cloud Storage? DOC AVRO JSON DDL Dcsv Parquet. Which native data type is used to store spatial information? SDO_RELATE SDO_GEOMETRY SDO_LOCATION GEO_JSON. Which three are Oracle-recommended best practices for Autonomous Database alarms? Suppress alarms during investigations. Create multiple alarm metrics. Create a single alarm for each metric. Select the correct alarm interval for your metric. Routinely tune your alarms. Use a single interval for all alarms. Which option should you use to create a graph with Graph Studio? A graph license key NoSQL configuration Graph created by a special tool downloaded from oracle.com Graph analytics algorithms Tables in an Autonomous Database instance. Which is NOT needed to manage Oracle Autonomous Database with REST APIS? User's OCID Tenancy's OCID Database ADMIN password Fingerprint of the public key. While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented? 60 days 7 days 15 days 120 days. Which two methods can you use to create database users and grant roles in Autonomous Database services? the Oracle Cloud Infrastructure A. service console SQL Developer the DBMS_CLOUD_ADMIN package SQL *Plus. Which stage of the indexing pipeline divides text into tokens? SECTIONER FILTER Otokenizer LEXER. Which three of the following data sources are available when using the Data Load page on Database Actions? Files in Oracle Cloud Storage Backup files in block storage Local Files Files in AWS S3 Storage REST endpoints. Which statement is FALSE about setting up compartment quotas? Quotas set on a parent compartment override quotas set on child compartments. Compartment quotas cannot be set on the root compartment. 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. 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 marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure. The marketplace OCI image can be used with an Always Free Autonomous Database account. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image. Which two of the following statements are correct? 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. All of the capabilities of ODI Classic are available with ODI Web Edition,. Which two actions can be performed when an Autonomous Database is stopped? Start Update License Type Update Network Access Change Administrator Password. Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer? ADMIN ADBDEV ADWC DWROLE. Which is a feature of a graph query language? Scripting language Run key-value queries Object-oriented language Ability to specify patterns. What are the two supported infrastructure options for deploying an Autonomous Database? VM on Oracle Cloud Infrastructure Dedicated Exadata Infrastructure Any Oracle Engineered System Shared Exadata Infrastructure Bare-metal on Oracle Cloud Infrastructure. Which two statements are true about Oracle Cloud Infrastructure (OCI)? An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region A single fault domain can be associated with multiple regions and availability domains Regions are dependent on other regions and must be located within five thousand kilometers of each other 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 u likely to impact the availability of the there within the same region. 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 dms_cloud.create_credentia before accessing your Oracle Object Storage Bucket Data can be loaded from a remote database using Database Links (DBLinks) Data can be loaded from a local data source Data can be uploaded from several cloud storage sources including 53, Azure, Google Cloud and Oracle Object Storage Data formats supported include: text, csv, json, avro and parquet. 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 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 Scaling, and a REST all to restart the instance Shut down the instance, click Scale Up/Down and select the Auto Scaling checkbox, then restart the instance. 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 Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types The application should be deployed on a Kubernetes Cluster because it needs to be highly available It is best to build a separate data warehouse, and move the OLTP data on a nightly basis Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority in this scenario. Which two statements are true regarding active transactions when scaling OCPUs in an Autonomous Database? Active transactions in Autonomous Data Warehouse are paused Active transactions continue running unaffected Active transactions are paused Active transactions are terminated and rolled back Scaling can happen while there are active transactions in the database. Which three operations are available for a quarterly maintenance update on Autonomous Container Database? Reschedule patching Skip patching Apply a partial patch Patch immediately Reschedule and patch immediately. Your customer wants to permanently disable scheduled maintenance on the Autonomous Database on Dedicated Infrastructure to keep their current database version(s). How can they achieve this? Change the Automatic Maintenance Schedule to "No Preference" You cannot permanently disable scheduled automatic maintenance Change the Automatic Maintenance Schedule to "None" Change the Automatic Maintenance Schedule to "Specify a Schedule," but do not select any ^ month, week, or day. Which two statements are true about Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for Autonomous Data Guard? RPO is adjustable, but RTO I always 5 minutes RTO and RPO are adjustable through the OCI console RTO and RPO are 0 minutes for manual failovers RTO is 2 minutes for an automatic failover RPO is 0 minutes for an automatic failover. What infrastructure does the Autonomous Database run on? VM on Oracle Cloud Infrastructure Bare-metal on Oracle Cloud Infrastructure Exadata on Oracle Cloud Infrastructure Any Oracle Engineered system. On which two infrastructure classes can the Autonomous Database service be deployed? Shared Exadata Infrastructure Dedicated Exadata Infrastructure Exadata Cloud Service Oracle Cloud Infrastructure Virtual Machines. You are the admin user of an Autonomous Database instance. A new business analyst has joined the team and could like to explore the Autonomous Database tables using Autonomous Database's Data Tools. Which step should you to perform to enable the new team member? 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 Create a REST-enabled database user (with connect and object privileges) and grant the U DWROLE role. Which three advanced options can you enable or disable while creating a business model? Analytic View Base Table Query Transformation Analytic View Transparency Views Autonomous Aggregate Cache Business Object Security Feature Display Private Tables. Which option is not available to access data in an Autonomous JSON Database? Regular Oracle SQL statements using a connection string to the database Oracle Cloud Infrastructure console using the JSON Developer tool REST API calls to the database NoSQL statements using Simple Oracle Document Access (SODA) drivers . Which two are ways Oracle Database can optimally access data in Object Storage? Optimized data archive using hybrid partitioned tables Optimized data archive using partitioned external tables Scan avoidance using partitioned external tables Scan avoidance using columnar pruning for .csv files. Which two statements are true about using an Oracle Autonomous Database with private endpoints? Private endpoints can be configured when you clone an Autonomous Database on Shared Infrastructure 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) A Network Security Group (NSG) is required within your virtual cloud network before you can provision a Shared Autonomous Database to use private endpoints You can configure private endpoints for an Always Free Autonomous Database. When an administrator rotates the instance wallet for an Autonomous Database on Shared Infrastructure, what happens to the regional wallets used with that instance? They continue to work They revert to pending They are also rotated They become invalid. As a database architect, you are tasked with configuring a high concurrency, production OLTP (online transaction processing) 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? MEDIUM HIGH TP TPURGENT. Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure? Autonomous Exadata infrastructure maintenance takes place at least once each quarter Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and includes container database patching You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedules the container database maintenance for the following quarter. Which statement is FALSE about Data Insights? Data Insights displays information about patterns and anomalies in the data of entities in your Oracle Autonomous Database The results of the insight analysis appear as a series of bar charts in the Data Insights dashboard Data insights are automatically generated by various analytic functions built into the database Data Insights provides a wide range of graphical data presentation capabilities. Which three are Oracle-recommended best practices for Autonomous Database alarms? Create a single alarm for each metric Suppress alarms during investigations Tune your alarms routinely Select the correct alarm interval for your metric Use a single interval for all alarms Create multiple alarm metrics. What is the number of concurrent statements that can be handled by the medium database service name? 1-25 X OCPU OS unlimited 20 X OCPU. Which option describes the connection type that third-party software can use to connect to an Autonomous Database (ADB)? JDBC only SQL*Net only new ADB-specific protocols any protocol supported by Oracle Net Services. Which DBMS_WORKLOAD_REPOSITORY subprogram procedure can be used to modify the default eight day retention period for Autonomous Database performance data? MODIFY_BACELINE_WINDOW_SIZE UPDATE_OBJECT_INFO CREATE_BASELINE_TEMPLATE MODIFY_SNAPSHOT_SETTINGS. Which statement is true about OCPUs and storage when you choose to scale your Autonomous Database? Increasing OCPUs will automatically increase storage OCPUs and storage must remain in sync OCPUs and storage can be scaled independently Use auto scaling to increase storage. 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? Data Insights JSON Catalog Data Load. Which statement is FALSE regarding database links? You can call PL/SQL procedures and functions by using a database link You can connect to an Autonomous Database from a remote database using a database link You can create a database link from one Autonomous Database to another Autonomous Database instance You can connect to a remote database from an Autonomous Database by using a database line. Which two Oracle Cloud Infrastructure (OCI) resources do you need to create before initiating a manual backup of Oracle Autonomous Database? Backup Job Service Gateway Auth Token Object Storage Bucket Storage Gateway. How do you change the tablespace quota for user MTHEO on Autonomous Database on Shared Infrastructure? Execute alter database for user MTHEO tableapace DATA quota = 10G; Execute alter user MTHEO quota unlimited on tablespace DATA; Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username = MTHEO', V U tablespace_quota -> UNLIMITED'); Execute alter tablespace DATA det quota = 10G;. Which two methods can you use to define Oracle Machine Learning users? SQL Developer the DBMS_CLOUD_ADMIN package Oracle Cloud Infrastructure Console Service Console. Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endpoints with security rules to allow incoming and outgoing traffic to and from the Autonomous Database Instance? The IP Protocol is set to TCP A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance The source is set to the address range you want to allow to connect to your database The destination port range is set to 1522. Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure? Oracle Key Vault, Oracle Cloud Infrastructure Vault Oracle Database Vault, Oracle Key Vault Oracle Audit Vault, Oracle Key Vault Oracle Cloud Infrastructure Vault, Oracle Database Vault. What is the maximum number of days that an Autonomous Database Refreshable Clone can be trailing its source instance? 15 days 1 day 7 days 30 days. Which workload is particularly suited to Oracle Autonomous JSON Database? Data Lakes Schemaless, document centric Transactions Data Marts. You enabled Autonomous Data Guard on Autonomous Database on Shared Infrastructure. Which three statements are true about the standby database after a failover? Autonomous Data Guard automatically reverts to the primary database when it becomes available again Autonomous Data Guard automatically creates a new standby database A new wallet is required to connect to the standby database The OCPU Count, Storage, Display Name, Database Name, Auto Scaling, Tags, and Licensing options have the same values as the primary Oracle Machine Learning Notebooks created in the primary database are available in the standby database. What are four methods to load data into an Autonomous Database? SQL*Loader Oracle Data Pump Database Actions Transportable Tablespace Oracle GoldenGate RMAN Restore. Which two objects are imported when using Data Pump to migrate your Oracle database to Autonomous Database? Tablespaces Reports Schemas Data. Which statement is correct about management operations on Autonomous Database on Shared. Infrastructure? You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available You can skip a scheduled maintenance run. For Autonomous Databases on Shared 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 Infrastructure You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your Autonomous Databases on Shared Infrastructure. Which four resources need to be provisioned by the fleet administrator and the database administrator before developer can connect to an Autonomous Database on Dedicated Infrastructure as a database user? Oracle Database licenses Autonomous Container Database Network Security Group(s) Virtual Cloud Network and Subnet Identity and Access Management (IAM) policy rules that allow access to the database Autonomous Exadata Infrastructure Autonomous Database instance. Which three options do NOT change when enabling auto scaling? Parallelism settings Amount of storage Number of OCPUS displayed in the console Level of concurrency I/O resources. Which command should you issue to enable application continuity on 0 Shared Infrastructure? alter system set application_continuity=true alter session set application_continuity-true exec dbms_cloud admin.enable_app_cont('<cservice_name>'); alter database set application_continuity=true. Which three scaling options are available in Oracle Autonomous Database on Shared Infrastructure? Automatic online scaling of OCPU Manual online scaling of OCPU Manual offline scaling of Storage and OCPU Manual online scaling of Storage Automatic online scaling of Storage. Which statement is FALSE about Oracle Text? It provides indexing, word and theme searches It is suited to search document collections It requires an Oracle Text license for Autonomous Database t uses standard SQL queries. What are the two differentiators of Oracle Autonomous Data Base on Dedicated Infrastructure? Users can customize the OS stack and add additional packages Users have more control over the maintenance schedule Users have OS access to the database machine Users are offered greater reutral and isolation starting at the Exade Cloud infrastructure level Users have SYS privileges in the database. Which are the two restrictions for an Always Free Autonomous Database? supports only ATP as a workload type maximum of two Always Free Databases per OCI tenancy Oracle Application Express (APEX) not included maximum of one OCPU per Database. Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure? Maximum Continuity Maximum Availability Maximum Performance Maximum Protection. 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 * Licence Tracluded * Shared Infrastructure Which parameter would you NOT use? licence-model db-workload is-dedicaced db-type. Which two tasks can be executed from the service console for Autonomous Databases? creating and scaling an Autonomous Database service configuring virtual cloud networks (VCNS) monitoring Autonomous Databases for usage and query performance using a wizard to download connection wallet for connection from desktop tools starting and stopping an instance. 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? Business Models APEX SQL Developer Web Data Load. Who, and in which order, provisions dedicated Exadata Infrastructure resources? The database administrator provisions the Autonomous Container DB and the Autonomous DB Then, the feet administrator provisions the Autonomous Exadata Infrastructure The fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB. Then, the database administrator provisions 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. Then, the database administrator provisions the Autonomous Container DB and then the Autonomous DB. Which four file formats are supported when loading data from Cloud Storage? Parquet DOC DDL JSON CSV AVRO. Which two statements apply to the Autonomous Database service on Dedicated Infrastructure? You can set a maintenance window for each individual Autonomous Container Database You, as the customer, are responsible for all patching operations You can set a maintenance window for an Autonomous Exadata Infrastructure Patching occurs on the first Sunday of each quarter. Where do you find the URL for Database Actions? in Oracle Cloud Infrastructure Object Storage in the Database Users card under Database Actions on the SQL Developer Client Connection tab in the database with a SQL query. Which three tasks are performed from the service console of an Autonomous Database on Shared Infrastructure? Manage Oracle Machine Learning users Download the wallet Rotate the wallet Set resource management rules Enable autoscaling. Which of the following two statements regarding Data Transforms are correct? 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 transforms is only available on the ODI Web Edition Data Transforms allows you to design data transformations in the form of data loads, data flows, and workflows. Which three functions are provided by Spatial Studio? Spatial analysis Geocoding Custom SQL queries Map visualization Spatial data editing. Which three methods can be used to migrate on-premises databases to Oracle Autonomous Database (both Shared and Dedicated)? RMAN backup & restore Physical migration methods, such as database cloning Orace Zero Downtime Migration (ZDM) Original imp/exp tools Oracle Data Pump Oracle Golden Gate. You see a clock icon in the Status column on the SQL Monitoring tab of Performance Hub. What does it indicate? The SQL statement completed its execution. The SQL statement is executing. The SQL statement is queued. The SQL statement did not complete due to an error. Which subset of services is offered via OCI-CLI (command line interface) for Autonomous Database (ADB) via calls made to the OCI APIs? Create, Query, List, Stop, Restore Create, Get, List, Stop, Restore Start, Delete, Update, Query, Stop Create, Query, Update, List, Start. 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? SQL*Plus Java You cannot use .NET with ADB. Oracle Data Access Components for Windows. Which statement is FALSE about the Catalog tool? You can view the data definition of an entity. Impact shows the entities that depend on the source. You can delete an entity from the Autonomous Database via the Catalog tool. You can limit the display of entities to only those with certain names, schemas, types, or applications by entering values in the Search field. Which two actions can you perform with Autonomous Data Guard enabled on Autonomous Database on Shared Infrastructure? Switchover Reinstate Change Protection Mode View Apply Lag Failover. Which index type is designed to index catalog information? CONTEXT CTXCAT CTXRULE CONTAINS. What can you do with graphs? (Choose two) Find patterns that are anomalous and use that to detect fraud. 3-D modeling Product recommendations Facial recognition. Which API is NOT available for developing with spatial on ADB? REST Python Java PL/SQL Gremlin.

Report abuse