Category Archives: Oracle Autonomous Database Cloud 2022 Professional 1z0-931-22

Oracle Autonomous Database Cloud 2022 Professional 1z0-931-22 Question and Answers

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud

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? A. Release Update (RU) B. Prior Release Update Revision (PRUR) C. Prior Release Update (PRU) D. Quarterly Bundle Patch (QBP) Correct Answer: A On the Edit Automatic Maintenance card, select Release Update… Read More »

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads? A. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations. B. Autonomous Data Warehouse workloads are optimized for mixed workloads. C. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.… Read More »

In which four ways can Oracle Database optimally access data in Object Storage?

In which four ways can Oracle Database optimally access data in Object Storage? A. optimized data archive using hybrid partitioned tables B. scan avoidance using columnar pruning for .csv files C. scan avoidance using columnar pruning for columnar stores like parquet and orc D. scan avoidance using partitioned external tables E. optimized data archive using partitioned external tables… Read More »

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.) A. Backup and recovery must be done using Recovery Manager(RMAN). B. Select the snapshot of the backup. C. Select the archived redo logs. D. Select the backup from which restore needs to be done. E. Specify the point in time (timestamp) to restore. Correct Answer:… Read More »

Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database? A. A Private Endpoint is required to connect to the Shared-Autonomous Database. B. The Autonomous Database must be in the same VCN and Subnet as the Compute instance. C. The Autonomous Database must belong to a Network Security Group (NSG). D. The OCI… Read More »

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.) A. through the Oracle Cloud Infrastructure service console B. through SQL/Developer s C. using DBMS_CLOUD_ADMIN package D. through SQLPIus Correct Answer: B,D https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-servicehttps://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5Ahttps://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B“To create users in your database, connect to the database as the ADMIN user using any SQL client… Read More »

You have a requirement to create an Autonomous Transaction Processing database that can support at least

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? A. TPURGENT B. TP C. MEDIUM D. LOW Correct Answer: A tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection… Read More »

Which statement is correct about the Service console in an Autonomous Database?

Which statement is correct about the Service console in an Autonomous Database? A. You can use Service console to enable or disable auto scaling of Autonomous DB B. You can use Service console to manage runaway SQL statements on Autonomous DB C. You can use Service console to move Autonomous DB between compartments D. You can use Service… Read More »

Which statement is true when connecting OCI Marketplace image to shared autonomous database?

Which statement is true when connecting OCI Marketplace image to shared autonomous database? A. ADB must be configured with NSG B. Compute Image and Shared ADB must be in same VCN and Subnet C. ADB must be configured with Private endpoints D. Cannot connect OCI Market image to shared ADB Correct Answer: B