Free Oracle 1Z0-931 Exam Dumps Questions & Answers

What are three methods to load data into the Autonomous Database? (Choose three.)

• A.  Transportable Tablespace
• B.  SQL*Loader
• C.  Oracle GoldenGate
• D.  Oracle Data Pump
• E.  RMAN Restore

Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?

• A.  Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.
• B.  Adding, removing, or modifying tablespaces is allowed.
• C.  Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to.
• D.  In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.

What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)

• A.  Golden Gate
• B.  Data Pump
• C.  Recovery Manager (RMAN)
• D.  CSV files copied to Autonomous Database block storage

Which statement about the Export Wizard used to export database objects and data is NOT correct?

• A.  If "Grants" is checked as a DDL Option, GRANT statements are included for any grant objects on the exported objects, including those owned by the SYS schema.
• B.  If "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that it can be pasted into a file, a command line, or other location appropriate for the format.
• C.  If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported.
• D.  Export DDL includes features such as "Show schema," "Storage," and "Terminator."

The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).
Which statement is true about the migration of the application's database success?

• A.  The tablespace names will result in a blocking error during datapump import because of ADB limitations.
• B.  The migration can be technically a success but the 3-rd party vendor needs to support the result.
• C.  The migration can be a success, both technically and functional due to datapump enhancements.
• D.  The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.