Oracle adb Study guides, Class notes & Summaries

According to Oracle documentation, What is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups? - create at least 2 of each reosurce - only 1 subnet and 1 compartment allowed, multiple groups highly advised - Only 1 of each is allowed to be allocated per environment - Create a sep VCN that contains only public subnets - Create at least 2 of each resource During the provisioning of an Autono...

Which three event types are supported for Autonomous Database? (Choose three) - Update IORM Begin -Maintenance Begin -Terminate End -Change Autoscaling Configuration Compartment -Change Compartment Begin - Correct Answer -Maintenance Begin* -Terminate End* -Change Compartment Begin* When in the SQL Monitoring tab the Performance Hub you see a clock icon in the status column, What does this mean? - the SQL statement is executing - The SQL statement did not complete either due to a...

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 non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBAManager 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 meets their strict performance requirements...

Which are the things required for provisioning an ADB instance? (Choose three) - FRA Size - Database name - Workload type - Backup location - Number of tablespaces - Number of CPUs - - Database name - Workload type - Number of CPUs From where can you create Oracle Machine Learning users? - From the Admin Password tab from the Details tab - From the Administration tab in the Service Console - From the Activity tab in the Service tab - From the Overview tab in the Service Console - Fr...

Which three tasks by default are taken care of by the Autonomous Database? (Choose three.) a. Database Upgrades b. Firmware Patching c. Application User Creation d. Data Loading e. Backups a. Database Upgrades b. Firmware Patching e. Backups What are two security features enabled by default by the Autonomous Database? (Choose two.) a. Transparent Data Encryption b. One SYSDBA account c. Encrypted Database Links d. SQL Net Encryption e. Read Only access to OS Audit logs ...

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? Options are : Run the PBMS_CLOUD. INCREASE_THROUGHPUT procedure. Ask Support to migrate their setup to a node without noisy neighbors. Increase the number of OCPUs allocated to the database. Remove any non-JSON data from the database. - Increase the number of OCPUs allocated to the database. (Corr...

OCI Developer Exam Questions and Answers What is the open source engine for Oracle Functions? - Apache OpenWhisk - Open FaaS - Knative - Fn Project -Answer-Fn Project Which two are benefits of a distributed systems? - Privacy - Ease of testing - Resiliency - Security - Scalability -Answer-- Resiliency - Scalability You are implementing logging in your services that will be running in OCI Container Engine for Kubernetes. Which statement describes the appropriate logging approach? -...

OCI Developer Exam Questions and Answers What is the open source engine for Oracle Functions? - Apache OpenWhisk - Open FaaS - Knative - Fn Project -Answer-Fn Project Which two are benefits of a distributed systems? - Privacy - Ease of testing - Resiliency - Security - Scalability -Answer-- Resiliency - Scalability You are implementing logging in your services that will be running in OCI Container Engine for Kubernetes. Which statement describes the appropriate logging approach? -...

In case of migration using the RMAN DUPLICATE command, which file do you use to specify the location of the Database Wallet? WALLET.ORA TNSNAMES.ORA LISTENER.ORA SQLNET.ORA SQLNET.ORA Which architecture is followed by Oracle Data Integrator (ODI)? EBS ETL EPM ELT ELT Which statements are true for Zero Downtime Migration? (Choose two)(Choose all correct answers) It is a complex process that requires you to raise an SR with Oracle Support. It ensures zero data loss. It is free...

1 What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.) - A. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database. B. Data Pump is platform independent - it can migrate Oracle Datbases running on any platform 2 The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure...