Perso2

You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance. Which tool would you use to automate data exploration and create pivot tables?. SQL Developer Web. APEX. NA. Business Models. Data Load.

Which two methods can you use to create users and grant roles in Autonomous Database?. using DBMS_CLOUD_ADMIN package. through SQL/Developers. through the Oracle Cloud Infrastructure service console. through SQL*P1us.

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

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?. Using Database Configuration Assistant (DBCA) on the database server. It cannot be done. Connecting to the Cloud Infrastructure Command console via SSH wallet. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Which two statements are TRUE for Autonomous JSON Database?. JSON data does not stored natively in the database. You can promote an Autonomous JSON Database service to an Autonomous Data Warehouse service. you can not store only up to 20 Ga of data Other than JSON document collections. They are schema-less. There is no storage limit for JSON collections.

What are the pre requisite of using an Oracle client? (Choose three.). SQL Developer. Tenancy's OCID. Fingerprint of the public key. ADMIN password. User's OCID.

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?. 120 days. 90 days. 30 days. 360 days.

Which four file formats are supported from loading from cloud storage?. ORC. AVRO. JSON. CSV. Parquet. TXT.

Which Set of options can be specified when defining the preferred maintenance of the Exadata infrastructure for Autonomous Database Dedicated?. Month Of the Quarter, Week Of Month, Day Of the Week, Start Hour. Month of the Year, Week of the Month, Day of the Week, Start Hour. Quarter Of the Year, Month Of the Quarter, Date Of the Month, Start Hour. Week of the Quarter, Day of the Week, Start Hour.

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

When enabling auto-scaling, which three options do not change? (Choose three.). I/O resources. parallelism settings. Level of concurrency. Number of OCPUs displayed in the console. Amount Of storage.

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 Administrator, Database Administrator, Database 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.

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

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

The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources? (Choose the best answer). Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator. Virtual Cloud Network, Compartments, Policies, Exadata Infrastructure. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure.

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 Autonomous Database Can only be in the same virtual Cloud network (VCN) and Subnet the marketplace OCI image. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.

Which three Of the following data sources are available when using Data Load Page on Database actions. Files in Oracle Cloud Storage. Files in Azure blob storage. Local Files. Files in AWS S3. Other Databases.

Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?. Oracle Cloud Infrastructure Object Storage Classic. Amazon S3. Oracle Cloud Infrastructure Object Storage. Google Cloud Storage.

When Autonomous DB stopped , what option is available in ADB console? (Choose two.). Start. Update license method. Update Network Option. Update Admin password.

Data guard is enabled for your ADB and Life cycle state field for the primary database indicates that it is stopped. Which statement is true?. The Standby database is also Stopped. The Standby database is running. The Standby database was not Stopped. The Standby database is not running.