Tag Archives: Dumps

Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access

Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option? A. Current settings for ACLs are cloned. B. Clone can be in a different region. C. All OML notebooks are cloned. D. All underlying data for OML notebooks is cloned. E. All resource management rules are cloned. Correct Answer: B,D https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-clone-notes.html#GUID-F943E7FF-8DEB-47F4-84C0-FFA5BAF9D5A9

Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?

Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure? A. In a separate key vault external to the Exadata Infrastructure B. inside the Autonomous Database wallet C. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted D. inside the backups of the container database Correct Answer: A

You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:

You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:* Autonomous Transaction Processing* License Included* Shared InfrastructureWhich parameter would you NOT use? A. db-workload B. is-dedicated C. db-type D. license-model Correct Answer: B https://docs.oracle.com/en-us/iaas/tools/oci-cli/2.9.9/oci_cli_docs/cmdref/db/autonomousdatabase/ create.html

Which two options are available to restore an Oracle Autonomous Database?

Which two options are available to restore an Oracle Autonomous Database? A. Specify the point in time (timestamp) to restore. B. Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up. C. Select the backup from which restore needs to be done. D. Specify the archived custom image. E. Select the snapshot of the backup.… Read More »

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 »