Oracle Autonomous DB Object Storage Data Loading

1. What is the maximum file size supported for a single Object Storage object in Autonomous Database loading?

100 MB

1 GB

5 GB

Unlimited

2. Which privilege is required to execute DBMS_CLOUD.CREATE_CREDENTIAL in Autonomous Database?

CREATE SESSION

EXECUTE on DBMS_CLOUD package

ADMIN role

RESOURCE role

3. True or False: Autonomous Database requires manual index creation after loading data with DBMS_CLOUD.COPY_DATA.

True

False

4. What is the purpose of the PARALLEL parameter in DBMS_CLOUD.COPY_DATA?

Enable multi-threaded data loading

Load multiple files concurrently

Run queries in parallel during import

Distribute data across partitions

5. Which view provides information about data load jobs initiated by DBMS_CLOUD procedures?

DBA_LOAD_OPERATIONS

USER_LOAD_JOBS

DBA_CLOUD_JOBS

V$CLOUD_OPERATIONS

6. True or False: Data Pump exports from Autonomous Database are encrypted by default when written to Object Storage.

True

False

7. What does the SKIP_HEADERS parameter do in DBMS_CLOUD.COPY_DATA?

Removes column headers from loaded data

Skips the first N rows of the source file

Omits header rows in export

Ignores column name validation

8. Which authentication method is preferred for Autonomous Database to Object Storage integration in production?

Database user credentials

Oracle Cloud authentication tokens

API keys and OCI IAM policies

Hard-coded passwords in PL/SQL

9. True or False: Oracle Autonomous Database automatically compresses data when loading from Object Storage.

True

False

10. When loading CSV data, what parameter controls the delimiter character in DBMS_CLOUD.COPY_DATA?

Delimiter

Field_delimiter

Field_terminator

Column_separator

11. What is the primary advantage of using Oracle Cloud Object Storage with Autonomous Database?

Unlimited compute resources for queries

Scalable, cost-effective external storage for data staging

Automatic schema optimization

Real-time data encryption at rest only

12. Which Data Pump mode is used to transfer data between databases via Object Storage?

EXPDP with NETWORK_LINK

IMPDP with CLOUD parameter

EXPDP followed by IMPDP

TRANSFER_MODE in DBMS_DATAPUMP

13. True or False: Autonomous Database can directly access files in Object Storage without creating a credential.

True

False

14. What is required to authenticate Autonomous Database to Object Storage using a credential?

Database user password only

Oracle Cloud user credentials and authentication token

SSH key pair

IP whitelist configuration

15. Which file format is NOT directly supported by DBMS_CLOUD.COPY_DATA for data loading?

CSV

Parquet

JSON

Excel spreadsheet

16. What parameter specifies the Object Storage bucket URI in a DBMS_CLOUD.COPY_DATA call?

File_uri_list

Bucket_location

Storage_path

Cloud_uri

17. When using Data Pump to export from Autonomous Database, what is the default target location?

Local file system

Object Storage

Database directory

Network location

18. Which DBMS_CLOUD procedure is used to load data from Object Storage into a table?

DBMS_CLOUD.COPY_DATA

DBMS_CLOUD.COPY_TABLE

DBMS_CLOUD.IMPORT_TABLE

DBMS_CLOUD.LOAD_DATA

19. What is the correct syntax to create a credential object for Object Storage access in Autonomous Database?

CREATE CREDENTIAL with username and password

BEGIN DBMS_CLOUD.CREATE_CREDENTIAL; END;

ALTER DATABASE ADD CREDENTIAL

GRANT CREDENTIAL ON OBJECT_STORAGE

20. Which tool is most commonly used for bulk data loading into Autonomous Database?

SQL*Loader

Oracle Data Pump

Oracle APEX

Database Configuration Assistant

Oracle Autonomous DB Object Storage Data Loading Quiz

1. What is the maximum file size supported for a single Object Storage object in Autonomous Database loading?

2.

What first name or nickname would you like us to use?

2. Which privilege is required to execute DBMS_CLOUD.CREATE_CREDENTIAL in Autonomous Database?

3. True or False: Autonomous Database requires manual index creation after loading data with DBMS_CLOUD.COPY_DATA.

4. What is the purpose of the PARALLEL parameter in DBMS_CLOUD.COPY_DATA?

5. Which view provides information about data load jobs initiated by DBMS_CLOUD procedures?

6. True or False: Data Pump exports from Autonomous Database are encrypted by default when written to Object Storage.

7. What does the SKIP_HEADERS parameter do in DBMS_CLOUD.COPY_DATA?

8. Which authentication method is preferred for Autonomous Database to Object Storage integration in production?

9. True or False: Oracle Autonomous Database automatically compresses data when loading from Object Storage.

10. When loading CSV data, what parameter controls the delimiter character in DBMS_CLOUD.COPY_DATA?

11. What is the primary advantage of using Oracle Cloud Object Storage with Autonomous Database?

12. Which Data Pump mode is used to transfer data between databases via Object Storage?

13. True or False: Autonomous Database can directly access files in Object Storage without creating a credential.

14. What is required to authenticate Autonomous Database to Object Storage using a credential?

15. Which file format is NOT directly supported by DBMS_CLOUD.COPY_DATA for data loading?

16. What parameter specifies the Object Storage bucket URI in a DBMS_CLOUD.COPY_DATA call?

17. When using Data Pump to export from Autonomous Database, what is the default target location?

18. Which DBMS_CLOUD procedure is used to load data from Object Storage into a table?

19. What is the correct syntax to create a credential object for Object Storage access in Autonomous Database?

20. Which tool is most commonly used for bulk data loading into Autonomous Database?