Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
A. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
B. The source files can reside inOracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
C. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
D. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
E. The target table will be created in Autonomous Database if it does not already exist.
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?
A. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.
B. Moving an Autonomous Database instance does not include its automatic backups.
C. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
D. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
What are three methods to load data into the Autonomous Database?
A. Oracle GoldenGate
B. Transportable Tablespace
C. RMAN Restore
D. Oracle Data Pump
E. SQL*Loader
Which two methods canyou use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure A. service console
A. SQL Developer
B. the DBMS_CLOUD_ADMIN package
C. SQL *Plus
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. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
B. Create a database link from source databaseto the ADB environment and clone the PDB.
C. Unplug to an xml file so database files and xml file can be uploaded to object storage.
D. Unplug into a pdb archive which can be uploaded to object storage.
What is the correct way to list all files in the default data pump directory?
A. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
B. You cannot list files in the default data pumpdirectory from Autonomous Data Warehouse (ADW).
C. Log onto ADW server and issue is -al on the command line.
D. By executing select * from utl_file . list ( `DATA_PUMP_DIR ' ) ;
Which is NOT needed to manage Oracle Autonomous Database with REST APIS?
A. User's OCID
B. Tenancy's OCID
C. Database ADMIN password
D. Fingerprint of the public key
Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?
A. Oracle Cloud Infrastructure Object Storage Classic
B. Oracle Cloud Infrastructure Object Storage
C. Google Cloud Storage
D. Amazon S3
E. Azure Blob Storage
Which two statements are true about Data Insights?
A. You can retrieve previously executed Data Insights searches.
B. Data Insights is available with on-premises deployments of Oracle Database.
C. Data Insights is an additional priced option.
D. You can search for Data Insights against a base table or business model.
Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is stopped.
Which statement is true?
A. The standby database is terminated.
B. The standby database is also stopped.
C. Switchover is automatically initiated.
D. Failover is automatically initiated.
