OCI Database Management Professional

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

Which two methods can you use to define Oracle Machine Learning users?. the DBMS_CLOUD_ADMIN package. Service Console. Oracle Cloud Infrastructure Console. SQL Developer.

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?. Shut down and restart the instance. Rotate the instance wallet and share the new wallet with the remaining users. Delete the database. Delete the user who left.

Which three advanced options can you enable or disable while creating a business model?. Display Private Tables. Business Object Security Feature. Analytic View Base Table Query Transformation. Analytic View Transparency Views. Autonomous Aggregate Cache.

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?. SQL Developer Web. Data Load. Business Models. APEX.

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 destination port range is set to 1522. The IP Protocol is set to TCP. The source is set to the address range you want to allow to connect to your database. A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance.

Which two statements are true about using an Oracle Autonomous Database with 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 an Autonomous Database on Shared Infrastructure that was initially created with public endpoints. You can configure private endpoints for an Always Free Autonomous Database. A Network Security Group (NSG) is required within your virtual cloud network before you can provision a Shared Autonomous Database to use private endpoints.

What are the two differentiators of Oracle Autonomous Data Base on Dedicated Infrastructure?. Users are offered greater reutral and isolation starting at the Exade Coud infrastructure level. Users have OS access tot he database machine. Users have more control over the maintenance schedule. Users have SYS privileges in the database. Users can customize the OS stack and add additional packages.

Which option is not available to access data in an Autonomous JSON Database?. REST API calls to the database. Oracle Cloud Infrastructure console using the JSON Developer tool. NoSQL statements using Simple Oracle Document Access (SODA) drivers. Regular Oracle SQL statements using a connection string to the database.

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. Run the DMS_CLOUD. INCREASE_THROTSHPUT procedure. Ask Support to migrate their setup to a node without nolsy neighbors. Increase the number of OCPUS allocated to the database.

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

Which set of Oracle Cloud Infrastructure (CCI) metrics is available only for Autonomous Database on Dedicated Infrastructure?. Transaction Count, Sessions, Running Statements. CPU Utilization, Storage Utilization. IOPS, Storage Space Used By Tablespace, Apply and Transport Lag. Query Latency, User Calls, Execute Count.

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

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

Which DBMS_WORKLOAD_REPOSITORY subprogram procedure can be used to modify the default eight day retention period for Autonomous Database performance data?. MODIFY_SNAPSHOT_SETTINGS. MODIFY_BACELINE_WINDOW_SIZE. UPDATE_OBJECT_INFO. CREATE_BASELINE_TEMPLATE.

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 mccts their strict performance requirements as well. Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority in this scenario. The application should be deployed on a Kubernetes Cluster because it needs to be highly available. Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.

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

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?. 15 days. 120 days. 7 days. 60 days.

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 aren't being used by other auto scaling databases to meet high-load demands. Auto scaling is enabled by default and can be enabled or disabled at any time. 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.

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 "Specify a Schedule," but do not select any month, week, or day. Change the Automatic Maintenance Schedule to "No Preference". You cannot permanently disable scheduled automatic maintenance. Change the Automatic Maintenance Schedule to "None".

Which statement is FALSE regarding database links?. 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 link. You can call PL/SQL procedures and functions by using a database link.

Which statement is correct about management operations on Autonomous Database on Shared. Infrastructure?. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your Autonomous Databases on Shared Infrastructure. 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 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 command should you issue to enable application continuity on Oracle Autonomous Database on Shared Infrastructure?. alter database set application_continuity=true. alter session set application_continuity-true. exec dbms_cloud admin.enable_app_cont('<cservice_name>');. alter system set application_continuity=true.

What is the number of concurrent statements that can be handled by the medium database service name?. 1.25 X OCPU. 5. unlimited. 20 X OCPU.

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

Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?. 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 Exadala infrastructure. The marketplace OCI Image does not support connecting to an Autonomous Database on Shared Infrastructure. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image. The Autonomous Database must belong to a Network Security Group (NSG).

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

Which three methods can be used to migrate on-premises databases to Oracle Autonomous Database (both Shared and Dedicated)?. Orace Zero Downtime Migration (ZDM). RMAN backup & restore. Oracle Golden Gate. Original imp/exp tools. Physical migration methods, such as database cloning. Oracle Data Pump.

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 creates a new standby database. A new wallet is required to connect to the standby database. Autonomous Data Guard automatically reverts to the primary database when it becomes available again. 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.

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

Which two statements are true about Oracle Cloud Infrastructure (OCI)?. 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 thers within the same region. Regions are dependent on other regions and must be located within five 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.

Which two Oracle Cloud Infrastructure (OCI) resources do you need to create before initiating a manual backup of Oracle Autonomous Database?. Storage Gateway. Object Storage Bucket. Auth Token. Service Gateway. Backup Job.

How do you change the tablespace quota for user MTHEO on Autonomous Database on Shared Infrastructure?. Execute alter user MTHEO quota unlimited on tablespace DATA;. Execute alter database for user MTHEO tableapace DATA quota = 10G;. Execute alter tablespace DATA det quota = 10G;. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username =>'MTHEO', tablespace_quota -> UNLIMITED');.

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

Which two are ways Oracle Database can optimally access data in Object Storage?. Optimized data archive using partitioned external tables. Scan avoidance using columnar pruning for .csv files. Scan avoidance using partitioned external tables. Optimized data archive using hybrid partitioned tables.

Which of the following two statements regarding Data Transforms are correct?. All capabilities to transform data in ODI Classic are available with ODI Web Edition. Data Transforms provides access to Oracle Data Integrator (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 four file formats are supported when loading data from Cloud Storage?. CSV. JSON. Parquet. DOC. AVRO. DDL.

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

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 loading data into the Autonomous Database using the Data Load card in Database Actions?. Data can be loaded from a local data source. You must first manually create your database credentials using dms_cloud.create_credential before accessing your Oracle Object Storage Bucket. Data formats supported include: text, csv, json, avro and parquet. Data can be uploaded from several cloud storage sources including 53, Azure, Google Cloud and Oracle Object Storage. Data can be loaded from a remote database using Database Links (DBLinks).

Which statement is FALSE about setting up compartment quotas?. Quotas in a compartment cannot be managed unless you belong to a group that has the correct permissions. Quotas set on a parent compartment override quotas set on child compartments. Compartment quotas use policies that allow allocation of resources with a high level of flexibility. Compartment quotas cannot be set on the root compartment.

Which statement is FALSE about Oracle Data Safe?. It helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements. 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.

What are four methods to load data into an Autonomous Database?. RMAN Restore. Transportable Tablespace. Database Actions. SQL*Loader. Oracle Data Pump. Oracle GoldenGate.

Which two tasks can be executed from the service console for Autonomous Databases?. starting and stopping an instance. monitoring Autonomous Databases for usage and query performance. using a wizard to download connection wallet for connection from desktop tools. creating and scaling an Autonomous Database service. configuring virtual cloud networks (VCNS).

What infrastructure does the Autonomous Database run on?. VM on Oracle Cloud Infrastructure. Any Oracle Engineered system. Bare-metal on Oracle Cloud Infrastructure. Exadata on Oracle Cloud Infrastructure.

Which statement is FALSE about Oracle Text?. It provides indexing, word and theme searches. It is suited to search document collections. It uses standard SQL queries. It requires an Oracle Text license for Autonomous Database.

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

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

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 operations are available for a quarterly maintenance update on Autonomous Container Database?. Apply a partial patch. Skip patching. Reschedule and patch immediately. Reschedule patching. Patch immediately.

On which two infrastructure classes can the Autonomous Database service be deployed?. Dedicated Exadata Infrastructure. Shared Exadata Infrastructure. Exadata Cloud Service. Oracle Cloud Infrastructure Virtual Machines.

You created an Autonomous Database without auto scaling. Which two ways can you 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. 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.

What is the maximum number of days that an Autonomous Database Refreshable Clone can be trailing its source instance?. 7 days. 15 days. 1 day. 30 days.

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.

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

Where do you find the URL for Database Actions?. in Oracle Cloud Infrastructure Object Storage. in the database with a SQL query. in the Database Users card under Database Actions. on the SQL Developer Client Connection tab.

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 a database user with connect, resource, and object privileges. Create an IDCS user Create a database user with connect, resource, and object privileges. Create a REST-enabled database user (with connect and object privileges) and grant the DWROLE role. Create a database user with the default privileges.

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

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

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

Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator and Database Administrator. Fleet Adferinistrator Database Administrator, Latabase User, and Autonomous Exadata infrastructure. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database and 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 revert to pending. They become invalid. They are also rotated. They continue to work.

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. SQL Developer. OCI CLI. OS command line from the database server.

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

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

Which three are Oracle-recommended best practices for Autonomous Database alarms?. Create multiple alarm metrics. Select the correct alarm interval for your metric. Tune your alarms routinely. Create a single alarm for each metric. Suppress alarms during investigations. Use a single interval for all alarms.

Who, and in which order, provisions dedicated Exadata Infrastructure resources?. 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. 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 Container DB and the Autonomous DB Then, the feet administrator provisions the Autonomous Exadata Infrastructure.

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 compartment of the dedicated infrastructure because each compartment only runs one dedicated environment. The container database in which the Autonomous instance should run. The Client Credentials wallet, which is used to connect to the Autonomous Database. The Listener endpoint where the Autonomous Database should register on.

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. Virtual Cloud Network and Subnet. Autonomous Database instance. Autonomous Exadata Infrastructure. Identity and Access Management (IAM) policy rules that allow access to the database. Autonomous Container Database. Network Secunty Group(s).

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

Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?. Maximum Availability. Maximum Continuity. Maximum Protection. Maximum Performance.

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

Which three options do NOT change when enabling auto scaling?. I/O resources. Level of concurrency. Parallelism settings. Number of OCPUS displayed in the console. Amount of storage.

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

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

You have a requirement to create an Autonomous Transaction Processing database that can support up to 300 concurrent statements per OCPU as well as parallelism Wich service would you connect to?. MEDIUM. LOW. TPURGENT. TP.

Which native data type is used to store spatial information?. SDO RELATE. SDO GEOMETRY. SDO LOCATION. GEO JSON.

Which three scaling options are available in Oracle Autonomous Database on Shared Infrastructure?. Manual offline scaling of Storage and OCPU. Automatic online scaling of Storage. Automatic online scaling of OCPU. Manual online scaling of Storage. Manual online scaling of OCPU.

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 (VCN) but not for both at the same time. When you restore a database, the existing ACLs are not overwritten by the restore action. ACLS can only be used with private endpoints. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.

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

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?. db-workload. licence-model. is-dedicaced. db-type.

What are the two supported infrastructure options for deploying an Autonomous Database?. Bare-metal on Oracle Cloud Infrastructure. VM on Oracle Cloud Infrastructure. Any Oracle Engineered System. Shared Exadata Infrastructure. Dedicated Exadata Infrastructure.

Which are the two restrictions for an Always Free Autonomous Database?. maximum of one OCPU per Database. Oracle Application Express (APEX) not included. supports only ATP as a workload type. maximum of two Always Free Databases per OCI tenancy.

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.

You have an Autonomous Transaction Processing Database with three OCPUs and autoscaling 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. 2700. 900.

Which two actions can be performed when an Autonomous Database is stopped?. Update Network Access. Change Administrator Password. Update License Type. Start.