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 two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

A. Undo Management

B. Index Storage

C. Memory Usage

D. Data Organization

E. Backup Retention

Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?

A. Current settings for ACLs are cloned.

B. Clone can be in a different region.

C. All OML notebooks are cloned.

D. All underlying data for OML notebooks is cloned.

E. All resource management rules are cloned.

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should youdo?

A. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database

B. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"

C. Create a notification alert using DBMS_SNMP package

D. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric

Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

A. Use SFTP to copy CSV files into Autonomous Database

B. Use Oracle Zero Downtime Migration (ZDM)

C. Use Recovery Manager (RMAN)

D. Use GoldenGate

E. Use Data Pump

Which statement is FALSE about Oracle Autonomous JSON Database?

A. JSON data is stored natively in the database

B. You can promote Autonomous JSON Database to Autonomous Transaction /Processing

C. It supports NoSQL-style, document-centric application

D. There is a 20 GB limit on JSON collection

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

A. The SQL statement completed its execution.

B. The SQL statement is executing.

C. TheSQL statement is queued.

D. The SQL statement did not complete either due to an error.

Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

A. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.

B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores CloudObject Storage credentials in the Autonomous Data Warehouse database.

C. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format optionsspecified for the external table in a badfile table on Autonomous Data Warehouse.

D. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.

E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates anexternal table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

A. Autonomous Transaction Processing only

B. ATP and ADW

C. Autonomous Data Warehouse only

D. Hybrid Columnar compression

Which three of the following data sources are available when using the Data Load page on Database Actions?

A. Files in Oracle Cloud Storage

B. Backup files in block storage

C. Local Files

D. Files in AWS S3 Storage

E. REST endpoints