Online Access Free 1Z1-931 Practice Test

Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

• A.Replicate the table using Golden Gate
• B.Create a Data Set
• C.Import Table
• D.Load data using Data Pump

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

• A.using DBMS_CLOUD_ADMIN package
• B.through the Oracle Cloud Infrastructure service console
• C.through SQLPIus
• D.through SQL/Developer s

In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

• A.In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.
• B.In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.
• C.In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.
• D.In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.

Which statement is true in regards to database links?

• A.Connect to Autonomous Database from remote database using a database link.
• B.You can call PL/SQL procedures and functions using a database link.
• C.Create a database link from one Autonomous Database to another Autonomous Database instance.
• D.Connect from Autonomous Database to remote database using a database link.

Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?

• A.Unplug into a pdb archive which can be uploaded to object storage.
• B.Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
• C.Create a database link from source database to the ADB environment and clone the PDB.
• D.Unplug to an xml file so database files and xml file can be uploaded to object storage.