1z0-931 Practice Exam Questions with Answers Oracle Autonomous Database Cloud 2019 Specialist Certification

- By patching, Oracle patch the full stack—including the firmware, the OS, clusterware, and the database.

- Autonomous Database automatically backs up your database for you

The Oracle Autonomous Database is the integration of the Oracle Database running on the Exadata platform with our complete infrastructure automation and our fully automated data center operations. Automated data sections include provisioning, patching, upgrading, and online backups, monitoring, scaling, diagnosing, performance tuning, optimizing, testing, and change management of complex applications and workloads, and automatically handling failures and errors.

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846

SQL Developer is a free integrated development environment (IDE) provided by Oracle that simplifies the development and management of Oracle databases. A Java based platform, this IDE can run on Linux, Mac OS X, and Windows platforms. SQL Developer facilitates database migrations by providing options to use Oracle tools like Data Pump export, database copy, and SQL'Loader

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/sql-developer-web.html#GUID-102845D9-6855-4944-8937-5C688939610F

When you download the client credentials from the Download Wallet dialog, you must enter a wallet password in the password field and confirm the password in the confirm password field. The password must be at least eight characters long and must include at least one letter and one numeric character or one special character. This password protects the download client credentials wallet. This wallet is not the same as the transparent data encryption wallet for the database. Therefore, a different password is used to protect the client credentials wallet.

Optimizer Hints Ignored by default in ADW, where honored by default in ATP

When migrating data to Autonomous Database, table statistics are gathered automatically during direct path load operations. If direct path load operations are not used, such as with SQL Developer loads, the user can gather statistics manually as needed. When migrating an existing database that uses optimizer in parallel hints, ADB will ignore those by default. Because ADB runs in a highly tuned exadata environment, most database operations should run faster or at least as well as database tune with lots of hints to perform faster. Should hints be required for some reason, they can be explicitly re-enabled.

Autonomous Data Warehouse ignores optimizer hints and PARALLEL hints in SQL statements by default

The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.

In the current release you cannot use physical migration methods like backup/restore. Data Guard, database clones, and transportable tablespaces to move your existing database to ADB.

https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#MIGRATION