teste dos testes

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

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

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 infrastructure maintenance within the same quarter. Autonomous Exadata infrastructure maintenance takes place at least once each quarter. 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 runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and includes container database patching.

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

Which file is NOT in the Autonomous Database Client Credentials (Wallet) zip file?. listener.ora. sqlnet.ora. README. cwallet.sso. tnsnames.ora.

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

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 columnar pruning for .csv files. Scan avoidance using partitioned external tables.

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

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

Which two license types does a customer need to benefit from Bring Your Own License (BYOL) when leveraging on-premises Enterprise Database licenses in Oracle Autonomous Database?. Transparent Data Encryption (TDE). Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs. Multitenant. Exadata. Active Data Guard.

Which two statements are true about Oracle Cloud Infrastructure (OCI)?. 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. Regions are dependent on other regions and must be located within five thousand kilometres of each other. An OCI region is a localized geographic area, and an availability domain is one or more data centres located within a 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 dbms_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 S3, Azure, Google Cloud and Oracle Object Storage. Data can be loaded from a local data source. Data can be loaded from a remote database using Database Links (DBLinks).

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 on the online transaction processing (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?. 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. Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority in this scenario.

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. Change the disk throughput settings in the console. Increase the number of ECPUs allocated to the database. Increase the number of Database Writer processes.

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

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

Your customer has upgraded their on-premises 12.2 Database to 19c. 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 a PDB archive, which can be uploaded to Object Storage. PDBs cannot be migrated to an Autonomous Database using plug, unplug. Create a database link from the source database to the Autonomous Database environment and clone the PDB. Unplug into an XML file so that the database and XML files can be uploaded to Object Storage.

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

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

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. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the datab. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric.

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

You moved an Autonomous Database from compartment C01 to C02. Which two statements are true?. An Autonomous Data Guard for the database is created in C01 post successful migration to C02. The Automatic Backups are moved to C02, as well. You need to shut down the database in C01 before you can move it to C02. Any policy defined on C02 will be immediately applied to the database.

After you created an Autonomous Container Database on dedicated infrastructure, which patch type is offered to be applied during maintenance?. Quarterly Bundle Patch (QBP). Release Update (RU). Prior Release Update Revision (PRUR). Prior Release Update (PRU).

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 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 fleet administrator provisions the Autonomous Exadata Infrastructure. The fleet administrator provisions the Autonomous Exadata Infrastructure. Then, the database administrator provisions the Autonomous Container DB and then the Autonomous DB.

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

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

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

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

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

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

Which two options are available for restoring an Autonomous Database?. Specifying the point in time (timestamp) to restore. Selecting the snapshot of the backup. Specifying the archived custom image. Selecting the backup from which restore needs to be done. Using Recovery Manager (RMAN) to connect to Autonomous Database and back it up.

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

Users connect to Autonomous Data Warehouse by using one of the following consumer groups: High, Medium, and Low. Which statement is true about these consumer groups?. High provides highest resources and lowest concurrency, and Degree of Parallelism (DoP) is 1. 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.

Where do you find the URL to access APEX Administration Services on your Autonomous Database (ADB) instance?. in the ADB documentation. SQL Developer. on the Tools tab and Service Console of the ADB instance. in the database with a SQL query.

Which two statements are true about Data Insights?. Data Insights is available with on-premises deployments of Oracle Database. You can retrieve previously executed Data Insights searches. You can search for Data Insights against a base table or business model. Data Insights is an additional priced option.

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. 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. Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition.

You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling?. Shut down the instance, click Scale Up/Down and select the Auto Scaling checkbox, then restart the instance. 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. Use a REST call to enable Auto Scaling. Click Scale Up/Down and select the Auto Scaling checkbox.

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

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

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 NOT needed to manage Oracle Autonomous Database with REST APIs?. Fingerprint of the public key. User's OCID. Tenancy's OCID. Database ADMIN password.

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, Query, Update, List, Start. Create, Query, List, Stop, Restore. Create, Get, List, Stop, Restore.

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

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

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

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

Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image 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 marketplace OCI image can be used with an Always Free Autonomous Database accoun. The marketplace OCI image does not support connecting 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.

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 ADB from Python?. By using Oracle Client and the cx_Oracle interface. By using Oracle Client and the DBD-Oracle interface. By using JDBC Driver. By using SQL Developer.

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. APEX. Business Models.

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

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

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

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

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

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

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

Which two tasks can be executed from the service console for Autonomous Databases?. using a wizard to download connection wallet for connection from desktop tools. starting and stopping an instance. creating and scaling an Autonomous Database service. Configuring virtual cloud network. Monitoring autonomous database for usage and query performance.

Which three statements are true about changing license options in Oracle Autonomous Database?. You cannot update your BYOL to License Included after the Database has been created. You can upgrade from an Always Free Autonomous Database account to a paid account any time. You cannot update the License Included option to BYOL after the Database has been created. You can update your Bring Your Own License (BYOL) to License Included after the Database has been created. You can update the License Included option to BYOL after the Database has been created.

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