1Z0-931-25

Which three operations are available for a quarterly maintenance update on Autonomous Container Database? (Choose three.). Patch immediately. Reschedule and patch immediately. Reschedule patching. Skip patching. Apply a partial patch.

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version. How can they achieve this?. Change the Automatic Maintenance Schedule to 'No Preference'. Change the Automatic Maintenance Schedule to 'None'. You cannot permanently disable scheduled Automatic Maintenance. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week, or day.

Which statement is FALSE about Autonomous Database Oracle Client Credentials (Wallets)?. The Wallet for the Autonomous Database is the same as the TDE wallet. You must have an Oracle Client Credential wallet in order to connect to the Autonomous Database. In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database. The Oracle Client Credential file is downloaded as a ZIP file.

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure Console?. Using the DBCA on the database server. Connecting to the cloud infrastructure console using the SSH wallet. It cannot be done. Using the cloud infrastructure command line interface or REST API calls.

Which three functions are provided by Spatial Studio? (Choose three.). Map visualization. Custom SQL queries. Spatial analysis. Geocoding. Spatial data editing.

Which index type is designed to index catalog information?. CONTEXT. CTXCAT. CTXRULE. CONSTRAINS.

Which option describes the connection types that third-party software can use to connect to an Autonomous Database (ADB)?. New ADB-specific protocols. Any protocol supported by Oracle Net Services. SQL*NET only. JDBC only.

When integrating object storage with Autonomous Database, how effectively does Oracle use the files in the object storage?. Prune columns in parquet files. Scan partition tables. Scan hybrid partition tables. Prune columns in CSV files.

Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer? (Choose the best answer.). ADBDEV. DWROLE. ADMIN. ADWC.

To whom, and in which order, are dedicated Exadata Infrastructure resources provisioned?. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure.

Which statement is true when the Autonomous Database has auto scaling enabled?. Increases the number of sessions available to the database. Scales the PGA and SGA size when needed for the workload. Database concurrency is scaled up when needed by the workload. Enables the database to use up to 3x CPU/IO resources immediately when needed by the Workload.

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?. Quarterly Bundle Patch (QBP). Prior Release Update Revision (PRUR). Prior Release Update (PRU). Release Update (RU).

Which two statements are true about Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for Autonomous Data Guard? (Choose two.). RTO and RPO are adjustable through the OCI console. RPO is adjustable, but RTO is always 5 minutes. RPO is 0 minutes for an automatic failover. RTO and RPO are 0 minutes for manual failovers. RTO is 2 minutes for an automatic failover.

What is the default time range in Performance Hub?. 15 Minutes. 1 Hour. 24 Hours. 1 Week.

Which of the following is not required for connecting to Autonomous Database (ADB) via SQL Developer?. Password. Service. Username. Database name. Connection Name.

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?. Autonomous Transaction Processing only. Hybrid Columnar Compression. ATP and ADW. Autonomous Data Warehouse only.

Which of the following two statements regarding Data Transforms are correct? (Choose two.). Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition. Data Transforms allows you to design data transformations in the form of data loads, data flows, and workflows. Workflows for Data Transforms are only available on the ODI Web Edition. All capabilities to transform data in ODI Classic are available with ODI Web Edition.

When you are increasing the number of OCPUs in your Autonomous Database, what does its status show?. UPSCALE IN PROGRESS. RESIZING IN PROGRESS. UPLIFT IN PROGRESS. SCALING IN PROGRESS.

Which subset of services is offered via OCI-CLI (Command Line Interface) for Autonomous Database (ADB) via calls made to the OCI APIs?. Start, Delete, Update, Query, Stop. Create, Get, List, Stop, Restore. Create, Query, Update, List, Start. Create, Query, List, Stop, Restore.

Which terminology is used to refer to a communication channel for sending messages to a subscription, such as email or SMS, in Oracle Cloud Infrastructure?. Subject. Notification. Topic. Event.

Which statement is true when connecting an OCI Marketplace image to a shared Autonomous Database?. Compute Image and Shared ADB must be in the same VCN and Subnet. ADB must be configured with Private endpoints. ADB must be configured with NSG. Cannot connect OCI Marketplace image to shared ADB.

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','IMPLEMENT'). EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF'). EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY'). EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','INVISIBLE').

Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?. Oracle Audit Vault, Oracle Key Vault. Oracle Cloud Infrastructure Vault, Oracle Database Vault. Oracle Database Vault, Oracle Key Vault. Oracle Key Vault, Oracle Cloud Infrastructure Vault.

What are three methods to load data into the Autonomous Database? (Choose three.). Oracle Data Pump. RMAN Restore. Oracle GoldenGate. Transportable Tablespace. SQL*Loader.

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 any more 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?. ATP using 'tpurgent' and 'high' TNS services to separate connection types. Since the application needs to be highly available, it should be deployed on a Kubernetes Cluster. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis. ADW since operational reporting is a higher priority in this scenario.

Which two are correct actions to take in order to download the Autonomous Database Credentials? (Choose two.). Click the compute section of the menu, then choose instance configurations, then download wallet. Find the service console for your Autonomous Database, then pick administration, then download the credential wallet. Click on the Object Storage and find your Autonomous bucket and download the wallet credentials. Click on the Autonomous Database in the menu, click a database name, then choose DB Connection button, then download the wallet.

Which statement is true about OCPUs and storage when you choose to scale your Autonomous Database?. OCPUs and storage can be scaled independently. Use auto scaling to increase storage. Increasing OCPUs will automatically increase storage. OCPUs and storage must remain in sync.

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 for Oracle Data Safe?. 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 helps you assess the security of your cloud database configurations by analyzing database configurations. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user. Oracle Data Safe only supports Autonomous Database.

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. The destination port range is set to 1522. 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.

As a database architect, you are tasked with configuring a high concurrency, production OLTP (EXAM) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode. Which connection service is appropriate for such a workload?. TPURGENT. TP. HIGH. MEDIUM.

Which three security features are available in Oracle Autonomous Database Shared Infrastructure? (Choose three.). Customer Managed Keys. Audit Vault. Data Redaction. Database Vault. Transparent Data Encryption.

Which workload is particularly suited to Oracle Autonomous JSON Database?. Data Marts. Transactions. Data Lakes. Schema-less, document-centric.

Which two objects are imported when using Data Pump to migrate your Oracle database to Autonomous Database? (Choose two.). Tablespaces. Data. Schemas. Report.

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, and object privileges. Create a database user with the default privileges. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer Web, and provide the user with the user-specific modified URL. Create an IDCS user, create a database user with connect, resource, and object privileges.

Which statement is NOT correct when setting up compartment quotas?. Compartment quotas are set by Oracle. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending. 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.

Which management operation is correct about Autonomous Databases on Shared Exadata Infrastructure?. You can skip a scheduled maintenance run. For Autonomous Database on Shared Exadata Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node on the Autonomous Database is restarted separately while the remaining nodes continue to be available. You cannot configure the scheduling for your Autonomous Databases on Shared Exadata Infrastructure. You can choose to use Release Update or Release Update Revision updates for your Autonomous Databases on Shared Infrastructure.

What are three characteristics of Data Lake data captured in Object Storage? (Choose three.). High concurrency. High transaction performance. Schema on read. Multiple subject areas. Mixed data types.

Which tab in the Data Load Explore tool shows the size of the table and the number of rows and columns?. Hierarchies tab. Statistics tab. Data Sources tab. Measures tab.

Which can be used to ensure that your Autonomous Database is accessible only from a given set of IPs?. Security List. IP Vault. Access Control List. IPSec List.

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. You cannot use .NET with ADB. Java. Oracle Data Access Components for Windows.

What predefined user is created when provisioning an Autonomous Database (ADB) instance to which you connect to create other users and grant roles?. SYS. ADMIN. DWDEV. SCOTT.

What two actions can you do when a refreshable clone passes the refresh time limit? (Choose two.). You can manually refresh the clone. You can disconnect from the source to make the database a read/write database. You can use the instance as a read-only database. You can extend the refresh time limit.

Which Oracle package is used to load data to an Autonomous Database from object storage?. DBMS_RPC. DBMS_LOAD. DBMS_MIGRATE. DBMS_CLOUD.

Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?. Data formats supported include: text, CSV, JSON, Avro, and Parquet. Data can be loaded from a local data source. Data can be uploaded from several cloud storage sources including S3, Azure, Google Cloud, and Oracle Object Storage. You must first manually create your database credentials using DBMS_CLOUD.CREATE_CREDENTIAL before accessing your Oracle Object Storage Bucket. Data can be loaded from a remote database using Database Links (DBLinks).

Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? (Choose two.). Memory Usage. Data Organization. Backup Retention. Undo Management.

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 Database then Autonomous Transaction Processing then Autonomous Exadata. Under Solutions and Platforms then Platform Services then Autonomous Exadata. Under Core Infrastructure then Autonomous Exadata.

DBSRV1 is an Autonomous Database with the display name PRODDB. You plan to take manual backups of this database periodically. What must be the name of the bucket that will be used to store manual backups?. backup_proddb. BACKUP_PRODDB. backup_dbsrv1. BACKUP_DBSRV1.

Which two statements apply to the Autonomous Database service on Dedicated Infrastructure? (Choose two.). You, as the customer, are responsible for all patching operations. You can set maintenance windows for an Autonomous Exadata Infrastructure. You can set maintenance windows for each individual Autonomous Container Database. Patching occurs on the first Sunday of each quarter.

Which two statements are true regarding active transactions when scaling OCPUs in an Autonomous Database? (Choose two.). Active transactions are terminated and rolled back. Scaling can happen while there are active transactions in the database. Active transactions continue running unaffected. Active transactions are paused.

Which statement is FALSE about Data Insights?. Data Insights display information about patterns and anomalies in the data of entities in your Oracle Autonomous Database. Data Insights provides a wide range of graphical data presentation capabilities. Data Insights are automatically generated by various analytic functions built into the database. The results of the Insight analysis appear as a series of bar charts in the Data Insights dashboard.

What are two advantages of using Data Pump to migrate your Oracle databases to Autonomous Database? (Choose two.). Data Pump is faster to migrate database than using RMAN. Data Pump creates the tablespaces used by your Autonomous Database. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database. Data Pump is platform-independent - it can migrate Oracle databases running on any platform.

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".

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?. ORDS_ADMIN.GRANT_SCHEMA. ORDS_ADMIN.ENABLE_SCHEMA. ORDS_PRIV.ENABLE_SCHEMA. SQLDEV_ADMIN.GRANT_SCHEMA.

Who, and in which order, provisions dedicated Exadata Infrastructure resources?. The Fleet Administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB and then, the Database Administrator provisions the Autonomous DB. The Database Administrator provisions the Autonomous Container DB and the Autonomous DB. Then, the Fleet Administrator provisions the Autonomous Exadata Infrastructure. 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 command can you use to create an Autonomous Database?. POST /20160918/createADB. POST /20160918/createautonomousDatabases. POST /20160918/createDatabases. POST /20160918/autonomousDatabases.

Which two actions can you perform with Autonomous Data Guard enabled on Autonomous Database on Shared Infrastructure? (Choose two.). View Apply Lag. Reinstate. Switchover. Failover. Change Protection Mode.

Which are two available options when creating an Autonomous Database? (Choose two.). APEX Service on Dedicated Infrastructure. APEX Service on Shared Infrastructure. Autonomous JSON Database on Shared Infrastructure. Autonomous JSON Database on Dedicated Infrastructure.

Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.). GoldenGate on-premise installation. RMAN Cross-Platform backup and restore. Data Guard Physical Standby. GoldenGate Cloud Service. Data Pump export/import. PDB unplug/plug operation.

Which are the two restrictions for an Always Free Autonomous Database? (Choose two.). 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 three options do NOT change when enabling auto scaling? (Choose three.). Amount of storage. Parallelism settings. I/O resources. Number of OCPUs displayed in the console. Level of concurrency.

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). By executing SELECT * FROM UTL_FILE.LIST('DATA_PUMP_DIR');. Log onto ADW server and issue ls -al on the command line.

How can you keep Autonomous Database tables in sync with an on-premises data source?. Use the ORDS package on the Data Load page. Use the Cloud Locations card on the Data Load page. Use the Link Data option on the Data Load page. Use the FEED DATA option on the Data Load page.

For fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?. Allow group adb-admins to manage autonomous-database in tenancy where target.workloadType='OLTP'. Allow group adb-admins to manage autonomous-database-family in tenancy. Allow group adb-admins to manage autonomous-database in tenancy where target.workloadType='DW'. Allow group adb-admins to manage autonomous-database in tenancy.

Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.). Regions are dependent on other regions and must be located within 5 thousand kilometers of each other. 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. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.

What is a best practice when planning and instituting access controls for your Autonomous Dedicated environment regarding subnets, compartments, and user groups?. Only 1 subnet and 1 compartment are allowed, multiple groups highly advised. Only 1 of each is allowed to be allocated per environment. Create a separate VCN that contains only public subnets. Create at least 2 of each resource.

You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling? (Choose two.). Click Scale Up/Down and select the Auto Scaling checkbox. Shut down the instance, click Scale Up/Down and select the Auto Scaling checkbox, then restart the instance. Use a REST call to enable Auto Scaling. Use a REST call to shut down the instance, then a second REST call to enable Auto Scaling, and a REST call to restart the instance.

Which is an Autonomous Database critical event?. Maintenance Begin. Database Connection. Schedule Maintenance Warning. Admin Password Warning. New Maintenance Schedule.

Which four levels of access can be defined in policies? (Choose four.). Create. Read. Manage. Inspect. Use.

How many Network Security Groups (NSGs) can you configure for an Autonomous Database?. 3. 9. 7. 5.

Which file is NOT a component of the client credentials wallet used to connect to an Oracle Autonomous Database?. protocol.ora. ewallet.p12. sqlnet.ora. keystore.jks. cwallet.sso.

Which two infrastructure types support deployment of Oracle Autonomous Database? (Choose two.). Virtual Machines on Oracle Cloud Infrastructure. Dedicated Exadata Infrastructure. Oracle Bare Metal Servers. Shared Exadata Infrastructure.

Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of OCPU 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 are not being used by other auto scaling databases to meet high-load demands. 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. The base number of OCPU cores allocated to a database is not guaranteed. Auto Scaling is enabled by default and can be enabled or disabled at any time.

Which is a feature of a graph query language?. Run key-value queries. Scripting language. Object-oriented language. Ability to specify patterns.

Users connect to Autonomous Data Warehouse by using one of the following consumer groups: High, Medium, and Low. Which statement is true?. Low provides highest concurrency and lowest resources, and DoP is 1. High provides highest concurrency and lowest resources, and DoP is 1. Medium provides intermediate resource and concurrency, and queries run serially. High provides highest resource and lowest concurrency, and Degree of Parallelism (DoP) is 1.

Which statement is FALSE about the Catalog tool?. You can delete an entity from the Autonomous Database via the Catalog tool. You can limit the display of entities to only those with certain names, schemas, types, or applications by entering values in the Search field. You can view the data definition of an entity. Impact shows the entities that depend on the source.

In the Autonomous Database on Dedicated Infrastructure service, what does the fleet administrator use to control OCPU utilization?. Oracle Machine Learning notebook. Compartment quotas. SQL Developer Web Console. Resource Manager settings.

Which native data type is used to store spatial information?. SDO_GEOMETRY. SDO_LOCATION. SDO_RELATE. GEO_JSON.

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, License Included, Shared Infrastructure. Which parameter would you NOT use?. db-type. is-dedicated. db-workload. license-model.

Which three advanced options can you enable or disable while creating a business model? (Choose three.). Autonomous Aggregate Cache. Analytic View Transparency View. Analytic View Base Table Query Transformation. Display private tables. Business Object Security Feature.

Which method does NOT permit you to change the database ADMIN user's password of an Oracle Autonomous Database on Shared Infrastructure?. Admin page of the Cloud Service Console. OCI CLI. OS command line from the database server. SQL Developer.

Which statement is NOT correct when the Autonomous Database is stopped?. Tools are no longer able to connect to a stopped instance. In-flight transactions and queries are stopped. User with DWROLE can still access the database. CPU billing is halted.

Which two objects are imported when using Data Pump to migrate your Oracle Database to Autonomous Database? (Choose two.). Data. Schemas. Tablespaces. Reports.

Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure? (Choose three.). RMAN. Logs. Enterprise Manager Cloud Control. OCI Metrics. Performance Hub.

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?. Create a rule for the Oracle Cloud Infrastructure Event for 'Autonomous Database STOP END'. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric. Add a 'BEFORE SHUTDOWN ON DATABASE' trigger within the database. Create a notification alert using DBMS_SNMP package.

Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.). Using SFTP to copy CSV files into an Autonomous Database. Using Oracle Zero Downtime Migration (ZDM). Using GoldenGate. Using Data Pump. Using Recovery Manager (RMAN).

What are two differentiators of Oracle Autonomous Database on Dedicated Infrastructure? (Choose two.). Users are offered greater control and isolation starting at the Exadata Cloud Infrastructure level. Users can customize the OS stack and add additional packages. Users have OS access to the database machine. Users have SYS privileges in the database. Users have more control over the maintenance schedule.

When cloning from a backup, what is the earliest timestamp of the backup allowed in Autonomous Database?. 2 hours. 24 hours. 1 hour. 30 minutes.

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?. Remove any non-JSON data from the database. Ask Support to migrate their setup to a node without noisy neighbors. Increase the number of OCPUs allocated to the database. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

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? A. Switchover is automatically initiated. B. Standby database is terminated. C. Standby database is also stopped. D. Failover is automatically initiated. Switchover is automatically initiated. Standby database is terminated. Standby database is also stopped. Failover is automatically initiated.

Which two cloud services allow you to import Data Pump files to an Autonomous Database on Dedicated Infrastructure? (Choose two.). Amazon S3. Azure Blob Storage. Oracle Cloud Infrastructure Object Storage Classic. Google Cloud Storage. Oracle Cloud Infrastructure Object Storage.

You see a clock icon in the Status column on the SQL Monitoring tab of Performance Hub. What does it indicate?. The SQL statement is queued. The SQL statement is executing. The SQL statement did not complete either due to an error. The SQL statement completed its execution.

Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?. Transaction Count, Running Statements, Sessions. CPU Utilization, Storage Utilization. IOPS, Storage used by tablespace, Apply and Transport Lag. Query Latency, User Calls, Execute Count.

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 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?. Catalog. Data Load. JSON. Data Insight.

Which command should you issue to enable application continuity on Oracle Autonomous Database on Shared Infrastructure? A. ALTER SESSION SET APPLICATION_CONTINUITY=TRUE B. EXEC DBMS_CLOUD_ADMIN.ENABLE_APP_CONT('<service_name>'); C. ALTER DATABASE SET APPLICATION_CONTINUITY=TRUE D. ALTER SYSTEM SET APPLICATION_CONTINUITY=TRUE. ALTER SESSION SET APPLICATION_CONTINUITY=TRUE. EXEC DBMS_CLOUD_ADMIN.ENABLE_APP_CONT('<service_name>');. ALTER DATABASE SET APPLICATION_CONTINUITY=TRUE. ALTER SYSTEM SET APPLICATION_CONTINUITY=TRUE.

Which two actions can be performed when an Autonomous Database is stopped? (Choose two.) A. Change administrator password B. Start C. Update License type D. Update Network Access. Change administrator password. Start. Update License type. Update Network Access.

Which statement is true about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure?. An ACL can be set up for an IP Address or a virtual cloud network but not both at the same time. When you restore a database, the existing ACLs are not overwritten by the restore. ACLs can only be used with private endpoints. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.

A new Python developer has joined your team and needs to access the Autonomous Database data. How does the developer connect to and interact with the Autonomous Database from Python?. By using SQL Developer. By using Oracle Client and the DBD-oracle interface. By using JDBC Driver. By using Oracle Client and the cx_Oracle interface.

What happens with the standby database when disabling Autonomous Data Guard?. The standby database is terminated. The standby database is started read-write. The standby database is started read-only. The standby database is transformed into a refreshable clone.

Which statement is FALSE about setting up compartment quotas?. Compartment quotas use policies that allow allocation of resources with a high level of flexibility. Quotas set on a parent compartment override quotas set on child compartments. 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.

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?. Access the APEX Administrator Services and create the workspace for the developer. Create an IDCS user with the APEX role. Create a database user with the APEX role. Create a new developer account.

Which two options are available for restoring an Autonomous Database? (Choose two.). Selecting the backup from which restore needs to be done. Selecting the snapshot of the backup. Specifying the archived custom image. Specifying the point in time (timestamp) to restore.

Your customer has upgraded their on-premises 11.2 Database to 12.2. During this migration, the database was migrated to a pluggable database (PDB) and is now in production. How should the customer unplug their database to migrate to an Autonomous Database?. Unplug into an XML file so that the database and XML files can be uploaded to Object Storage. PDBs cannot be migrated to an Autonomous Database using plug, unplug, or clone. Create a database link from the source database to the Autonomous Database environment and clone the PDB. Unplug into a PDB archive, which can be uploaded to Object Storage.

Which of the following two statements are correct? (Choose two.). ODI Web Edition is available only on Oracle Linux. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace. Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition. All capabilities of ODI Classic are available with ODI Web Edition.

What is the difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?. Only ATP manages optimizer statistics. Only ADW supports autoscaling. Only ADW uses columnar compression by default. Only ATP supports automatic backups.

Which is NOT needed to manage Oracle Autonomous Database with REST APIs?. User's OCID. Tenancy's OCID. Fingerprint of the public key. Database ADMIN password.

Which statement is correct with respect to the required action to move Oracle Autonomous Database resources to a different compartment?. Moving an Autonomous Database instance does not include its automatic backups. You do not require sufficient access permissions on the compartment that the resource is being moved to. 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 the compartment of the Autonomous Database also moves the Autonomous Container Database and Autonomous Exadata Infrastructure.

Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose three.). Suppress alarms during investigations. Create multiple alarm metrics. Select the correct alarm interval for your metric. Routinely tune your alarms.

In which four ways can Oracle Database optimally access data in Object Storage? (Choose four.). Scan avoidance using partitioned external tables. Scan avoidance using columnar pruning for .csv files. Scan avoidance using block skipping when reading parquet and orc files. Scan avoidance using columnar pruning for columnar stores like parquet and orc. Optimized data archive using hybrid partitioned tables. Optimized data archive using partitioned external tables.

Which statement is true when you provision an Autonomous Database using the cloning method?. A clone database source can be a running database instance. There is only one type of cloning option available in Autonomous Database. A clone database source can be from a point-in-time backup that is less than 2 hours old. You can clone a database in a security zone to create a database that isn't in a security zone.

Which option should you use to create a graph with Graph Studio? A. Tables in an Autonomous Database instance B. Graph analytics algorithms C. NoSQL configuration D. Graph created by a special tool downloaded from oracle.com E. A graph license key. Tables in an Autonomous Database instance. Graph analytics algorithms. NoSQL configuration. Graph created by a special tool downloaded from oracle.com. A graph license key.

An Autonomous Database user with an instance wallet has left the company. The user had shared a database user ID with other users when accessing the Autonomous Database. Other than changing the shared user password, what can an administrator do to protect the instance?. Trust the user who left not to access the database. Delete the user. Rotate the instance wallet and share the new wallet with the remaining users. Shutdown and restart the instance.

Which stage of the indexing pipeline divides text into tokens?. Sectioner. Tokenizer. Filter. Lexer.

Which can be scaled independently of the number of CPUs in an Autonomous Database?. Sessions. Storage. Memory. Concurrency. Parallelism.

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with a private endpoint? (Choose three.). Network Security Group. VCN. Security List. Route Table. Subnet.

Where are the customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?. In a separate key vault external to the Exadata infrastructure. Inside the Autonomous Database wallet. On the Exadata infrastructure where the Autonomous Database Dedicated is hosted. Inside the backup of the container database.

Which two statements are true about using an Oracle Autonomous Database with private endpoints? (Choose two.). 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 (ACL). 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 statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.). The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully. The source files can reside in Oracle Object Storage, Amazon S3 Object Storage, or Azure Blob Storage. The target table will be created in Autonomous Database if it does not already exist. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

Which three are use cases for Graph Studio? (Choose three.). Facial recognition. Churn analysis. Pattern matching. Clustering. 3-D modelling.

While provisioning a dedicated Autonomous Container Database, which backup retention period CANNOT be implemented? A. 120 days B. 7 days C. 60 days D. 15 days. 120 days. 7 days. 60 days. 15 days.

Which Autonomous Database Cloud Service ignores hints in SQL statements by default?. Both services ignore hints by default. Neither service ignores hints by default. Autonomous Data Warehouse. Autonomous Transaction Processing.

Which statement is FALSE about Oracle Autonomous JSON Database? A. It supports NoSQL-style, document-centric applications. B. There is a 20 GB limit on JSON collection. C. JSON data is stored natively in the database. D. You can promote Autonomous JSON Database to Autonomous Transaction Processing. It supports NoSQL-style, document-centric applications. There is a 20 GB limit on JSON collection. JSON data is stored natively in the database. You can promote Autonomous JSON Database to Autonomous Transaction Processing.

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). The marketplace OCI image can be used with an Always Free Autonomous Database account. 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.

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?. MEDIUM. TPURGENT. LOW. TP.

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?. Oracle Database Result Cache is enabled by default for all SQL statements. You have direct access to the database node. Parallelism is not enabled by default. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

During the provisioning of an Autonomous Database on dedicated hardware, what should the database administrator select to determine where the Autonomous Database is created on the dedicated infrastructure?. The Listener endpoint where the Autonomous Database should register on. The Client Credentials wallet, which is used to connect to the Autonomous Database. The container database in which the Autonomous instance should run. The compartment of the dedicated infrastructure because each compartment only runs one dedicated environment.

Which three of the following data sources are available when using the Data Load page on Database Actions?. Local Files. Files in Oracle Cloud Storage. REST endpoints. Files in AWS S3 Storage. Backup files in block storage.

Given the steps: Create Oracle Machine Learning User Create Projects Create Workspaces Create Notebooks Run SQL Scripts Which two steps are out of order when working with Oracle Machine Learning?. Create Oracle Machine Learning User. Run SQL Scripts. Create Workspaces. Create Projects. Create Notebooks.

Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure.

A Business Analyst joined your organization and wants to explore the database tools. When restoring or cloning an Autonomous Database (ADB), you must select a backup that is at least how old?. 24 hours. 5 minutes. 2 hours. 1 day.

You are the admin user of an Autonomous Database instance. A new business analyst has joined the team and would like to explore the Autonomous Database tables using Autonomous Database’s Data Tools. Which step should you perform to enable the new team member?. Create a REST-enabled database user (with connect and object privileges) and grant the DWROLE role. Create a database user with the default privileges. Create a database user with connect, resource, and object privileges. Create an IDCS user and create a database user with connect, resource, and object privileges.

How do you change the tablespace quota for user MTHEO on an Autonomous Database on Shared Infrastructure?. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username => 'MTHEO', tablespace_quota => 'UNLIMITED');. Execute ALTER USER MTHEO QUOTA UNLIMITED ON TABLESPACE DATA;. Execute ALTER TABLESPACE DATA SET QUOTA = 10G;. Execute ALTER DATABASE FOR USER MTHEO TABLESPACE DATA QUOTA = 10G;.

Oracle Data Safe is a unified control center for your Oracle databases that 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 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 Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?. TPPERFORMANT. TPURGENT. MEDIUM. HIGH. LOW.

Which three statements are true about procedures in the DBMS_CLOUD package?. 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. The DBMS_CLOUD.DELETE_FILE procedure removes the credential file from the Autonomous Data Warehouse. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores cloud object credentials in the Autonomous Data Warehouse. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE validates the source file 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 in Autonomous Data Warehouse. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from cloud object storage to the Autonomous Data Warehouse.

Which three options are available to access data in an Autonomous JSON Database?. NoSQL statements using Simple Oracle Document Access (SODA) drivers. Regular Oracle SQL statements using a connection through the listener. REST API calls to the database (not enabled by default). Oracle Cloud Infrastructure console using the JSON Online Developer tool. Oracle JSON Developer tool downloaded from Oracle Technology Network (OTN).

Which two methods can you use to create database users and grant roles in Autonomous Database services?. Oracle Cloud Infrastructure (OCI) service console. SQL Developer. DBMS_CLOUDADMIN package. SQL*Plus.

Which statement is correct about the Service Console in an Autonomous Database?. You can use the Service Console to enable or disable auto-scaling of Autonomous DB. You can use the Service Console to manage runaway SQL statements on Autonomous DB. You can use the Service Console to move Autonomous DB between compartments. You can use the Service Console to create manual backups of Autonomous Database.

Which predefined service connection should you use when running lots of high concurrent queries in an Autonomous Database? A. DBNAME_LOW B. DBNAME_MEDIUM C. DBNAME_HIGH D. DBNAME_CONCURRENT. DBNAME_LOW. DBNAME_MEDIUM. DBNAME_HIGH. DBNAME_CONCURRENT.

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?. 1500. 1800. 900. 2700.

Which two statements are true about accessing the Autonomous Database Tools?. 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. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database. Access to Database Actions is available for all users of Autonomous Database. SQL Developer Web is exclusive to Autonomous Database, not traditional Oracle databases.

Which statement is correct about the Service Console in an Autonomous Database?. You can use the Service Console to enable or disable auto-scaling of an Autonomous Database. You can use the Service Console to manage runaway SQL statements on an Autonomous Database. You can use the Service Console to create manual backups of an Autonomous Database. You can use the Service Console to move an Autonomous Database between compartments.

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. Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs. Multitenant. Transparent Data Encryption (TDE).

Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?. 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. 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. If a scheduled container database maintenance run cannot take place, Oracle automatically reschedules the container database maintenance for the following quarter. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter.

What REST verb is used to create an Autonomous Database service using REST APIs?. A "POST" REST call. A "GET" REST call. A "PUT" REST call. An "INSERT" REST call.

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. Data Load.

Which three event types are supported for Autonomous Database?. Maintenance Begin. Change Autoscaling Configuration Compartment. Change Compartment Begin. Update IORM Begin. Terminate End.

Which two statements are true about Data Insights?. You can search for Data Insights against a base table or business model. 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.

Which four file formats are supported when loading data from Cloud Storage?. DDL. AVRO. Parquet. DOC. JSON. CSV.