ADB Practice Exam Questions and
Answers
1
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous
Database? (Choose two.) - Answer-A. Data Pump can exclude migration of objects like indexes and
materialized views that are not needed by Autonomous Database.
B. Data Pump is platform independent - it can migrate Oracle Datbases running on any platform
2
The default eight-day retention period for Autonomous Database performance data can be modified
using which DBMS_WORKLOAD_REPOSITORY subprogram procedure? - Answer-
MODIFY_SNAPSHOT_SETTINGS
3
Which task is NOT automatically performed by the Oracle Autonomous Database? - Answer-B. Mask
your sensitive data.
4
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.) -
Answer-B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object 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 options specified for
the external table in a badfile table or ADW
E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the
cloud. You can run queries on external data from the Autonomous Data Warehouse.
5 Which of these database features is NOT part of the Autonomous Database? - Answer-D. Java in the
Database
6 Which two statements are true with regards to Oracle Data Sync? (Choose two.) - Answer-A. Data
Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
C. Data Sync can load your data in parallel in order to speed up the loading process.
7 Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)? - Answer-
C. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE)
wallet.
8
What is the predefined role that exists in Autonomous Database that includes common privileges that
are used by a Data Warehouse developer? - Answer-C. DWROLE
9 Which two system privileges does a user need to create analytic views? (Choose two.) - Answer-D.
CREATE ANALYTIC VIEW
E. CREATE ATTRIBUTE DIMENSION
10 What are three methods to load data into the Autonomous Database? (Choose three.) - Answer-A.
Oracle GoldenGate
D. Oracle Data Pump
Answers
1
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous
Database? (Choose two.) - Answer-A. Data Pump can exclude migration of objects like indexes and
materialized views that are not needed by Autonomous Database.
B. Data Pump is platform independent - it can migrate Oracle Datbases running on any platform
2
The default eight-day retention period for Autonomous Database performance data can be modified
using which DBMS_WORKLOAD_REPOSITORY subprogram procedure? - Answer-
MODIFY_SNAPSHOT_SETTINGS
3
Which task is NOT automatically performed by the Oracle Autonomous Database? - Answer-B. Mask
your sensitive data.
4
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.) -
Answer-B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object 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 options specified for
the external table in a badfile table or ADW
E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the
cloud. You can run queries on external data from the Autonomous Data Warehouse.
5 Which of these database features is NOT part of the Autonomous Database? - Answer-D. Java in the
Database
6 Which two statements are true with regards to Oracle Data Sync? (Choose two.) - Answer-A. Data
Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
C. Data Sync can load your data in parallel in order to speed up the loading process.
7 Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)? - Answer-
C. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE)
wallet.
8
What is the predefined role that exists in Autonomous Database that includes common privileges that
are used by a Data Warehouse developer? - Answer-C. DWROLE
9 Which two system privileges does a user need to create analytic views? (Choose two.) - Answer-D.
CREATE ANALYTIC VIEW
E. CREATE ATTRIBUTE DIMENSION
10 What are three methods to load data into the Autonomous Database? (Choose three.) - Answer-A.
Oracle GoldenGate
D. Oracle Data Pump
